How to connect Oracle Automnomous Data Warehouse Cloud

[Anonymous]

I am trying to connect Talend Open studio 6.1 to an Oracle Automnomous Data Warehouse Cloud.

I couldn't find a connection type dedicated to this  use case. The autonomous database requires to be provided a wallet, but this option is not available with current Oracle cloud databases connections.

Is there a tutorial on this subject to show this use case and how to connect Talend to ADWC and how to type the ADWC Wallet to Talend ? 

[Anonymous]

Hello,.

Could you please take a look at this new feature jira issue to see if it is what you are looking for?

https://jira.talendforge.org/browse/TUP-18755.

Best regards

Sabrina

[Anonymous]

Hello,

Thank you for your answer, I downloaded version 7.0.1 to test the connection,

I tried to several connectors tOracleInput/tDBConnection(Oracle) with WALLET connection type and ORACLE CUSTOM connection type.

I always get the following error:

Exception in component tDBInput_1 (test)
java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "hostort:sid"
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at local_project.test_0_1.test.tDBInput_1Process(test.java:530)
    at local_project.test_0_1.test.runJobInTOS(test.java:945)
    at local_project.test_0_1.test.main(test.java:796)
Caused by: oracle.net.ns.NetException: Invalid connection string format, a valid format is: "hostort:sid"
    at oracle.net.resolver.AddrResolution.resolveSimple(AddrResolution.java:510)
    at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:441)
    at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594)
    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229)
    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)

Do you know what connector handles the connection according to the jira?

Or is there a problem with given settings?

db_connection.JPG

[Anonymous]

Hello,

Are you connection parameters OK with you? Are you able to connect Oracle Automnomous Data Warehouse Cloud successfully without using talend tool?

Best regards

Sabrina

[Anonymous]

I am able to connect using sqlplus and sqldeveloper

[Anonymous]

Hi Otal,

Were you able to connect to OADW successfully? If so, please let me know the process. Thank you!

[Anonymous]

Hey Guys

Were you able to connect to ADW. If yes please let me know how to connect. I am using Oracle 18 but not able to connect it.