How to connect two component

Six Stars

How to connect two component

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

 


Accepted Solutions
Thirteen Stars

Re: How to connect two component

if you want to execute the GenPassword table after complition of tMSSqlSP_1 ,then Rigth click on tMSSqlSP_1>>Trigger>On Subjob Ok connect to  GenPassword table.

Manohar B

All Replies
Sixteen Stars

Re: How to connect two component

I don't see your screenshot, but I think these pages will help you out. For the MS Stored Proc look here: https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/Y4ldtMoTiuC0d9L2HNRqzw

 

Connecting and working with MSSQL components: https://help.talend.com/reader/OwHoMAdhOJjvlcz1pzdCZg/8_1bcM8RufywgEwiAKsxAg

Six Stars

Re: How to connect two component

 
Six Stars

Re: How to connect two component

TwoComponentConnection.JPG

Hi rhall_2_0

Actually i want to connect aformentioned component together, as source of the GenPassword table is stored procedure result set executed inside tMSSqlSP_1 component.

 

How to connect tMSSqlSP_1 and component containing (GenPassword and tMSSqlOutput_1)

 

Thanks

Amit Srivastava

https://fascinatingsql.blogspot.in

 

Thirteen Stars

Re: How to connect two component

if you want to execute the GenPassword table after complition of tMSSqlSP_1 ,then Rigth click on tMSSqlSP_1>>Trigger>On Subjob Ok connect to  GenPassword table.

Manohar B