Configuring the party_bulk_load job

The bulk load job issues a query to MDM, iterates over the resulting list of customer IDs, and constructs JSON documents for each entity. The documents are then stored in Cloudant®. Use this procedure to configure the party_bulk_load job for your environment. This task requires access to IBM® InfoSphere® DataStage® and QualityStage® Designer client.

Before you begin

This task assumes that you have a Cloudant account and database configured. You must also complete Configuring Cloudant database server permissions if you want to keep your Cloudant account credentials private.

Procedure

  1. Open the Designer client and import the party_bulk_load.dsx file from the opt/mdm_integration/com.ibm.mdm.integration.cloudant/datastagejobs directory.
  2. Open the party_bulk_load job.
  3. Select File > Run.
  4. On the party_bulk_load - Job Run Options dialog, provide values for the following job parameters.
    Property Description
    Cloudant userid Enter your Cloudant account ID.
    Cloudant password Enter your Cloudant password.
    MDM userid Enter the ID used to connect to the MDM operational server.
    MDM password Enter the password to connect to the MDM operational server.
    Cloudant DB userid Enter the name of the Cloudant account. This parameter is different from the Cloudant user ID if you are using Cloudant API keys.
    Cloudant database Enter the name of the Cloudant database on which the JSON documents are stored.
    DB2® MDM database Enter the name of the MDM database from which to retrieve entity data.
    DB2 User name Enter the ID to access the MDM database.
    DB2 Password Enter the password to access the MDM database.
    MDM Host/Port Enter the name and port for the MDM operational server in hostname:port format.
  5. Click Run.

Results

The JSON documents are stored in the Cloudant cache.

Last updated: November 6, 2015