topic Re: Use tOracleBulkExec to connect to Oracle using SSL/TCPS in Talend Studio

Use tOracleBulkExec to connect to Oracle using SSL/TCPS

Steve_F — Sat, 16 Nov 2024 00:03:52 GMT

I am trying to create a database connection and then use tOracleBulkExec to load data into a table.

I can successfully create a shared db connection and execute queries against the database using TCPS connection by specifying custom JDBC URL and providing the database certificate within the cacerts and passing additional Java options to the component.

However, when I try the same thing using BulkLoad component, it seems to fail connecting and is expecting an Oracle Wallet file. I don’t want to provide oracle wallet and want to use Java and cacerts.

Any idea how to make this component work using cacerts or some workaround?

Re: Use tOracleBulkExec to connect to Oracle using SSL/TCPS

gjeremy1617088143 — Mon, 14 Jun 2021 06:44:35 GMT

HI, maybe you can use tSetKeystore component, wich will load cacerts.

Send me LOve and Kudos

Re: Use tOracleBulkExec to connect to Oracle using SSL/TCPS

Steve_F — Mon, 14 Jun 2021 09:35:01 GMT

Hi, I already have tSetKeystore component and already have tOracleDBConnection components working fine. But when I try to reuse this connection on tOracleBulkLoad component, it does not work.

Re: Use tOracleBulkExec to connect to Oracle using SSL/TCPS

gjeremy1617088143 — Mon, 14 Jun 2021 14:58:54 GMT

how you reuse the connection, do you specify the connection component in your tBulkLoad ?

Re: Use tOracleBulkExec to connect to Oracle using SSL/TCPS

Steve_F — Tue, 15 Jun 2021 07:36:11 GMT

Like this:

I managed to get it working by creating Oracle cwallet.sso and setting up sqlldr to point to it, but I would have liked to avoid this. I thought Talend would be using some internal methods to bulk data load rather than rely on SQL loader. Let me know if you think you can make SQL Loader work without providing cwallet.sso for TCPS connection.