Hi everyone,
I've scoured the documentation in vain and hoping the community can ride to my rescue again.
I'm trying to connect to a MS SQL database using an SSH tunnel. Is this supported by Matillion ETL, and if so what is the recommended process for configuring the connection?
I've found various posts regarding not being possible in Data Loader and some suggesting it's possible in Matillion ETL, but would appreciate some pointers.
Hi @jamielaird-aimpointdigital,
That's a great question. I think support might have to help you with this one. There are a ton of variables at play when introducing proxies or ssh boxes between the client and server. The configuration of the SSH box is a very large factor and whether the SQL Server is setup to except the requests coming through the SSH.
Are you able to make a connection to the SQL Server through SSH with a client other than Matillion? If you can do it today then I suspect there is a way to accomplish what you are attempting. I probably didn't help all that much but hopefully spawned some thoughts.
Thanks @Bryan. I can connect using other clients, so I'll reach out to support as you suggest. Networking stuff is always a fun challenge 😅