Connect to MySQL, MongoDB in SSIS using SSH Tunnel / Local Port Forwarding Technique

Question:

I have requirement to connect to MongoDB or any other data base e.g. MySQL, PostgreSQL securely using SSH. Is it possible to do that using SSIS MongoDB Source ?

Answer:

We do not have native feature to support SSH in MongoDB Connection Manager.  

However workaround is pretty simple using below steps.

1. Using SSH Local Port forward technique you can create SSH Tunnel for any App which doesn't have inbuilt SSH Feature. Here is how you can do it.
   
   Install any good SSH Client (e.g. PuTTy) on the same machine where SSIS Package is running... 
2. In SSH Client setup Local Port Forwarding https://blog.devolutions.net/2017/4/how-to-configure-an-ssh-tunnel-on-putty  
3. Modify your SSIS Connection to use localhost as MongoDB Server and adjust port if needed (incase you used non standard Local Port on SSH Client)

Thats it... now any time you run package all your requests to localhost will first go to SSH Client running on local machine... and then it will forward requests to remote machine.

Here are some other SSH Clients you may consider
https://www.ssh.com/ssh/client

And some blog posts to explain Port Forwarding Process
https://www.ssh.com/ssh/tunneling/example#sec-Local-Forwarding

Video:

https://www.youtube.com/watch?v=7YNd1tFJfwc

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/