Skip to content

Overview and Setup

Master Data Management (MDM) enables organizations to ensure the uniformity, accuracy, stewardship, semantic consistency, and accountability of the enterprise's official shared master data assets. MDM can be used across multiple systems, and applications to manage data effectively.

User Story

Leverage Master Data Management to synchronize, manage, and pass data among multiple systems using a messaging broker. This not only facilitates data consistency across diverse applications but also ensures efficient management of records referring to the same entity in different systems.

Requirements

Before setting up MDM, ensure that the following requirements are met:

  • PostgreSQL v9.2 or later: MDM requires a PostgreSQL database for storing and managing data. Ensure that PostgreSQL v9.2 or higher is installed and running.

Setting up MDM

Setting up MDM involves several steps, from configuring package properties to setting up databases and user groups. Below is a step-by-step guide:

Update Package Properties

  1. Navigate to the master_data_management\code\master_data_management\conf\properties\package.properties.
  2. Update the postgresql.username and postgresql.password fields with your PostgreSQL credentials.

Database Setup

The Setup service is a critical component in the initial configuration of the Master Data Management (MDM) system. Its main function is to ensure the database infrastructure necessary for MDM is correctly established. It starts by checking for an existing database connection within Martini; if none is found, it creates one using configurations specified in the package properties. Following this, the service sets up the required database schema by creating tables and applying necessary constraints to support the management and synchronization of master data. This process lays the foundational database structure essential for MDM's operation, ensuring data integrity and consistency across multiple systems. Follow the steps below to setup the database schema:

  1. Ensure a PostgreSQL database named master_data_management is already created.
  2. Execute the Setup service located in master-data-management/code/master_data_management/config/Setup.

Master Data Management User Interface (UI)

Master Data Management (MDM) is not only about managing data across systems through backend services but also provides a user-friendly interface (UI) to interact with. This UI allows users to have a hands-on approach to managing their data synchronization and integration tasks directly.

Capabilities of the MDM UI

In the MDM UI, users have a wide range of functionalities at their disposal:

  • View, Add, Update, Delete Operations: Users can perform basic CRUD (Create, Read, Update, Delete) operations on various elements within the MDM system. This includes managing systems, system endpoints, webhook configurations, entities, and entity mappings.

  • CDM Mappings: Users can manage Common Data Model (CDM) mappings within the UI. This feature allows for the standardization of data fields across different systems, facilitating smoother data integration.

  • View Mapped Systems: The UI provides visibility into which systems are currently mapped and integrated through MDM. This overview helps users understand the data flow and integration points across their IT landscape.

  • Sync New Systems: Users can initiate the synchronization of new systems directly from the UI. This feature simplifies the process of adding new systems into the MDM framework.

  • Resubmit Failed Payloads: In cases where data synchronization between systems fails, users can use the UI to identify and resubmit these failed payloads. This ensures data consistency and integrity by allowing users to address and correct data sync issues promptly.

Accessing the MDM UI

There are two primary ways to access the MDM UI:

  1. Running the index Gloop Template: Users can navigate to /master-data-management/code/master_data_management/webpage_templates within their Martini instance and run the index Gloop template. This method provides a direct way to launch the MDM UI from within the Martini Designer.

  2. Visiting the Martini Instance URL: By visiting <martini instance>/app/integration/mdm in a web browser, users can access the MDM UI. This web-based access allows users to manage their data synchronization tasks without needing to open the file directly on Martini Designer.

Note: MDM is a premium application available on the Lonti Marketplace. Users interested in leveraging the full capabilities of Master Data Management should consider acquiring this solution to enhance their data integration and synchronization strategies.