How to create a communication setup between a Mysql and a MS SQL Server instance?

I have two separate appliations running on the separate infrastructure. app-a is using MYSQL as it's database server and, app-b is using MS SQL Server as database server. I have got requirement to constantly read some tables in the MS SQ开发者_如何学GoL server and populate some table in MYSQL server.

I got clue about setup a communication environment for my MYSQL database server and a external MS SQL server(Using DBlink).

Please provide your expert opinions for this setup? Is this possible to setup such a environment? If Yes; How does it work? And what is the process to set it up?

Thanks,

Vijay

This link, describe the process for doing something like this. But this solution only works form MS SQL server perspective. As per my findings there is no support for such a functionality in the MySql part.