topic Re: Use of toracleBulkExec for Job Performance Optimization in Talend Studio

Use of toracleBulkExec for Job Performance Optimization

abhi90 — Sat, 16 Nov 2024 08:14:38 GMT

Hi All,

Have anyone successfully implemented toracleBulkexec if the Database is rds? My Database is hosted in rds and connection string is xxxx.rds.amazonaws.com. My Datafile is generating perfectly in my Local. But when it is entering in toraclebulkexec it is throwing an error

SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]

I have tested toraclebulkexec in my Home Laptop where I am using sql developer which improves performance a lot. If any suggestions Please let me know

Re: Use of toracleBulkExec for Job Performance Optimization

vapukov — Mon, 21 May 2018 22:39:25 GMT

with AWS(RDS) - always something different compare to dedicated server

for each tBulk components - file must be local for database (located on same server with Oracle)
https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/E~fTfv77DEMgwnN891mP_g

You need more check about Import/Export for Oracle on RDS, and may be implement different solution:

- export data to EC2

- use command to import data
read more - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

Re: Use of toracleBulkExec for Job Performance Optimization

abhi90 — Tue, 22 May 2018 09:42:04 GMT

Hi @vapukov,

Thanks for your reply. actually We are doing our Project Development Works in Open Studio. Don't have EC2 Now. Can You tell me where should I create my Data File?

Re: Use of toracleBulkExec for Job Performance Optimization

vapukov — Tue, 22 May 2018 09:45:52 GMT

with this question - could not help, because I have not Oracle on RDS

Re: Use of toracleBulkExec for Job Performance Optimization

abhi90 — Tue, 22 May 2018 14:45:00 GMT

Hi @xdshi, @shong,

Can You please suggest on here where I can create the Datafile