topic tOracleOutputBulk -tOracleOutputBulkExec in Talend Studio

tOracleOutputBulk -tOracleOutputBulkExec

Anonymous — Sat, 16 Nov 2024 09:42:21 GMT

Hi,

I have a file csv that I want to load in a Oracle Database by using tOracleOutputBulkExec because it is very big. Can you sho me a solution please??

This is my job

Re: tOracleOutputBulk -tOracleOutputBulkExec

TRF — Thu, 01 Jun 2017 14:01:18 GMT

Hi,

I suppose the output flow shcema for the tMap component is aligned on the tOracleOutputBulkExec.

So, what's the problem? You just have to link the tMap to the tOracleOutputBulkExec using the flow definde in tMap.

Or do you have a specific problem not exposed in your initial question?

Re: tOracleOutputBulk -tOracleOutputBulkExec

Anonymous — Thu, 01 Jun 2017 14:06:30 GMT

Yes, i've link them but talend send me a message and then i don't understand what is name file in tOracle.

Re: tOracleOutputBulk -tOracleOutputBulkExec

TRF — Thu, 01 Jun 2017 14:27:46 GMT

As for any tXxxxxOutputBulkExec component, the records are written into a file by the component itself using the format expected by the database or application you want to write into. So you don't have to know this format, just concentrate on what you want to transfer, not how to do that.

So, the filed "Filename", is the name of this file, not the name of the input file (and sometimes, there is not inputfile, for example if the source is an other database).

What is the message you received?

Is it a compilation error or a runtime error?

Re: tOracleOutputBulk -tOracleOutputBulkExec

Anonymous — Thu, 01 Jun 2017 14:48:16 GMT

I don't understand again.

My job is:

and my file csv is in this position:

My tMap is:

And i lin it with tOracleOutputBulkExec, but i don't understaind again the filename:

and talend send me this error message:

I have install Oracle in the Virtual Machine and now i'm working on the localhost. The component tOracleOutput is ok but is is very slow so i want use the bulkOracle.

Thanks again

Re: tOracleOutputBulk -tOracleOutputBulkExec

TRF — Thu, 01 Jun 2017 15:13:29 GMT

When you try to use tOracleOutputBulk operations, you need to install 1st sqlldr which is the dedicated Oracle tool to load external data into databases. This should solve the error you get when running the job (cannot run program "sqlldr").

Regarding the filename in tOracleOutputBulkExec, just use the filename you want (not the name of an existing file).

This file will be used by sqlldr when called by the job at runtime.

Re: tOracleOutputBulk -tOracleOutputBulkExec

Anonymous — Thu, 01 Jun 2017 15:26:30 GMT

If i run the job from VM but talend send me a message: unable to open file .dat . I have insert a filename without extencion.

Re: tOracleOutputBulk -tOracleOutputBulkExec

TRF — Thu, 01 Jun 2017 16:03:05 GMT

As I remember, the default extension for sqlldr is ".dat", so name the file according to this rule.

Re: tOracleOutputBulk -tOracleOutputBulkExec

Anonymous — Wed, 07 Jun 2017 16:40:19 GMT

Hi,

I'm sorry if i answer you so late. Thanks again for your help!

Now I have another problem with the bulk load . In particolar I have a problem with the timestamp format. When I load the timestamp with the tOracleOutputBulkExec, the timestampo contain hour, minutes and second set on 00:00:00.

Re: tOracleOutputBulk -tOracleOutputBulkExec

TRF — Wed, 07 Jun 2017 16:56:48 GMT

I suggest you to open a new topic for this new challenge.
Also, indicate the expected format for this field.

Re: tOracleOutputBulk -tOracleOutputBulkExec

Anonymous — Mon, 12 Jun 2017 08:21:24 GMT

HI, I've already post my problem in a new topic