Connecting two component in one Job

Six Stars

Connecting two component in one Job

Hi Folks!!

I am newbie to the Talend and just started with a Data Integration tool.

I just exploring and got stuck at one point in context to connect two component which are doing different work but they are interdependent.

 

Scenario

- I have used component (say Com1) tMSSQL_1

                     - This calls a stored procedure and loading data into one SQL table <Table1>

- Second component (say Com2) used id loading data from above table <Table1> and inserting into other SQL table <Table2>)

- Now i have Com1 and Com2, and pre-requisite for Com2 is to execute Com1, but i am not able to provide this sequenece or not able to connect these two component sequentially in order Com1 ->Com2

 

Screenshot attached

 

Thanks

Amit Srivastava

fascinatingsql.blogspot.com

 

Fifteen Stars TRF
Fifteen Stars

Re: Connecting two component in one Job

Hi,

Based on your example, tMSSqlInput is a starting component (green icone) so you cannot connect it using an input flow (the component doesn't accept input flow data).

So, you need to connect it with the tMSSqlSP component using an event trigger such as OnSubjobOk.

Capture.PNG

This means, execute the tMSSqlSP.

When it is finished, execute tMSSqlInput and push the resulting data flow to tMSSqlOutput.

Hope this helps.


TRF

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog