iWay Enterprise stage

IBM® InfoSphere® DataStage® is a tool set for designing, developing, and running jobs that populate tables in a data warehouse or data mart. You can use the iWay Enterprise stage in your parallel jobs.

The iWay Enterprise stage is a connectivity stage. Using iWay Enterprise stage, you can read data from an iWay server. You can use iWay middleware to access a variety of data sources. iWay middleware insulates you from the complexity of accessing certain data sources, and is often used to access data from legacy databases on Mainframe systems.

The iWay Enterprise stage connects to the iWay server by using the iWay 5.3 API. The stage connects to, and supports, all platforms and data sources supported by the iWay 5.3 API. The stage only reads data from data sources via iWay, and does not provide facilities for writing data to or updating data sources. The stage sets up a connection to the specified iWay server, reads data from a table and writes it to a data set. You can also use the stage for performing a lookup in a table hosted on an iWay server. The stage operates sequentially when reading or in parallel when performing a lookup.

You can access several different data sources by using the iWay middleware. Therefore, fine-tuning for reading a particular data source access is done on the iWay client, rather than the iWay Enterprise stage.