Hello Lovely community,
I am new to NiFi, I am able to connect to mysql dummy database from Nifi and everything works fine.
But I want to understand how can we connect to databases that use SSH tunneling..
Because I have not seen any properties related to SSH in the database processors.
My processors being used is "capturechangeMysql"
This source DB server is secured and I need SSH tunnel to make the connection.
I have 100 such sources. Should I add my nifi server ssh keys in all the source servers ? and even then where can i give the SSH tunnel information? and the private key..
Because while using any SQL client we can use the tunnel along with main DB username and password as shown in attached screen, but for Nifi I am not able to see a way..
Please help me with your suggestions.. /\SSH tunnel