topic Step by step to connect Oracle Autonomous Database in Talend Studio

Step by step to connect Oracle Autonomous Database

Anonymous — Sat, 16 Nov 2024 03:38:51 GMT

Hi all,

I am new on Talend, read many discussions in the forums, tried few options, but did not have success yet.

We have the Oracle Autonomous Database (18c version), and are trying to connect by Wallet and by Service Name.

I did try to connect creating a DB Connection as metadata and also creating a tOracleConnection component in the job, but got connection errors in both options.

Does anyone have a step by step to configure this kind of connection?

Thanks!

Guilherme

Re: Step by step to connect Oracle Autonomous Database

fdenis — Wed, 08 Jan 2020 11:46:58 GMT

did you success connecting your bd from the machine of the studio?

Re: Step by step to connect Oracle Autonomous Database

Anonymous — Wed, 08 Jan 2020 13:02:23 GMT

Hi Francois,

As we are starting our journey in Talend, I am doing it in my local machine first.

I can normally connect to the db in the machine.

Thanks!!

Guilherme

Re: Step by step to connect Oracle Autonomous Database

fdenis — Wed, 08 Jan 2020 14:41:11 GMT

so test
check connection by ODBC
connect from an external sql editor.
check that talend had the right java driver.
good luck

Re: Step by step to connect Oracle Autonomous Database

Anonymous — Thu, 09 Jan 2020 16:35:57 GMT

Hey Francois, thanks for the tips!

I have no idea on the way I should go now...

I checked several drivers, tried to connect via JDBC...

Included wallet information in advanced settings of job testing:

-Doracle.net.tns_admin=C:\Users\GuilhermeS\Wallet_ApexDev

-Doracle.net.wallet_location = (SOURCE = (METHOD = FILE ) ( METHOD_DATA = ( DIRECTORY = C:\Users\GuilhermeS\Wallet_ApexDev )))

Filled the following information in DBConnection:

Got the following error:

Exception in component tDBConnection_1 (test)
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 java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at oracle_connection_test.test_0_1.test.tDBConnection_1Process(test.java:349)
at oracle_connection_test.test_0_1.test.runJobInTOS(test.java:642)
at oracle_connection_test.test_0_1.test.main(test.java:493)
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)
... 8 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)
... 13 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)
... 18 more
Caused by: java.security.KeyStoreException: SSO not found
at java.security.KeyStore.getInstance(Unknown Source)
at oracle.net.nt.CustomSSLSocketFactory.getKeyStoreInstance(CustomSSLSocketFactory.java:765)
at oracle.net.nt.CustomSSLSocketFactory.loadKeyStore(CustomSSLSocketFactory.java:899)
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:608)
... 19 more
Caused by: java.security.NoSuchAlgorithmException: SSO KeyStore not available
at sun.security.jca.GetInstance.getInstance(Unknown Source)
at java.security.Security.getImpl(Unknown Source)
... 23 more

Re: Step by step to connect Oracle Autonomous Database

fdenis — Fri, 10 Jan 2020 08:56:21 GMT

@nthampi did you have any idea to solve this trouble ?

Re: Step by step to connect Oracle Autonomous Database

Anonymous — Fri, 10 Jan 2020 14:00:38 GMT

Hi,

Unfortunately I have not got an opportunity to play with Oracle Autonomous DB till now. Lets check with @rhall and @xdshi

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Step by step to connect Oracle Autonomous Database

Anonymous — Mon, 03 Feb 2020 11:33:06 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: Step by step to connect Oracle Autonomous Database

tale103108 — Tue, 14 Jun 2022 20:28:16 GMT

GuiSobreira, your images are no longer in your answer.