Master data management

About My Council Services Master Data Management

Master Data Management (MDM) is made up of 5 components:

  • Address (NLPG/LLPG) MDM
  • People MDM
  • Product MDM
  • Organisation MDM
  • Asset MDM

It allows customer, organisation, property and asset data to be managed and curated once and then federated with other systems, enabling a single customer and asset view across My Council Services and all other connected systems.

Effective MDM allows local authorities to view customers and assets with full context of all the relevant information, services usage and interactions. It is central to providing strong data governance and protection.

How to use the Master Data Management module

My Council Services offers four ways of using our MDM solution.

  1. Registration – Retain master customer and reference data in operational systems; implement a central index/cross reference MDM system and use federated queries to access master data.
  2. Consolidation – Consolidate/copy master data from enterprise applications into the MDM and distribute this to downstream, consuming enterprise applications or platforms.
  3. Co-existence – Consume master data created in master-data-relevant enterprise applications. De-duplicate, enrich and conflict-resolve centrally within the MDM. Implement two-way integration. Interface/publish changes to subscribing application consumers.
  4. Transactional/centralised – Create/author all master data centrally from the MDM and publish it out to consuming operational systems.

My Council Services Master Data Management is designed to perform as a source of clean, complete, distinct and accurate customer data for the entire organisation.

The primary functions of My Council Services MDM are:

  • Consolidate and govern a unique, complete and accurate set of master customer information from across the enterprise
  • Track and maintain changes over time, enhance and deepen the context
  • Distribute this information as a single point of truth to all operational and analytical applications ‘just in time’

To accomplish this, My Council Services MDM is organised around five key areas with distinct capabilities under each area.

  • Trusted customer data is held in a central MDM schema
  • Consolidation services manage the movement of master data into the central store
  • Cleansing services de-duplicate, standardise and augment the master data
  • Governance services control access, retrieval, privacy, audit and change management rules
  • Sharing services include integration, web services, event propagation, and global standards based synchronisation

The My Council Services MDM platform comes with a number of characteristics that truly make it enterprise strength as MDM platform:

Configuration and customisation options

The My Council Services platform has been designed for rapid configuration and customisation, with broad extensibility in mind.

The application suite is defined using configuration, and the resulting metadata is stored in a central repository. This metadata includes the business model, allowing entities to be extended, and new objects and entities to be created and linked to those objects already in existence. A major advantage of this approach is that application upgrades are simpler to undertake and to deploy.

Modularity and flexibility

MDM implementations range from lightweight registries to robust, persistent masters able to manage and store not only the core customer profile but also to provide a centralised single view of child entities associated with the customer.

My Council Services MDM is designed in a modular fashion allowing the organisation the flexibility to deploy anywhere from a lightweight registry to a robust persistent hub with associated child entities.

Service-oriented architecture

The architecture and platform have been designed to be object based, service-oriented and metadata driven. Building on this architectural platform, My Council Services MDM provides a rich set of prebuilt MDM services, together with a set of adapters to support the most common integration technologies.

Deployment choices

Organisations have varying requirements when it comes to choosing how to deploy an MDM solution. Many organisations will deploy a stand-alone MDM Hub that is integrated to all other applications. My Council Services MDM supports this “stand alone” deployment mode.

Generic master data management and mapping utility

This tool allows business users to define grid web based eForms to allow data mappings. The utility can be configured and used without the need for specialist technical resource. The platform allows the following cardinality when mapping data.

  • One-to-many
  • Many-to-one
  • Or many-to-many

Your organisation’s mapping data can be made available via web services for real time consumption or in CSV/delimited format for consumption in batch mode. Furthermore this utility allows businesses to create various other master data sets, such as list of values and data hierarchy.

The data hierarchy can be used by the enterprise business intelligence reporting layer of the business for reporting needs.

The data sets created and managed by the business users are presented via web services and cloud hosted ETL to the business.

Service features:

  • Trusted customer data is held in a central MDM schema
  • Consolidation services manage the movement of master data into the central store
  • Cleansing services de-duplicate, standardise and augment the master data
  • Governance services control access, retrieval, privacy, audit and change management rules
  • Sharing services include integration, web services, event propagation, and global standards based synchronisation

Service benefits

  • Deliver a comprehensive single customer and asset view of your organisation
  • Rapid to implement MDM using contemporary approaches
  • Get a complete picture of what customers really use and require
  • Enable the application of analysis to understand and model demand
  • Provide accurate and complete source data from which insight for long term planning and policy development can be developed

See Master Data Management on G Cloud