Wednesday 13 July 2011

Introduction to MDM

Master Data Management

       MDM is a concept which is said to be Master Data Management that plays an important role in each and every business. It ensures that the data is centralized, consistent, accurate, uniform across all the businesses. It can be implemented for Customers, Products, Accounts, Geographic Locations, Employees and etc.

 MDM helps the business to eliminate the redundant data upto a great extent and creates the reliability in the business and it can be integrated with any ETL tool and involved in cleansing, matching and merging processes.

It maintains rules to ensure consistency across the businesses by integrating all the applications such as Customers, Products, Sites, Employees.

Below is the complete process of MDM Life cycle.

1) Defining a model called Data model for the application
2) Creating and configuring the Stage process
3) Creating and configuring the load process
4) Create Match & Merge rules on the data
5) Creating and configuring data accessing views
6) Creating batches

There are many tools available in the market to create a successful MDM application. Informatica MDM Hub is the leading tool in the market.

Introduction to Informatica MDM Hub

MDM MDM HUB

         MDM Hub Server is the tool developed by Siperain and it's recently acquired by Informatica corporation. Informatica corporation has renamed it to Informatica MDM Hub Server and the current version is Informatica Hub Server 9.0.1

Informatica MDM Hub consists of three-tier model architecture.

1) Database Server
2) Application Server
3) User Interface layer

1) Database Server
                               Database server stores the metadata of the application. The database can be any relational management system such as Oracle,SQL Server, or DB2 etc.

2) Application Server
                                This tier takes care of security and access to the data. It is based on J2EE compliant application server, such as Websphere or Weblogic.

3) User Interface (UI) layer
                                 This layer allows users to use Informatica MDM to perform their data management tasks. Access to this can be limited based on the roles & responsibilities of the users.