topic Re: Oracle Autonomous Datawarehouse ADW connectivity issue version 18 in Talend Studio

Oracle Autonomous Datawarehouse ADW connectivity issue version 18

Anonymous — Sat, 16 Nov 2024 03:13:58 GMT

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

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

Re: Oracle Autonomous Datawarehouse ADW connectivity issue version 18

Anonymous — Tue, 10 Mar 2020 08:12:04 GMT

Hello,

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

Re: Oracle Autonomous Datawarehouse ADW connectivity issue version 18

Anonymous — Tue, 28 Jun 2022 10:23:02 GMT

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