If you previously used CloverETL and now plan to leverage the integration between InfoSphere® MDM and IBM® InfoSphere DataStage® for your ETL activities, review this information.
This table maps the ETL tasks that are often used to implement MDM with equivalent features that are available with MDM and InfoSphere DataStage integration.
| Task | CloverETL graph | MDM and InfoSphere DataStage feature |
|---|---|---|
| MDM metadata export | Dictionary extract | Metadata export is done before you begin your ETL operations. The metadata that is exported from your MDM Workbench project to InfoSphere Information Server through InforSphere Metadata Asset Manager is used to create the foundation for further ETL work on your customer data. |
| Cleanse customer extract data file | Deduplicate Clean and deduplicate |
InfoSphere DataStage provides capabilities
for data deduplication and data transformation. You can use the Remove
Duplicates and Transformer stages. Part of the MDM and InfoSphere Information Server bundling includes access to the data cleansing features offered in InfoSphere QualityStage®. You can use the QualityStage for some data quality activities, such as address standardization. |
| Derive data and create output UNL files (MpxData) | Member Model Transform | The MpxData utility can be used in InfoSphere DataStage by configuring the MDM Java™ Integration stage to use the MpxData. You must download the InfoSphere Master Data Management IWM Samples Version 11.4 from the Samples and Assets site for InfoSphere MDM. |
| Member Get | MMCA EMCA |
The MDM Connector stage can be configured to create output for either member most current or entity most current composite views. The MDM Connector stage uses the Member read interaction (MemGet). |
| Master data extract | Incremental Load Extract Full All |
A sample set of InfoSphere DataStage jobs are provided on the Samples and Assets site for InfoSphere MDM. You can use this sample to customize an extract of master data. The sample uses a number of stages, including MDM Connector stage in Member read mode, to complete a master data extract. |
For more information about CloverETL or to purchase CloverETL in order to support data transformations made for use with MDM, visit the CloverETL website: http://www.cloveretl.com/ibm-mdm
