I am writing a Web application for Unidata Database.
The situation is here.
I am writing a web application in PHP and MySql. The main database is located on IBM Unidata (Now RocketSoftware Unidata) Server and the database to which my app will interact is located on MySql server, but i want to synchronize data on unidata server with mysql tables.
Unidata and MySql servers are on different locations but platforms can be same i.e., Windows Server.
What should be the best possible solution to this situation, which can be implemented easily.