How to create a job with 2 different oracle DB connection in TALEND

One Star

How to create a job with 2 different oracle DB connection in TALEND

Dear,
I want to create a job which fetches a data from view(Different DB oracle connection) and uploads it to table(Different DB oracle connection).
Could you please tell me which job i should use to have different DB connections in a 1 go.
As i am new to TALEND tool , it would be grateful to get brief answer on above.
Already thanks in advance!
Moderator

Re: How to create a job with 2 different oracle DB connection in TALEND

Hi,
Here are tOracleDBXXX components 
tOracleInput component reads a database and extracts fields based on a query.
tOracleOutput component writes, updates, makes changes or suppresses entries in a database.
Your work flow should be:tOralceInput(source DB)-->further transformation-->tOracleOutput(target DB)
The source DB and target DB can be different.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.