DataStage is on of the leading ETL products on the BI market. The tool allows integration of the data across multiple systems and processing high volumes of the data.
Datastage has an user-friendly graphical frontend to designing jobs which manage collecting, transforming, validating and loading data from multiple sources, such as the enterprise applications like Oracle, SAP, PeopleSoft and mainframes, to the data warehouse systems.
The application is capable of integrating meta data across the data environment to maintain consistent analytic interpretations. Datastage provides data quality and reliability for accurate business analysis and reporting.
Datastage was formerly known as Ardent DataStage followed by Ascential DataStage and in 2005 was acquired by IBM and added to the WebSphere family. Starting from 2006 its official name is IBM WebSphere Datastage and in 2008 it has been renamed to IBM InfoSphere Datastage.
Datastage is available and fully supported under windows and unix environments.
The core DataStage client applications are common in all versions of Datastage; those are:
- Administrator - Administers DataStage projects, manages global settings and interacts with the system
- Designer - used to create DataStage jobs and job sequences which are compiled into executable programs. It is a main module for developers.
- Director - manages running and monitoring DataStage jobs. It is mainly used by operators and testers.
- Manager - for managing, browsing and editing the data warehouse metadata repository.