Step by step to connect Oracle Autonomous Database

[Anonymous]

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

[fdenis]

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

[Anonymous]

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

[fdenis]

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

[Anonymous]

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

[fdenis]

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

[Anonymous]

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

[Anonymous]

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

[tale103108]

GuiSobreira, your images are no longer in your answer.