Skip to content


General things about DataStage, an ETL tool

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

Posted in Business Intelligence.

Tagged with , , .


0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.