How to connect to Oracle Autonomous DB using talend?

[Anonymous]

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!

[igorp]

Hey there, 

I'm experiencing similar issues - Locally, I can run the jobs, but i'm not sure how to set up Trust Store and KeyStore .jks files on Talend Cloud, or to import/embed them in the job itself. 

Would really appreciate if anyone has any input for this! 

Thanks! 

[Xiaodi_Shi]

Hello @igorp 

I found this article which discusses how to connect to Oracle Autonomous DW :Creating a connection from Talend ETL Tool to Oracle Autonomous Data Warehouse

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

In the guide it talks about SSL authentication. 

Best regards

Sabrina

[igorp]

Thanks @Xiaodi_Shi for the reply! 

This is helpful documentation, but it works only when running local jobs, as stated on page 6 (see ss below). 

My question is how and where to set/embed/import either wallet files or keystore/truststore files within my job so a cloud engine/remote engine recognises that the job has all SSL files needed?

In this example above, it is just pointing to the cwallet within a directory on our local machine.  If a job contains this connection, gets "Published to Cloud" from Talend CDI, and run/executed on Talend Cloud/Management Console with the use of Cloud Engine as processor, the Cloud engine normally can not find these files on my local machine and the job run will fail. 

 Hope this helps and thank you all for your responses. 

[Xiaodi_Shi]

Hello,

You are able to upload your truststore or keystore file from Local to Cloud(resources).

In your Job, define two context variables: context.resource_file_truststore and context.resource_file_keystore and use these two context variables in the tSetKeyStore component.

Note: tSetKeyStore component supports for data type between PKCS 12 and JKS.

https://community.qlik.com/t5/Official-Support-Articles/Using-a-custom-truststore-or-keystore-for-a-...

https://www.oracle.com/technetwork/database/enterprise-edition/wp-oracle-jdbc-thin-ssl-130128.pdf

Hope these articles helps for your use case.

Best regards

Sabrina