This is my first post and my first day of Talend Open Studio. I have two Oracle servers. On Server A, I need to query a database to get the id and department of an employee. Currently, it holds 10 rows. I need to utilize that information to call a stored on a different Oracle Database server (B). The SP is newEmployee(p_id IN VARCHAR2, p_dept IN VARCHAR2) which is used to execute a whole set of events. I am not sure how to do this. I have successfully queried DB A and retrieved all 10 rows via tOracleConnection -> OnSubjobOK -> tOracleInput. I am not sure what to do next. Any help would be appreciated while I get used to this data integration tool!
Solved! Go to Solution.
Welcome on the Talend Community Forum.
Use this design for your case:
tOracleConnection (1st server) -> OnComponentOk -> tOracleInput
tOracleConnection (2nd server) -> OnComponentOk -> tOracleSP (to call the SP)
Does this helps?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema