MDM Workflow

The following steps describe the general workflow for implementing the Sun MDM Suite solution once you create the master index application and generate the data quality tools. These steps correspond to the diagram below.

• Extract data from existing systems (Data Integrator).

• Configure standardization, cleansing, and analysis rules, and then cleanse and profile the extracted data (Data Quality).

• Match and load standardized data (Master Index and Data Integrator).

• Deploy the MDM application to perform ongoing cleansing and deduplication (Master Index Server).

• Monitor and maintain data using the data stewardship application (Master Index Web Application).

Figure 1 MDM Workflow Diagram

Below is a more detailed outline of the development steps required to create an MDM solution using the MDM Suite.

1. Perform a preliminary analysis of the data you plan to store in the master index application to determine the fields to include in the object structure and their attributes.

2. Create and configure the Sun Master Index application, defining the object structure, standardization and match logic, queries, runtime characteristics, and any custom processing logic.

3. Create the database that will store the reference data.

4. Define security for the MIDM and any web services you will expose.

5. Generate the profiling, cleansing, and bulk match and load tools.

6. Extract the data from external systems that will be profiled, cleansed, and loaded into the master index database.

7. Analyze and cleanse the extracted data. Adjust the application configuration based on the results.

8. Perform a match analysis using the IBML tool. Adjust the matching logic based on the results.

9. Load the matched records to the master index database.

10. Build and deploy the MDM project.

11. Define connectivity to external systems using a combination of adapters, business processes, web services, Java, and JMS Topics.

12. Create any necessary presentation layer views.