Evaluating tools is a personal thing. I can tell you the each engagement that I have uses a different weighting
schedule. Some will think that having extensive connectivity is more important than functionality, while others will be just the opposite.
Here are the criteria we use in our ETL evaluations, as well I have added a column that provides a rating between 1 and 5 for the weighting the I recently used.
|Price||Price of the product and required add-ons||5|
|Productivity Aids (primary)||Supports custom code interface, code/transformation reusability and imports data models from ERWin||3|
|Functionality (primary)||Caching, exceptions/rejects, change data capture, aggregates loaded in parallel with atomic data, incremental aggregation, persistent variables, supports parallelism||5|
|Source / Target Connectivity (secondary)||Supports native interfaces to Oracle8i/9i, SQL Server 6.5/2000, Flat Files, FoxPro, UDB, etc.||1|
|Metadata (primary)||Conforms to the Common Warehouse Metamodel, bi-directional metadata sharing with 3rd party tools, captures technical and business metadata, import/export XML||3|
|Ease of use /Manageability (secondary)||How intuitive is the tool? Is the User Interface well designed? Free access to technical support website, knowledge base, user forums, etc.||4|
|Scheduler Capabilities (secondary)||Supports time and event driven execution, able to group and schedule plans/jobs/ sessions into batches through a GUI, able to view job dependencies, etc.||3|
|Change Management (secondary)||Development locking (i.e. check-in/check-out) capabilities, maintains multiple versions, impact analysis across tools in the warehouse environment, etc.||2|
|Debugging, Error Handling, Reporting and Monitoring (primary)||Debug/test mode utilities allowing developer to step through the mapping and view the column values, on-line error manuals with root cause and resolution steps, provides error, status and metadata reporting, etc.||3|
|Security (primary)||Provides proprietary logon id and password validation, interfaces with 3rd party security packages, assign users to multiple roles/groups at different levels/privileges||2|
|Operational Impacts (secondary)||Scalability of the tools architecture, ease of the upgrade process, and performance management capabilities||1|
|Backup and Recovery (secondary)||GUI based backup and restore through the tool, automated and point in time backups and restores, able to restart after a hard fail from the last row processed||1|
|Technical Environment (secondary)||Supports Windows NT, 2000, and XP? Versions of UNIX supported?||1|
Dig deeper on Oracle business intelligence and analytics
Related Q&A from Ian Abramson, Director, Enterprise Data Group, Thoughtcorp
ETL tools provide very robust support for complex business logic.continue reading
I am evaluating ETL tools for the organization. Considering that I am looking at three or four tools, how do I rate these and put a weight-age for ...continue reading
What are the pros/cons of custom development vs. an ETL tool? The question of custom code versus the use an ETL tool is one that we are faced with ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.