From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

How to connect two component

Highlighted
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
Highlighted
Moderator

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
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post


All Replies
Highlighted
Community Manager

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

Highlighted
Six Stars

Re: How to connect two component

 
Highlighted
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

 

Highlighted
Moderator

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
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post

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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog