You are not logged in.

#1 2010-03-31 17:14:28

cmaiorino
Member
3 posts

Help With Calling A PL/SQL Stored Procedure In Talend

Tags: [sp]

This may have been asked before, but I can't find a scenario exactly like mine on this forum.

Here is my problem (I'm new to Talend and this might actually be very easy to do):

I have an Oracle table on the designer in a tOracleInput component.  I connect it to a tMap component to do some basic data transformation that can be handled by using Talend expressions.  The output is then wired to another Oracle table in a tOracleOutput component.  Where I run into a problem is that there are a few output columns that need a very specialized piece of business logic to generate.  I already have a stored procedure in Oracle that handles it beautifully, accepting 7 input parameters (that would come from columns in the tOracleInput table) and outputting two output values that would be mapped to the table in the tOracleOutput component.

My problem is that I can't figure out how to do this, how to use the tMap for the basic work (which is about 90% of the data) but call the stored procedure to handle the two coulns that require special processing.  The job I am putting together now may have to call more than one stored procedure as there are othe output columsn that will also require special business logic.

Any help would be most appreciated...

Offline

#2 2010-04-01 03:04:20

shong
Talend Team


Re: Help With Calling A PL/SQL Stored Procedure In Talend

Hello
After you do some basic data transformation on the first tMap, you can link it to another tMap and generate several output for different business logic.
About how to call a strored procedure, see
http://www.talendforge.org/forum/viewtopic.php?id=4278
http://www.talendforge.org/forum/viewtopic.php?id=10215
Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy