topic Re: Microsoft SQL to Mysql data insertion based on query results in Talend Studio

Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 12:59:45 GMT

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.

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:12:47 GMT

Hi,

You simply want to load from mssql to mysql.

And All the columns also same?

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:13:24 GMT

can you say what are the issues you are facing?

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:15:24 GMT

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

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:35:21 GMT

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.

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:39:50 GMT

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.

Re: Microsoft SQL to Mysql data insertion based on query results

cterenzi — Thu, 25 May 2017 13:41:57 GMT

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.

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:47:39 GMT

While mapping : Query executed columns are not showing

i had kept Query type as repository

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:49:55 GMT

Re: Microsoft SQL to Mysql data insertion based on query results

Anonymous — Thu, 25 May 2017 13:54:17 GMT

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

Re: Microsoft SQL to Mysql data insertion based on query results

vapukov — Fri, 26 May 2017 08:45:15 GMT

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