Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

 

Labels (2)
3 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

0683p000009LsdW.jpg

Hi @rhall

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

 

manodwhb
Champion II
Champion II

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.