https://community.qlik.com/t5/Talend-Studio/migrate-data-from-informix-to-mysql/m-p/2362953#M126978 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: <BR />* In MySQL, create your destination database. <BR />* In TOS, put your Informix database credentials into a new DB Connection under the Metadata. <BR />* Also, put your MySQL database creds into another Metadata DB Connection. <BR />* Add a tInformixInput component to your job, and configure the query as appropriate. <BR />* Add a tMysqlOutput component to your job and configure as appropriate. <BR />* Add a tMap component that will translate the rows coming from Informix to whatever format is needed for MySQL. <BR />* Connect the tInformixInput to the tMap and the tMap output to the tMysqlOutput. Wed, 10 Feb 2010 16:04:10 GMT Anonymous 2010-02-10T16:04:10Z https://community.qlik.com/t5/Talend-Studio/migrate-data-from-informix-to-mysql/m-p/2362952#M126977 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. Sat, 16 Nov 2024 13:33:46 GMT https://community.qlik.com/t5/Talend-Studio/migrate-data-from-informix-to-mysql/m-p/2362952#M126977 Anonymous 2024-11-16T13:33:46Z https://community.qlik.com/t5/Talend-Studio/migrate-data-from-informix-to-mysql/m-p/2362953#M126978 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: <BR />* In MySQL, create your destination database. <BR />* In TOS, put your Informix database credentials into a new DB Connection under the Metadata. <BR />* Also, put your MySQL database creds into another Metadata DB Connection. <BR />* Add a tInformixInput component to your job, and configure the query as appropriate. <BR />* Add a tMysqlOutput component to your job and configure as appropriate. <BR />* Add a tMap component that will translate the rows coming from Informix to whatever format is needed for MySQL. <BR />* Connect the tInformixInput to the tMap and the tMap output to the tMysqlOutput. Wed, 10 Feb 2010 16:04:10 GMT https://community.qlik.com/t5/Talend-Studio/migrate-data-from-informix-to-mysql/m-p/2362953#M126978 Anonymous 2010-02-10T16:04:10Z https://community.qlik.com/t5/Talend-Studio/migrate-data-from-informix-to-mysql/m-p/2362954#M126979 Hi ewall,<BR />thanks, let me give it a try and let you know how it goes. Fri, 12 Feb 2010 15:35:55 GMT https://community.qlik.com/t5/Talend-Studio/migrate-data-from-informix-to-mysql/m-p/2362954#M126979 Anonymous 2010-02-12T15:35:55Z