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.
- 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
Solved! Go to Solution.
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
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)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema