topic Re: 2 different databases same job in Talend Studio

2 different databases same job

Anonymous — Sat, 16 Nov 2024 08:29:34 GMT

Hy i'm newie with Data Integration ...i want to know if is posible to make one job and have different inputs/outputs like oracle & sql server. It is necesary to make one job for Oracle and another for Ms Sql Server ? I mean because there are specific OracleInput ans OracleOutput.... i want to make like "views" from data structure that will be the same on oracle and sql server, so y want to make one job and use in both databases , and store data depending the database that i choose.

Regards !!!

Re: 2 different databases same job

Anonymous — Wed, 28 Mar 2018 02:31:56 GMT

One job is enough.

multiple options:

- use tReplicate for multiple similar output and plug xxxOutput to each output

- use tmap to create multipel output

- use a tJBDCxxxx component and contextuliazed depending on which database you want to use.

Lots of tutorials should help you reach your goal.

Re: 2 different databases same job

Anonymous — Wed, 28 Mar 2018 17:14:00 GMT

thanks for your response...anyway is there a posibility to abstract de database engine from input data ? i mean...i get the same structure in oracle and in sqlserver i have to use oracleinput and msqlinput and replicate my flow one for each engine ? or there is a way to reduce my flow ? Regards !!!

Re: 2 different databases same job

TRF — Tue, 01 May 2018 22:06:33 GMT

You should have a look at Generic Database components DBInput / DBOutput.

Using the appropriate context variables you should be able to do what you expect.