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

Question:

I have requirement to connect to MongoDB or any other database e.g. MySQL, PostgreSQL, Redshift securely using SSH. Is it possible to do that using SSIS MongoDB Source or other connection manager (e.g. Redshift / PostgreSql)?

Answer:

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

However, workaround is pretty simple using the below steps.

1. Using the SSH Local Port forward technique you can create SSH Tunnel for any App which doesn't have an 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/04/how-to-configure-an-ssh-tunnel-on-putty/  
3. Modify your SSIS Connection to use localhost as Host name (Server / IP) and adjust the port if needed (incase you used nonstandard Local Port on SSH Client) 

Thats it... now any time you run the package all your requests to localhost will first go to SSH Client running on local machine... and then it will forward requests to the 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 Tutorial (Setup SSH Port Forwarding):

Here is a small video on how to setup Encrypted Tunner from client to Server using PuTTy SSH Tunnel feature. 

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/