topic Re: tOracleInput in Talend Studio

tOracleInput

Mehdi_Mhedhbi2 — Sat, 16 Nov 2024 04:23:17 GMT

Hello, I'm having three identical databases in termes of structure (tables and columns), one for each country.
Example: the table customer exists in the three databases with same fields. Only the content is different because every country has its own client.

i want to load the three tables in on the single table in the destination, normally I would use three tOracleInput
Then add a value to indicate the country name in a tamp for each of the three and then concatenate all in a tUnite.

But since the three databases have the same exactly architecture,I want to do it in one single tOracle input and
execute the same sql statement "select code, nom from the customer" but on the three different databases.
i though about using context variable and tLoop but i am having problems to correctly design a functional job.

Re: tOracleInput

Anonymous — Thu, 17 Oct 2019 10:59:30 GMT

Hi
Use context variables for db connection parameters, and use a tfixedFlowInput to generate the variable value.
tFixedFlowInput--main(row1)--tFlowToIterate--tjava--oncomponentok-->tOracleInput--tUnite-->

on tFixedFlowInput, select 'Use inline content' model, and input the variable value like
host1;database_name1;port1;username1;password1
host2;database_name2;port2;username2;password2
host3;database_name3;port3;username3;password3

on tjava:
context.host=(String)globalMap.get("row1.host")
....the same for other parameters...

Regards
Shong

Re: tOracleInput

Mehdi_Mhedhbi2 — Mon, 21 Oct 2019 15:06:44 GMT

thx you )