Oracle Autonomous Datawarehouse ADW connectivity issue version 18

[Anonymous]

I am unable to get connected to ADW through talend. Here for version Oracle18 I don't find anything to upload the wallet path. If anyone is able to connect to ADW  please help me.

Here are our connection details provided:

DB Type: Oracle Custom

DB Version: Oracle 18

Login: XXXX

Password: XXXX

String of Connection:

jdbcracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=adb.XXXX.oraclecloud.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=XXXX_XXXX_high.adwc.oraclecloud.com)))

Schema: XXXX

Additional Parameters: javax.net.ssl.trusStoreType=SSO & javax.net.ssl.KeyStoreType=SSO

[Anonymous]

Hello,

I'm facing the same problem, did you solved it ?

[Anonymous]

Hello,

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