1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Low-Cost data migration and ETL tools for MySQL

Discussion in 'External Resources / Market Place' started by Pcasty, Jul 15, 2009.

  1. Pcasty

    Pcasty Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    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.
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    Re: Low-Cost data migration and ETL tools

    Hmmm, your old database was in Excel? You should look at Toad for MySQL. It's absolutely free.
     
  3. Gstrand

    Gstrand Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    Some companies have budget problems and are having to reduce their cost of operation.

    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 a good ETL open source program 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 in your first post.

    You can go to the website to download the open source program. They have a forum and documentation you can read. Tell us what you think about the software.
     
  4. Pcasty

    Pcasty Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Proprietary versus Open source ETL tools

    Hi,

    As of today, we are still enjoying our Informatica tool but in a few months we will need to change. Basically we do not use our software at its full capacity and don't feel we need it anymore.
    So we are trying to find a less expensive solution that would have the same features (or almost...).

    We are looking at less expensive tools and Open source software. We have pretty much targeted a few companies and would like to know which ones would be the better solution compared to Informatica.

    -Apatar
    -Expressor
    -Pentaho
    -Talend

    Some are paying software, some are open source (but not free...), so i'm asking you to know which is the best software on the market.

    Thanks.
     
  5. Gstrand

    Gstrand Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Re: Proprietary versus Open source ETL tools

    Having used a few open source and proprietary solutions, my advice would be to go for open source.
    About the best company on the market, of course all of those you talk about are good. IMHO, I have a few favorites in the open source world.

    I enjoy Talend Open Studio because the program has a well designed interface with technically advanced features, a good debugging team and a large community.

    Hope this helps!
     
  6. Pcasty

    Pcasty Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Operation of the software and ETL tools

    Hi all,

    We are in the process of getting an ETL program. We need it to perform some basic extract, transform and load jobs.
    But we want to get an open source tool with good training.
    Our team is mainly business oriented, with some computer knowledge. We would like to have someone come to our company and explain to all the team how to operate the tool.

    I can operate the tool on my own, but I am not experienced enough to show other people how to operate the software.
    So would someone know which open source companies offer ETL tools with good training and how much time would it take?

    Thanks.