topic Re: How to connect Oracle Automnomous Data Warehouse Cloud in Talend Studio

How to connect Oracle Automnomous Data Warehouse Cloud

Anonymous — Mon, 09 Jul 2018 10:10:14 GMT

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 ?

Re: How to connect Oracle Automnomous Data Warehouse Cloud

Anonymous — Tue, 10 Jul 2018 08:52:42 GMT

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

Re: How to connect Oracle Automnomous Data Warehouse Cloud

Anonymous — Tue, 10 Jul 2018 15:33:25 GMT

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

Re: How to connect Oracle Automnomous Data Warehouse Cloud

Anonymous — Wed, 11 Jul 2018 03:33:10 GMT

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

Re: How to connect Oracle Automnomous Data Warehouse Cloud

Anonymous — Wed, 11 Jul 2018 10:32:06 GMT

I am able to connect using sqlplus and sqldeveloper

Re: How to connect Oracle Automnomous Data Warehouse Cloud

Anonymous — Tue, 27 Aug 2019 12:18:42 GMT

Hi Otal,

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

Re: How to connect Oracle Automnomous Data Warehouse Cloud

Anonymous — Tue, 25 Feb 2020 16:52:03 GMT

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.