Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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