The content in this unit covers SQL Server 2012 improvements related to Enterprise Information Management, including Integration Services, Master Data Services and Data Quality Services.
Hands-On Labs
Exploring SQL Server 2012 Integration Services (RTM Update)
In this lab, you will commence by exploring a partially completed Integration Services project designed to populate the Adventure Works data warehouse. You will explore the design of the packages and specifically the use of a project connection manager and package parameters - both being new features in Integration Services for SQL Server 2012.
Exploring SQL Server 2012 Master Data Services (RTM Update)
In this lab, you will create a Master Data Services model and entities to store a master list of geographic data. The entity and attribute creation will be achieved using the Master Data Services Add-in for Excel.
Exploring SQL Server 2012 Data Quality Services (RTM Update)
In this lab, you will create a Data Quality Services knowledge base to cleanse US state codes and email addresses. You will then create a Data Quality Project to cleanse data in an Excel workbook. Next, you will update an Integration Services package to use the DQS Cleansing component to cleanse the data as part of an ETL process.
Videos
Presentation: Introducing SQL Server 2012 Integration Services Improvements
SQL Server 2012 Integration Services introduces a host of new improvements of interest to developers and IT Professionals alike. Developers will appreciate a greatly improved package design experience, and IT Professionals will find a powerful new set of tools and services that will greatly simplify the deployment, management and monitoring of SSIS packages running on servers.
Demo: Developing and Monitoring a SQL Server 2012 Integration Services Solution
This demonstration explores the new features of SQL Server 2012 Integration Services (SSIS). Specifically it covers project conversion, parameters, project connection managers, deployment to the SSIS catalog, package execution and viewing the built-in reports.
Presentation: Introducing SQL Server 2012 Master Data Services Improvements
SQL Server 2012 Master Data Services is a set of tools and services that can be used to integrate disparate information systems that share common data sets into a common master data management solution. This new release offers several key improvements centered around usability, robustness, security, scale, and performance.
Demo: Managing Data with SQL Server 2012 Master Data Services
This demonstration creates a new model and then uses the Master Data Services (MDS) Add-in for Excel to create and load two entities. Then in the Master Data Manager web application, the loaded members are explored. A new member is added, and an existing member is updated. Finally, a subscription view is created to facilitate retrieval of the entity members.
Presentation: Introducing SQL Server 2012 Data Quality Services
SQL Server 2012 Data Quality Services is a new knowledge-driven data cleansing solution that makes it easy to correct and de-duplicate data. DQS makes it easy for domain experts to build and improve a data quality knowledge base over time and can be reused by other solutions like Integration Services and Master Data Services.
Demo: Deduplicating Data with SQL Server 2012 Data Quality Services
This demonstration identifies and loads unique (non-duplicate) resellers into the Reseller entity of a Master Data Services (MDS) model. It involves creating a Data Quality Services (DQS) knowledge base and matching policy, and then using this matching policy with the MDS Excel add-in.