Automic Workload Automation

 View Only

SQL Agent, connect to Oracle with Wallet

  • 1.  SQL Agent, connect to Oracle with Wallet

    Posted Oct 25, 2020 04:00 AM
    Hi Guys, 
    I have been looking into connecting with a SQL Agent to an Oracle DB provided on the Oracle Cloud. By default from what I can see they provide you a wallet with all the credentials, SSL keys etc. 

    Has anyone got any experience with such a connection? What do you use generic JDBC? OCI ? 

    I am a total noob when it comes to such an authentication way, maybe somebody could point the way? 

    I have been trying the JDBC instructions (with generic JDBC connection / agent) but failed just at the beginning as the JDBC string provided by Oracle seem not to be accepted by Automic :) 


    ------------------------------
    Cheers,
    Marcin
    ------------------------------