topic Re: How to connect two component in Talend Studio

How to connect two component

Anonymous — Thu, 22 Feb 2018 11:47:07 GMT

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

Re: How to connect two component

Anonymous — Thu, 22 Feb 2018 12:26:58 GMT

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

Re: How to connect two component

Anonymous — Fri, 23 Feb 2018 03:44:13 GMT

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

Re: How to connect two component

manodwhb — Fri, 23 Feb 2018 04:27:28 GMT

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.