Evaluation of Datastage as an ETL tool
Posted: Wed Mar 03, 2010 11:46 am
We need to evaluate Datastage ETL tool based on the information we receive against the following queries we have. Kindly provide us the information if available with anyone. Any help would be appreciated -
(1) Version/Change Control Support: Ability to save multiple versions. Ability to port code across environments. Does Datastage support a multi-developer environment?
(2) Vendor Viability: How committed is IBM to the product Datastage or the concept of BI? How well does the IBM support the Datastage?
(3) Security: Does Datastage support LDAP? How granular is the security?
(4) Performance: Does Datastage support parallelism? Does it have a bulk data load function?
(5) Database/Platform: Does Datastage run on Intel, RISC, and mainframe? Which source and target DBMS is supported?
(6) Ease of Use: Does Datastage have an intuitive GUI? How much training is required?
(7) Functionality: Built in functions. Custom-built and reusable? Is there support for external scripts or code?
(8 ) Supportability: Can Datastage be supported through the web? Does Datastage interface with an external batch scheduler? How sophisticated is the monitoring?
(9) Compatibility: How well does Datastage interface with the existing environment? Does Datastage provide connectors to existing data sources and applications?
(10) Error Handling/Debugging: How well does Datastage handle errors?
(11) Audit ability: How well does Datastage log activity? How available are the logs?
(12) Extraction Mechanism: Does Datastage support both push and pull options?
(13) Data Cleansing: Are there any built in cleansing functions?
(14) Metadata: How open is the metadata collected. Which DB is it stored?
(15) Cost: Approximate total cost of ownership.
(1) Version/Change Control Support: Ability to save multiple versions. Ability to port code across environments. Does Datastage support a multi-developer environment?
(2) Vendor Viability: How committed is IBM to the product Datastage or the concept of BI? How well does the IBM support the Datastage?
(3) Security: Does Datastage support LDAP? How granular is the security?
(4) Performance: Does Datastage support parallelism? Does it have a bulk data load function?
(5) Database/Platform: Does Datastage run on Intel, RISC, and mainframe? Which source and target DBMS is supported?
(6) Ease of Use: Does Datastage have an intuitive GUI? How much training is required?
(7) Functionality: Built in functions. Custom-built and reusable? Is there support for external scripts or code?
(8 ) Supportability: Can Datastage be supported through the web? Does Datastage interface with an external batch scheduler? How sophisticated is the monitoring?
(9) Compatibility: How well does Datastage interface with the existing environment? Does Datastage provide connectors to existing data sources and applications?
(10) Error Handling/Debugging: How well does Datastage handle errors?
(11) Audit ability: How well does Datastage log activity? How available are the logs?
(12) Extraction Mechanism: Does Datastage support both push and pull options?
(13) Data Cleansing: Are there any built in cleansing functions?
(14) Metadata: How open is the metadata collected. Which DB is it stored?
(15) Cost: Approximate total cost of ownership.