Six Stars

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

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!

  • Data Integration
Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

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

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)

 

 

2 REPLIES
Nine Stars TRF
Nine Stars

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

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?


TRF
Six Stars

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

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)