topic Re: How to connect to Oracle Autonomous DB using talend? in Talend Studio

How to connect to Oracle Autonomous DB using talend?

Anonymous — Sat, 16 Nov 2024 04:50:03 GMT

Did anyone try connecting to OADB using Talend? If so, please let us know the process...like which connection type used in it.

Thank you!

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Thu, 29 Aug 2019 08:11:30 GMT

Hello,

There is no specific component for Oracle Autonomous DB in talend. Talend has added support for Oracle Wallet connection as from the 7.0.1 version.

Let us know if these documentations helps.

https://help.talend.com/reader/SY4K8FlNZd1_LG0DB1gAcw/p1K_9AAFy3oI_AtyW4Vyww

https://help.talend.com/reader/SY4K8FlNZd1_LG0DB1gAcw/9pALTDCC6tM17nUc8zgmkQ

https://help.talend.com/reader/JVMPG~OQSVk01lsFQd1O_A/5mFHCGCwsvGUIPNHT3sXZA

Best regards

Sabrina

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Thu, 16 Jan 2020 12:53:50 GMT

Hi @bojareddy ,

Could you connect to Oracle Autonomous DB?

I am trying and facing lot of errors...

Thanks,

Guilherme

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 31 Jan 2020 13:14:26 GMT

Hi GuiSobreira,

Yes, I am able to connect to OADWC using Talend 7.1.1.

Below are the changes to be done to make it work.

Navigate to: $Talend_Home\configuration\.m2\repository\org\talend\libraries\ojdbc7\6.0.0\
Delete the jar file in it.
Navigate to: $Talend_Home\configuration\.m2\repository\org\talend\libraries\ojdbc8\6.0.0-SNAPSHOT\ (OR) Just download the ojdbc8
Copy the jar file and paste it in the location(ojdbc7\6.0.0\) mentioned in step 1 and rename it to the previously deleted file name (ojdbc7-6.0.0).
Restart your Talend studio and try connecting to OADWC.

Please let me know if you have any queries.

Thank you,

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 31 Jan 2020 14:42:08 GMT

Thank you for the information @bojareddy !

I did it, but I still couldn't connect.

The error I have is:

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:209)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1133)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4207)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:801)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:782)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:181)
... 9 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:569)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:521)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:287)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1481)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:540)
... 14 more
Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:344)
at oracle.net.nt.CustomSSLSocketFactory.getSSLContext(CustomSSLSocketFactory.java:305)
at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketEngine(CustomSSLSocketFactory.java:271)
at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:170)
at oracle.net.nt.ConnOption.connect(ConnOption.java:172)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:508)
... 19 more
Caused by: oracle.net.ns.NetException: Unable to initialize the key store.
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:617)
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:322)
... 24 more
Caused by: oracle.security.crypto.asn1.ASN1FormatException: Got tag 0 instead of 16.
at oracle.security.crypto.asn1.ASN1Header.checkTag(Unknown Source)
at oracle.security.crypto.asn1.ASN1ConstructedInputStream.<init>(Unknown Source)
at oracle.security.crypto.asn1.ASN1SequenceInputStream.<init>(Unknown Source)
at oracle.security.crypto.cert.PKCS12.input(PKCS12.java:153)
at oracle.security.crypto.cert.PKCS12.<init>(PKCS12.java:122)
at oracle.security.pki.OracleKeyStoreSpi.load(Unknown Source)
at oracle.security.pki.OracleKeyStoreSpi.engineLoad(Unknown Source)
at oracle.security.pki.OracleSSOKeyStoreSpi.engineLoad(Unknown Source)
at java.security.KeyStore.load(Unknown Source)
at oracle.net.nt.CustomSSLSocketFactory.loadFileBasedKeyStore(CustomSSLSocketFactory.java:922)
at oracle.net.nt.CustomSSLSocketFactory.loadKeyStore(CustomSSLSocketFactory.java:906)
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:608)
... 25 more

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 31 Jan 2020 14:45:08 GMT

Can you share the screenshot of the connection you are trying to make?

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 31 Jan 2020 14:53:44 GMT

Sure...

Here we go...

[image: image.png]

[image: image.png]

I followed this guide:
https://www.oracle.com/a/ocom/docs/database/talend-connection-adw.pdf

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 31 Jan 2020 14:56:12 GMT

The image failed, sorry...

Here I go again..

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 31 Jan 2020 15:26:48 GMT

Can you try below connection string by filling correct details as per your DB. Those details you can find in tnsnames file.
jdbc racle:thin:@(description=(address=(protocol=tcps)(port=1522)(host=))(connect_data=(service_name=))(security=(ssl_server_cert_dn= '')))

Also, in Trust store path and Key store path give the "cwallet.sso" path from the wallet file and leave the password field blank

btw, which version of talend you are using?

Regards,
Boja

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 31 Jan 2020 15:46:49 GMT

Hi, thanks again for your tips, @bojareddy

I am using the version 7.2.1

I put now the full string from my tns names, including the security part.

And I changed the path accordingly, and put blank on the password.

But I still having error:

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:209)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1133)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4207)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:801)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:782)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:181)
... 9 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:569)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:521)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:287)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1481)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:540)
... 14 more
Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:344)
at oracle.net.nt.CustomSSLSocketFactory.getSSLContext(CustomSSLSocketFactory.java:305)
at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketEngine(CustomSSLSocketFactory.java:271)
at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:170)
at oracle.net.nt.ConnOption.connect(ConnOption.java:172)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:508)
... 19 more
Caused by: oracle.net.ns.NetException: Unable to initialize the key store.
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:617)
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:322)
... 24 more
Caused by: java.io.FileNotFoundException: C:\Users\GuilhermeS\Wallet_ApexDev (Access is denied)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at oracle.net.nt.CustomSSLSocketFactory.loadFileBasedKeyStore(CustomSSLSocketFactory.java:918)
at oracle.net.nt.CustomSSLSocketFactory.loadKeyStore(CustomSSLSocketFactory.java:906)
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:608)
... 25 more

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Mon, 03 Feb 2020 11:31:48 GMT

Hi all,

I could successfully connect changing the connection string as follows:

The same works with jdbc connections and using the driver as follows:

Now I am facing some issues in the components OracleInput with Oracle Connection, and I am investigating.

But that is a subject for another discussion.

Thank you all for the help!

Regards,

Guilherme

Re: How to connect to Oracle Autonomous DB using talend?

msdawood — Tue, 14 Sep 2021 17:00:39 GMT

Hi @Guilherme Sobreira

is oracle input error resolved.. I'm also facing the same...connection successfull but failure in oracleinput

Re: How to connect to Oracle Autonomous DB using talend?

tale103108 — Tue, 21 Jun 2022 19:13:22 GMT

Talend 7.3.1

Oracle ADB 19.x

I can connect also via Metadata creation and testing. But I get the following error when trying to use connection in a job:

IO Error: Invalid connection string format, a valid format is: "host:port:sid"

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Wed, 22 Jun 2022 05:04:42 GMT

Hello,

We have replied to your another topic:

https://community.talend.com/s/question/0D55b00007RlPbiCAF/can-connect-to-oracle-adb-19-via-metadata-but-database-connection-fails-when-used-in-talend-job-any-ideas

Could you please take a look at it? Please stick to one topic so that we could pay individual attention to your issue.

Best regards

Sabrina

Re: How to connect to Oracle Autonomous DB using talend?

Jwoodberry — Wed, 13 Jul 2022 10:01:32 GMT

I am Still not get proper Solution?

Anyone

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Thu, 14 Jul 2022 03:14:57 GMT

Hello,

Which Oracle Autonomous DataWarehouse (ADW) are you trying to connect? Are you facing "java.security.KeyStoreException: SSO not found" issue from your side?

If so, here exists a jira issue about: Enable SSL support for Oracle 18 - tOracleConnection

https://jira.talendforge.org/browse/TDI-46913

As OJDBC8.jar is selected with DB Version Oracle 18, but it doesn't have the SSL support.

For Oracle v18 in job need to use tLibraryLoad to make it work with data warehouse.

-oraclepki.jar

-osdt_cert.jar

-osdt_core.jar

Feel free to let us know if it helps.

Best regards

Sabrina

Re: How to connect to Oracle Autonomous DB using talend?

Jwoodberry — Thu, 14 Jul 2022 04:55:19 GMT

I am Still not get proper Solution?

Anyone

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Fri, 15 Jul 2022 03:42:40 GMT

Hello,

Which Oracle Autonomous DataWarehouse (ADW) are you trying to connect? Are you facing "java.security.KeyStoreException: SSO not found" issue from your side?

Best regards

Sabrina

Re: How to connect to Oracle Autonomous DB using talend?

azourane — Wed, 21 Dec 2022 16:43:25 GMT

Hello,

I want to connect to ADW 19.C with talend 7.3, all it ok in repositoy from the studio, but when i run the job, it KO

Arezki

Re: How to connect to Oracle Autonomous DB using talend?

Anonymous — Thu, 22 Dec 2022 08:50:17 GMT

Hello,

What's error message are you getting when run your job?

Please have a look at this related topic to see if the solution in that thread helps?

https://community.talend.com/s/question/0D55b00006QG7CQCA1/oracle-autonomous-datawarehouse-adw-connectivity-issue

Best regards

Sabrina