Anca A.

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