Microsoft

Tutorial: Enterprise Information Management using SSIS, MDS, and DQS Together

Share
Language:
English
In this tutorial, you will learn how to use SQL Server Integration Services (SSIS), Master Data Services (MDS), and Data Quality Services (DQS) together to implement a sample Enterprise Information Management (EIM) solution.
  • Details

    Note: There are multiple files available for this download. Once you click on the “Download” button, you will be prompted to select the files you need.
    Version:
    Date Published:

    1

    10/30/2012

    File name:
    File size:

    EIM Tutorial.docx

    2.7 MB

    Suppliers.xls

    42 KB

      Managing information in an enterprise typically involves integrating data from across the enterprise and beyond, cleansing the data, matching the data to remove any duplicates, standardizing the data, enriching the data, making the data conform to legal and compliance requirements, and then storing the data in a centralized location with all the necessary security settings. In this tutorial, you will learn how to use SQL Server Integration Services (SSIS), Master Data Services (MDS), and Data Quality Services (DQS) together to implement a sample Enterprise Information Management (EIM) solution. First, you will use DQS to create a knowledgebase that contains knowledge about the data (metadata), cleanse the data in an Excel file using the knowledge base, and match the data to identify and remove duplicates in the data. Next, you will use the MDS Add-in for Excel to upload the cleansed and matched data to MDS. Then, you will automate the whole process using an SSIS solution.
  • System Requirements

    Supported Operating System

    Windows 7, Windows Server 2008 R2

      • SQL Server 2012 with the following components installed:
        • Integration Services
        • Master Data Services
        • Data Quality Services
        • SQL Server Data Tools
      • Microsoft Excel 2010 (32-bit preferred)
      • Master Data Services Add-in for Excel
      • Visual Studio 2010 Tools for Office Runtime
      See the Prerequisites section in the Tutorial document for more details.
  • Install Instructions

      • Download the files into a folder (example: C:\EIM Tutorial).
      • Follow instructions in the Tutorial WORD document.

Popular downloads

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers
Run Microsoft Update
close
moreinfo