How to connect to Oracle Cloud Database in SSIS

  • dndaughtery

    SSChampion

    Points: 11261

    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

  • Jeffrey Williams

    SSC Guru

    Points: 88449

    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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • angelaterry

    Grasshopper

    Points: 11

    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 2 weeks, 3 days ago by  angelaterry.

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

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