Customizing the MDEPerson_2 job

Use this procedure to customize the MDEPerson_2 job. This job must be customized for your environment before you run a master data extract.

1. In the Designer client, open the MDEPerson_2 job.
2. Double-click the entLink connector stage.
   1. On the DB2 Connector dialog, select Output > Properties.
   2. Enter the MDM database connection information in the Database, User name, and Password fields.
   3. Update the SQL in the Select statement field to fit your schema and MDM model. Specifically, update each occurrence of enttype to the entity type configured for your environment. You can copy the SQL from the entLink connector SQL template topic.
3. Repeat step 2 for the entXeia_memHead connector stage. For step c, you can copy SQL from the entXeia_memHead connector SQL template topic.
4. Double-click the MDM Connector stage.
   1. On the MDM Connector dialog, select Stage > Properties.
   2. Enter the MDM operational server connection information in the MDM Server name, MDM Server port, User name, and Password fields. Verify that the Mode field is set to Member read.
   3. Click Configure.
   4. On the MDM Member read configuration dialog, set your filtering options and click Next.
      Note: The master data extract sample uses the default party model. If your implementation uses a different model, make sure that you choose the Member Type, Entity Type, and attributes that reflect your model.
   5. Still on the MDM Member read configuration dialog, set your column mapping. Click Set output columns to set the link.
5. Update all links to use the updates that are made to the MDM Connector output.
6. Edit each Sequential File stage.
   1. Open the Sequential_File_12 stage. Select Input > Properties tab, and then select the Target folder. In the File field, type the full path and file name of the file that incoming data from entLink is written to.
   2. Open the Sequential_File_3 stage. Select Input > Properties tab, and then select the Target folder. In the File field, type the full path and file name of the file that incoming data is written to.
   3. Open the Sequential_File_8 stage. Select Input > Properties tab, and then select the Target folder. In the File field, type the full path and file name of the file where error data is written.
7. Save the job and then compile the job.