We are making a decision about selecting which ETL tools we should use. Currently, we have a few choices: ETI, Informatica, Neon and UDI. Could you please give me some suggestions about how we can pick the right product and what we should consider? Are there are other companies that have the same environment we have that you can share how they selected their ETL tools? Our source system is OS/390 IBM (DB2 V4.1), Vsam, flat files and other systems, PC, Unix, etc. The target system will be OS/390 IBM DB2 V6.1. We are a commercial banking company. Can you please give some suggestions?


David Marco's Answer: The subject of comparing ETL products could take a lot of time to walk through. However, I'll give you a couple of advanced tips. First, anytime I talk with a software vendor, I always tell them that I will feel very uncomfortable if I don't walk away from the discussion with three problems with the tool. I say this because no tool does everything you want it to do. If you are not seeing the challenges with the tool then all you're getting is "marketing speak." Second, as with all software, ETL tools come with high learning curves. These learning curves have sunk more then one project. What will greatly reduce your risk of failure is to have a person that understands how to architect with the specific ETL tool. On the other hand, be prepared to pay a hefty fee for this person. Top-of-the-line people are in high demand, but they are worth the investment because of the amount of time and pain they can save. As a result, before the software is purchased, I interview the proposed architect and we make that person's time a condition of the sale.

Sid Adelman's Answer: The first thing you need to do is establish criteria for selection (e.g., platform), ease of use, learning curve, price, outside consultants required, performance and vendor characteristics. An easy way to get started would be to attend one of Pieter Mimno's seminars.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access