How to connect to Oracle Cloud Database in SSIS

  • 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

  • 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

  • Jeffrey Williams wrote:

    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.

    • This reply was modified 4 years, 7 months ago by  angelaterry.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply