Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Integrating with MDS and SSIS


DQS has the ability to interact with other data movement components: SSIS and Master Data Services (MDS). There is a DQS cleansing component in SSIS that provides a connection to a knowledge base. This component will create a cleansing project for the incoming data stream and will apply the Knowledge Base in the DQ server to the data stream and generate the result. There is also a functionality to apply matching rules on the data in an Excel spreadsheet before loading that data into MDS. In this section, we will explore how to use the interaction of DQS with MDS and SSIS.