From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

Multithreaded SP calls

Highlighted
Six Stars

Multithreaded SP calls

Is it possible to execute an SP against every row of a component's result output, particularly in parallel fashion?

Highlighted
Employee

Re: Multithreaded SP calls

Hi,

 

    The most easiest way is to use a tFlowtoIterate to send the records in an iterative fashion to the SP. 

 

     The second way is to call the SP from a Talend routine and you can call the routine as a function call from tMap or tjava. But in this case, you are simultaneously doing lot of DB connections (or same connection but shared simlutanous resources).

 

But from throughput perspective, the best way to process data in especially in parallel fashion is to send the incoming data to a temp table. Then join the data in this table to all other necessary tables with SP and do the processing you want to do. In this method, you need to make one DB call instead of multiple calls and your DBAs also will be happy.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Highlighted
Six Stars

Re: Multithreaded SP calls

From what I can see, stored procedure components don't have an input connector.  How do you input data from a table into them?

Highlighted
Employee

Re: Multithreaded SP calls

@devmichael 

 

Could you please verify whether the below link is helping you?

https://help.talend.com/reader/ezE005k1syi0pq3WAU8WyA/Or3iSV87d~xx6xzHYrUnLA

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now