topic Re: SQL server to MySQL dblinks in Talend Studio

SQL server to MySQL dblinks

Anonymous — Tue, 10 May 2016 07:58:47 GMT

Hi,
I have a sql server source which needs to use dblinks to mysql tables.
Is it possible to use dblinks in talend?
Thanks

Re: SQL server to MySQL dblinks

Anonymous — Wed, 11 May 2016 09:24:26 GMT

Hi,
So far, talend don't support for dblinks. Feel free to create a new new feature jira issue on Talend Bug Tracker.
As a workaround, Can you use tmssqlinput-->tmysqloutput to achieve your goal?
Best regards
Sabrina

Re: SQL server to MySQL dblinks

Anonymous — Wed, 11 May 2016 09:47:18 GMT

Hi Sabrina,
I created a 'linked server' in sql server to mysql. Then using the OPENQUERY keyword , I connected the tables from sql server and mysql. I embedded this query in talend and was able to retrieve columns from both sql server and mysql.
I did not understand when you said its not supported
Request you to help me understand the same
Regards
Rathi

Re: SQL server to MySQL dblinks

Anonymous — Wed, 11 May 2016 10:57:51 GMT

Hi Sabrina,
Another note, when I run the job, there are no errors. But the data from the mysql remote connection, from sql server linked server(linked server = dblink) does not get transported.

The query is
SELECT * FROM OPENQUERY([Linky_To_MySQL], 'SELECT * FROM talendhouse.farmer')

This does return resultset when I run on the sql editor on talend but not when I run the job

Any thoughts
Regards
Rathi

Re: SQL server to MySQL dblinks

Anonymous — Thu, 12 May 2016 08:54:30 GMT

Hi,
Any update on this?
Thanks
Rathi

Re: SQL server to MySQL dblinks

Anonymous — Fri, 13 May 2016 10:28:54 GMT

Hi,

[size=1][font=Verdana, Helvetica, Arial, sans-serif]SELECT * FROM OPENQUERY([Linky_To_MySQL], 'SELECT * FROM talendhouse.farmer')[/font][/size]

We don't use such query before not sure it is supported officially in talend. How did you embed this query in talend?
Best regards
Sabrina

Re: SQL server to MySQL dblinks

Anonymous — Fri, 13 May 2016 10:32:14 GMT

Hi Sabrina,
I did embed the query in the query editor of mssqlinput. When I run the job, it does not give me any error, bu in the end no data is transported to the target table
However, I embedded the query in a function in sql server and called the function in talend. This works and the data is transported to the target table
So, should we about this way when we have queries with dblinks or linked servers?
Thanks
Rathi