Search code examples
mysqlsql-servertalend

Update MySQL table from an MSSQL Table with Talend

I want to update a MySQL table with values retrieved from an MSSQL table in Talend.

I used the MSSQL table as a tMSSqlUnput, a tMap and the MySQL table as a tMysqlOutput but I couldn't update establish a join query and update the table.

What should I do?

Solution

  • you can define key in schema of tMysqlOutput and also select action as Update. THis way talend would generate update statement by using key columns in the update where clause...and process them at mysql DB.

    It will be done for each row coming out of tMap.

    if you want to write your own sql then you should use tMysqlRow..