This report is an evaluation of two leading Extract, Transform and Load (ETL) tools, Informatica and Ab initio. In spite of long history of data ware housing, business intelligence and data integration industry, it is not an easy to decide which ETL tool is best suited for the organization needs as both Ab initio and Informatica offers a complete ETL solution and both are leaders in the Market.
The purpose of this usability study is to evaluate usability of each solution with respect to various criteria like cost, modularity to support seamless integration with other applications/tools, analytical reporting performance needs, volume and variety of data, loading performance, scalability, ease of use, self-sufficiency, simplicity, compatibility etc. If cost is not a concern Ab initio can be preferred for performance, processing of high volume of data and easy to develop perspective. Informatica provides a broad range of Data Integration products like Informatica PowerCenter, Informatica Data Integrator Hub, Informatica Cloud etc. and hence it boasts of a broader data integration capability. Specific offerings, future scope, ongoing enhancements, data integration capabilities, hardware and operating system requirements, architectural differences, maturity in various market segments etc. are detailed for both solutions.