Preparing to use the master data extract sample

Use this procedure to prepare your environment to use the master data extract sample jobs.


  1. Extract the sample files from IBMInfoSphereMasterDataManagement_Samples_<version>.zip in the MDM installation home directory.
  2. Go to the directory where you extracted the samples. The master data extract sample files are in the mdmsamples/mdm_integration/mdm_datastage/jars directory.
  3. Run the following SQL command to update your MDM database.
    create table temp_recmtime_watermark(enttype varchar(10),min_recmtime timestamp,max_recmtime timestamp)
    insert into temp_recmtime_watermark(enttype,min_recmtime,max_recmtime) values ('enttype','2000-01-01 00:00:00.000000','2000-01-01 00:00:00.000000')
    insert into mpi_seqgen values(1,1,'A','maxaudrecno_memtype',0,1,'','');
    insert into mpi_seqgen values(1,1,'A','minaudrecno_memtype',0,1,'','');
    Note: The master data extract sample uses the default party model. If your implementation uses a different model, make sure that you update enttype and memtype in the SQL to reflect the settings in your model.
  4. Open InfoSphere® DataStage® Designer Client and import the MDE_Person.dsx file from the opt/mdm_integration/mdm_datastage/MDE directory.


You now have three parallel jobs and one sequential job in InfoSphere DataStage Designer Client.
  • MDE_Person_1 (parallel)
  • MDE_Person_2 (parallel)
  • MDE_Person_3 (parallel)
  • MDE_Person_All (sequential)

Continue with customizing each job for your environment.

Last updated: 10 Jan 2018