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.

[Anonymous]

Hi,

You simply want to load from mssql to mysql.

And All the columns also same?

[Anonymous]

can you say what are the issues you are facing?

[Anonymous]

I guess you have missed commit component in your job.please try with tmysqlcommit component with trigger(ONComponentOK)

[Anonymous]

by googling i just mapped with tmap and did .

Please let me know the correct process of mapping.

*My executed Query columns and mysql table columns are same.

[Anonymous]

Hi Rohit,

In MSSQLinput schema is in BuiltIn use Repository and choose your table metadata and you will get all the columns as you expected.

[cterenzi]

See those lines in your tMap configuration? Those indicate that values on the left are mapped to values on the right. There aren't many lines in your tMap because the expression values for the columns in your output are empty. FK_ItemID appears to be set up correctly. Try modeling the other expressions after that one.

[Anonymous]

While mapping : Query executed columns are not showing

i had kept Query type as repository

[Anonymous]

[Anonymous]

Here you are querying from one table : persons  for single table its mapping

but my query with multiple tables . in this case how to map