Tutorial Overview

This tutorial illustrates the features of Semarchy Convergence for DI in the context of a Master Data Management project.
The goal of this tutorial is to use Semarchy Convergence for DI to Publish source data into a Semarchy Convergence for MDM Hub, and Consume the resulting golden data to distribute it to other applications.

Installation and Configuration

To start the tutorial, you will install and configure the various Semarchy Convergence components involved.

You will run the following tasks:

Flows Designed in the Tutorial

The following schema gives an overview the integration flows involved in this tutorial.

Publish Data Into the Hub

In this tutorial you will use Convergence for DI to publish data from operational sources into the MDM Hub managed by Semarchy Convergence for MDM. Semarchy Convergence for MDM will certify golden records from this data.

Publishing source data for certification into golden data is performed as a transaction. Such a publisher transaction is called an External Load.

The external load lifecycle is described below:

  1. Initialize the External Load: Convergence for DI uses a PL/SQL Interface to initialize an external load and request from the Convergence for MDM platform a Load ID identifying this external load.
  2. Load Data: Convergence for DI inserts data into the landing tables of the MDM Hub, using the Load ID.
  3. Submit the External Load: Convergence for DI uses a PL/SQL Interface to submit the external load to the Convergence for MDM platform using the Load ID.

In the event of an error, Convergence for DI can Cancel the External Load instead of submitting it. For example, when problem occurs in the Load Data phase.

In this tutorial, you will load the following data into the landing tables of the hub:

To perform the publishing task, you will:

  1. Reverse-engineer some of the Metadata (data structures) involved in the data flows (tables, flat files and XML files). This task is described in the Reverse Engineering the Metadata chapter.
  2. Design the Mappings to load the data from these structure to the landing tables. This task is described in the Loading Data Into the Hub chapter.
  3. Design a Process to manage the external load. This task is described in the Assembling the Publishing Process chapter.
  4. Run the Process and review its results, as described in the Running the Publishing Process chapter.

Consume Data From the Hub

In order to deliver golden records to operational applications, you will design mappings to consume golden data from the MDM Hub tables and deliver it in an predefined XML format. The consumption process will extract golden data for the Customers and Contacts entities.

This task is described in the Consuming Data from the Hub chapter.