topic Re: Moving an extra field in Talend Studio

Moving an extra field

JMichaud — Sat, 16 Nov 2024 00:55:49 GMT

I'm moving data from a Sql Server database To MySql database and I want to log at the end of the process the unique key from the SQL Server with the unique key of the MYSQL Database.

I don't have a field in the MySql databse to store the unique key of the SQL Server database and I want to avoid creating one.

Here is the pipeline that i have right now

In the tOutputDB1 I have this schema

I want to output the Season_ID to the next step so I can log it in my csv file

But if I leave the database column empty I get an error.

What is the best way to achieve that ?

The end goal is to have a csv file that will have Season_ID from the SQL Server and the lastInsertedId from the MYSql Database.

Thanks

Re: Moving an extra field

manodwhb — Sun, 20 Dec 2020 13:22:21 GMT

@Jean-Philippe Michaud , check the below link you need to use tDbconnection with that only it will work.

https://help.talend.com/r/ircIB~9lV5b5iHIXv5FNPg/YKDfwAorwulJkpR_5xgB4Q

Thanks,

Manohar

Re: Moving an extra field

JMichaud — Sun, 20 Dec 2020 14:03:54 GMT

Thanks for the answer

The tDbConnection is already there and I don't have an issue getting the last insert id from the MySql Database.

My issue is more to make the id from the source table flow from the first database to the last step .

From the tMap I can extract the Season_ID wich is the id of my initial table.

But when I get to the insert, since this Season_ID is not in the destinaton table, I can't map it to go to he next step and insert in my csv file

If I leave the db_column empty it fails