| The Extract, Transform, Load (ETL) contain vendors | | | | populate data warehouses from various data sources |
| that provide tools used in planning and populating | | | | • Web-based, intuitive interface allows for |
| analytic databases sources such as data warehouses, | | | | increased productivity with minimal training |
| data marts, and operational data stores. These ETL | | | | • Object-based architecture promotes reusable |
| tools offer for the extraction, transformation, and | | | | components and functionality across disparate |
| integration of data from any number of various | | | | custom, packaged and legacy applications |
| database sources into time-variant databases used | | | | • Complete management, reporting and auditing |
| mostly for query and reporting. ETL tools give | | | | capabilities to track and monitor transactions |
| programmers a platform for designing | | | | • Fully standards-based solution, using XML and |
| source-to-target mappings, transformation and | | | | J2EE |
| process flows. | | | | Various Vendors in the ETL market provide built-in |
| Some key features of ETL Tools that they should | | | | intelligence attribute that fasten the mapping of |
| have: | | | | database sources, tuning of jobs, or handling of |
| • Data integration functionality, which is perfectly | | | | abnormality during runtime. Others offer enormous |
| suited for Extract Transform and Load (ETL) type of | | | | libraries of built-in transformations, enterprise |
| data warehousing solutions for business intelligence, | | | | information integration-style data integration, or |
| reporting and dashboards | | | | conjoined BI capabilities. The DBMS-bred challengers, |
| • Process flow based and service oriented | | | | however, are closing the functional gap at price |
| approach to data transformation and integration | | | | points that cannot be overlooked. |
| • Easy to use, intuitive graphical interface to | | | | Author is an expert on ETL software and solutions |
| define data mapping and data transformation rules | | | | and if you are looking to evaluate ETL Tools then he |
| • Includes both graphical design environment and | | | | will recommend best tips for selecting the right tool |
| fully featured run-time engine in one package | | | | to manage the business. |
| • Well suited for data aggregation required to | | | | |