Microsoft SQL to Mysql data insertion based on query results

[Anonymous]

HI,

newbie  in talend.

Working on : Talend Open Studio for Data Integration ,Version: 6.4.0

My Requirement:

1. I have MSSQL query with gets the result from 4 tables

2. I have a Mysql table with has same columns the resulted query column values should be inserted in Mysql table

* I had connected to the DB of Mssql and Mysql

* Please find the attached screenshot.

* Please guide me as how to insert the Query resulted values frm MSSQL to Mysql table.

[vapukov · Accepted solution]

for Source (Input) components, it is not important - how many tables in Your query - from Talend side, any complicated SQL query look like single table

all what You need (must) - define columns schema for input component - exactly same as query return, that all. After this You can map it to Output column - make transformations and etc