13 Aug, 2008
General things about DataStage, an ETL tool
Posted by: Anca Alimanescu In: Business Intelligence
DataStage is an ETL(Extract, Transfer, Load) tool.
Like all the ETL tools it satisfies the following needs:
- extract data from the datawarehouse or from files that arrive from different other applications
- transform and modify the data and after
- insert or load data into the datawarehouse.
DataStage is composed of more modules that will allow you to implement these three main functionalities:
The client module:
- Designer – creates the jobs
- Director – launches and stops the jobs, enables you to consult the logs of the jobs
- Administrator – manages the projects , the users and the security
- Manager – manages the objects of a project: Import – Export
The server module:
- The DataStage Server – can be installed on Windows/Unix/Linux
- The Repository – stores all the Datastage objects as well as the logs
Different other products:
- Datastage Server
- Datastage Parallel Extender
- Datastage MVS
