Data on one Oracle DB, needs to call Sp on another server

[Anonymous]

Hello,

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!

[TRF]

Hi,

Welcome on the Talend Community Forum.

Use this design for your case:

tOracleConnection (1st server) -> OnComponentOk -> tOracleInput

   |

OnSubjobOK

   |

tOracleConnection (2nd server) -> OnComponentOk -> tOracleSP (to call the SP)

Does this helps?

[Anonymous · Accepted solution]

I could not get this to work but it did lead me to the solution.

tOracleConnection (1st server) ->  

   |

OnComponentOk

   |

tOracleInput -> tOracleSP (using repository for server2)