February 19, 2020 at 4:12 pm
Hey guys, I need to connect to an Oracle Cloud database inside ssis. Can someone point me to a tutorial how to go about doing this?
Thanks
February 19, 2020 at 6:48 pm
This is going to be quite difficult to accomplish - because the Oracle Cloud instance requires an SSH tunnel before you can connect. Generally, the SSH tunnel is setup and configured per user session - and SSIS (when deployed to a server) would not be able to make the connection because the SSH tunnel does not exist.
You should look at CozyROC to see if their SSH connection would work for this application.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 6, 2020 at 3:17 am
This is going to be quite difficult to accomplish - because the Oracle Cloud instance requires an SSH tunnel before you can connect. Generally, the SSH tunnel is setup and configured per user session - and SSIS (when deployed to a server) would not be able to make the connection because the SSH tunnel does not exist. happy wheels
You should look at CozyROC to see if their SSH connection would work for this application.
Thank you for all your advice.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply