Using tools for the ETL process

5.7 Using tools for the ETL process

Several tools are available in the marketplace to help automate parts of the ETL process, including Oracle Warehouse Builder, Informatica, AbInitio, Ascential, and Sagent. These tools provide the mechanisms to connect to the heterogeneous data sources, generally to either relational databases or flat files, and perform the data extraction functions. They control the transfer of data across a network, provide data transformation services and data cleansing capabilities, and load the data into your data warehouse.