topic Data on one Oracle DB, needs to call Sp on another server in Talend Studio

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

Anonymous — Sat, 29 Jul 2017 22:51:21 GMT

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!

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

TRF — Sun, 30 Jul 2017 18:18:31 GMT

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?

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

Anonymous — Sun, 30 Jul 2017 20:11:39 GMT

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)