Hi, Im building a database for my company. We are a rather small size book company with a lot of references and still growing. We have a Mysql database here and are trying to find some good tools to use it at its best. Basically we are just starting up the database after dealing with Excel: we had a size problem… So im trying to find a program that will allow us to do two different things: the migration of our data from the old system to the new one and a specialized software to perform ETL (Extract, transform and load) on our database. About the price of the tools, if we were one year ago, the accounting department would have been pretty relaxed about this. But today, we have some budget restrictions and therefore need a low cost tool. So could you give me some advice on a good data migration and etl tool for a low cost? Thanks for your help.
Have you searched for an open-source tool? I am relatively new to MySQL, so I am not familiar with the community tools. I did a quick search and found the following: Talend Open Studio is the leading open source data integration solution, used for ETL, data synchronization and data migration. http://www.talend.com/download_form.php Apatar is a recommended open source data integration and ETL software for MySQL. Apatar will help you migrate, integrate and synchronize MySQL with 3rd party databases, files and applications. http://www.apatar.com/web_demo.html Google http://www.google.com/search?q=MySQL+Open+Source+ETL&hl=en&safe=off&sa=2
Hi, Well yes, a few companies have had that sort of problem. Some companies have budget problems and are having to reduce their cost of operation. As social.networks says, have you ever heard of open source tools? They can do the job easily and less expensive than proprietary solutions that cost a lot of money. You can have a look at the ETL open source program social.networks talks about called Talend Open Studio: it is user-friendly but also has advanced features intended for technical users (java debugger, code injection…). It can perform data migration and ETL as you wrote it in your first post. The website is http://www.talend.com/solutions-data-integration/data-migration.php to download the open source program. They have a forum and documentation you can read. Tell us what you think about the software. For an ETL benchmark: http://blogs.sun.com/aja/entry/talend_s_new_data_processing