ETL operations are used to extract data from an InfoSphere® MDM database and load it to downstream systems, and to extract data from either a single source or multiple sources and load it to IBM® InfoSphere Master Data Management. Certain MDM APIs and utilities are integrated with InfoSphere DataStage® to provide ETL operations for your customer data.
There are two options in which you can use MDM APIs in your InfoSphere DataStage jobs. Click a stage in the following graphic to learn more.
The MDM Connector stage is installed with InfoSphere DataStage. MDM samples can be downloaded from the IBM Samples and Assets site.
Attention: Before you begin your ETL operations, you must
first export you virtual MDM project metadata to InfoSphere Information Server. The MDM Workbench export
wizard is used to create the metadata file. Then, you can use the
MDM Connector bridge in InfoSphere Metadata
Asset Manager to import the metadata.
Tip: If you previously used Clover ETL graphs in your
MDM implementation, see the migration topic to better understand what InfoSphere DataStage features you can use.