ETL integration

The MDE utility can integrate with any Extraction, Transformation, and Loading (ETL) that supports JDBC.

MDE can be associated with a full Extraction, Transformation, and Loading (ETL) chain, through integration with existing ETL tooling, for example, DataStage.

MDE can support integration with an ETL Server by providing a wrapper class for the MDE Engine class that extends the com.ascentialsoftware.jds.Stage class. This allows the MDE Engine to be used as a Java client stage, supporting one output link for writing data, within an ETL Job.

As the implemented Engine Stage gets its inputs as stage properties, it is known as a source stage, the primary job of which is to provide data to the output link.

The class provided by the MDE to act as a Java client stage is: com.ibm.tivoli.tnpm.dal.mde.client.datastage.EngineStage.

Note: Please see ETL Integration Example: DataStage Integration for a full example of ETL integration using DataStage.