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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch