has anyone had an experience in migrating data from informix database to mysql? i am looking at talend to do this but i have no good prior experience with talend. i will really appreciate all the assistance.
Yes, Talend Open Studio would be a good tool to do this with. Here's the simple explanation of what you would need to do:
* In MySQL, create your destination database.
* In TOS, put your Informix database credentials into a new DB Connection under the Metadata.
* Also, put your MySQL database creds into another Metadata DB Connection.
* Add a tInformixInput component to your job, and configure the query as appropriate.
* Add a tMysqlOutput component to your job and configure as appropriate.
* Add a tMap component that will translate the rows coming from Informix to whatever format is needed for MySQL.
* Connect the tInformixInput to the tMap and the tMap output to the tMysqlOutput.
