IBM Master Data Management connector (DataStage)

Use the IBM Master Data Management connector in DataStage® to transform, refine, or analyze the data. Load record data from systems across your enterprise into IBM Master Data Management and run matching algorithms to consolidate that data from various sources to establish a 360-degree view of your customers.

Prerequisite

Create the connection. For instructions, see Connecting to a data source in DataStage and the IBM Master Data Management connection.

Writing data to the IBM Master Data Management connector as a target

If you want to configure IBM Master Data Management connector for DataStage as a target, you can:
  1. Double-click the IBM Master Data Management connector icon in the project canvas.
  2. In the Stage tab under the Properties section, find the General target properties.
  3. In the General target properties:
    1. Choose one of the Data category option (IBM Master Data Management data model types).
    2. In the Data type, provide the data model subtype (record or relationship type).
    3. If you choose records in the Data category, then you can provide the record subtype in the Data subtype.
    4. In the Write method, choose the load data option.
  4. In the Other properties:
    1. Specify the maximum Java Virtual Machine Heap size in megabytes.
    2. Optionally, select the Create data asset checkbox to enable creating data asset with provided name in the Data asset name.
  5. In the Stage tab, in the Advanced section, set the execution and combinability mode.

Reading data from the IBM Master Data Management connector as a source

If you want to configure IBM Master Data Management connector for DataStage as a source, you can:
  1. Double-click the IBM Master Data Management connector icon in the project canvas.
  2. In the Stage tab under the Properties section, find the General target properties.
  3. In the General target properties:
    1. Select the Generate unicode type columns checkbox. This property can be set only when runtime column propagation is used.
    2. Choose one of the Data category option (the IBM Master Data Management data model types).
    3. In the Data type, provide the data model subtype (record or relationship type).
    4. If you choose records in the Data category, then you can provide the record subtype in the Data subtype.
    5. In the Export Job Id, provide the job ID of a completed IBM Master Data Management export job that you want to extract data from.
    6. Optionally, define the Filter rule to specify the records in JSON format, that you want to export.
  4. In the Limits, provide the Row limit and the Byte limit (use any of following suffixes to change the unit: KB, MG, GB, or TB).
  5. In the Other properties, specify the maximum Java Virtual Machine Heap size in megabytes.
  6. In the Stage tab, in the Advanced section, set the execution and combinability mode. Moreover, select the option for preserving the data partitioning.