ETL Tool

An ETL tool is used to design and populate a target data warehouse. It facilitates the extraction, transformation, and loading of application-specific data from the source database into the target data warehouse. It helps you construct a source model that describes the rules for querying the source database.

You can use an ETL tool of your choice or use to create and execute custom ETL jobs. If you choose to use InfoSphere® DataStage®, the required licence is provided along with IBM® Sterling Selling and Fulfillment Foundation.

The project files from Cognos® Adaptive Warehouse are included in <BI_COGNOS_HOME>\Exports\aw-export\sterling data source export. These files can be used by InfoSphere DataStage or any other ETL tool of your choice to migrate the ETL scripts from Cognos Adaptive Warehouse to the new ETL tool.