Servers

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

    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.
    • 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:

      1

      File Name:

      EIM Tutorial.docx

      Suppliers.xls

      Date Published:

      10/30/2012

      File Size:

      2.7 MB

      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.
    • 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

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial