SQL server to MySQL dblinks

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi,
Any update on this?
Thanks
Rathi

[Anonymous]

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

[Anonymous]

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