Skip to main content
Enterprise Information Management Tutorials

This section contains tutorials for managing information in an enterprise by using Enterprise Information Management (EIM) technologies that are included in SQL Server 2012. Enterprise Integration Management (EIM) provides a portfolio of solutions that enable organizations to trust the credibility and consistency of their data so they can make critical business decisions. SQL Server 2012 has the following technologies that help you implement EIM solutions in your enterprise.

  • SQL Server Integration Services (SSIS). SSIS provides a powerful, extensible platform for integrating data from various sources in a comprehensive extract, transform, and load (ETL) solution that supports business workflows, a data warehouse, or master data management.

  • SQL Server Data Quality Services (DQS). DQS enables you to cleanse, match, standardize, and enrich data, so you can deliver trusted information for business intelligence, a data warehouse, and transaction processing workloads.

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

Enterprise Information Management using SSIS, MDS, and DQS Together [Tutorial]

In this tutorial, you learn how to use SSIS, MDS, and DQS together to implement a sample Enterprise Information Management (EIM) solution. First, you use DQS to create a knowledgebase with the knowledge about the supplier data (metadata), cleanse the data in an Excel file against the knowledge base, and match the data to identify and remove duplicates in the data. Next, you use the MDS Add-in for Excel to upload the cleansed and matched data to MDS. Then, you automate the whole process by using an SSIS solution.