Master Data Services

Organizations need to manage data across a wide range of systems and store it in a variety of formats across the enterprise.

  • SQL Server 2012 Master Data Services add-in for Microsoft Excel

    SQL Server Master Data Services provides a central data hub that ensures the integrity of information and consistency of data is constant across different applications.

    What's New in SQL Server 2012

    • Redesigned web interface to add, delete, and move members quickly.
    • Excel front-end (MDS add-in) allowing business users to autonomously add and edit data in the underlying systems on their own.
    • Improved performance, security, robustness, and scalability.
    • Integrated with Data Quality Services to data match before load.

    Key Capabilities

    • Create Master Data By Standardizing Data Definitions For Key Business Entities

      Collect and maintain accurate and complete master data to ensure standardized data definitions of key business entities across all of your IT assets.

      • Manage data consistency across different environments including Oracle, Microsoft SQL Azure, HP, and IBM.
      • Manage the superset of all data attributes across all systems.
      • Create explicit hierarchies based on traditional parent-child relationships.
      • Produce derived hierarchies from pre-existing data relationships found within master data models.

    • Create a Master Data Hub for Your Enterprise

      Implement a master data management hub to manage the master data that is stored in the database and keep it synchronized with the transactional systems that use the master data.

      • Effectively track all known attributes across the enterprise.
      • Create versions for each model at different time intervals.
      • Commit versions of master data only after business rules have been met.

    • Empower Business Users to Manage Data Governance

      Trust the experience of business-knowledgeable users, so organizations can improve master data maintenance and avoid the delays and mistakes that occur when non-business specialists manage and maintain data.

      • End users can directly manage the underlying database and data warehouse dimensions and hierarchies using Excel.
      • Free IT responsibilities so they can focus on the oversight of the overall data warehouse.

    Related Solutions

    "With the Master Data Services Add-in for Excel in SQL Server 2012, our data stewards will use a familiar environment to manage the authoritative list of lender master data. Now, we can provide unsurpassed insight into this data, including information that is difficult to correlate such as loan pools."

    Richard Sawicky
    Senior Director of Database Technology

    Resources