Speaker Name SQL Server EIM Integration Services Master

[Speaker Name]

SQL Server EIM Integration Services Master Data Services Data Quality Services Complete, Clean, Consistent and Current Data

Architecture

Architecture: Control Flow

Architecture: Data Flow

Architecture: Data Flow Extract Transform Load

SQL Server 2016 New Features

SQL Server 2016 New Features: Azure Feature Pack

SQL Server 2016 New Features: Azure Feature Pack

SQL Server 2016 Support by Edition

Resources https: //msdn. microsoft. com/en-us/library/ms 141026 https: //msdn. microsoft. com/en-us/library/bb 522534. aspx https: //msdn. microsoft. com/en-us/library/cc 645993. aspx? #IS https: //blogs. msdn. microsoft. com/ssis/

Resources https: //technet. microsoft. com/en-us/virtuallabs

MDM

MDM

MDM

Operational MDM

Analytical MDM

Architecture

Sample Implementation MDS Source System(s) Administration WCF Data Service Data Changes SSIS SS IS No tifi cat ion Data Warehouse Data Steward via Master Data Manager or Excel SSIS Outlook

EIM Integration

SQL Server 2016 New Features

Resources https: //msdn. microsoft. com/en-us/library/ee 633763. aspx https: //msdn. microsoft. com/en-us/library/ff 929136. aspx https: //msdn. microsoft. com/en-us/library/cc 645993. aspx? #MDS https: //blogs. msdn. microsoft. com/mds/

Resources https: //technet. microsoft. com/en-us/virtuallabs

Architecture Source: MSDN https: //msdn. microsoft. com/ en-us/library/ff 877917. aspx

Benefits

EIM Integration

EIM Integration

EIM Integration

SQL Server 2016 New Features

Resources https: //msdn. microsoft. com/en-us/library/ff 877917. aspx https: //blogs. msdn. microsoft. com/dqs/

Summary • Integration Services • Master Data Services • Data Quality Services

SQL Server 2016 EIM Integration Services Master Data Services Data Quality Services Complete, Clean, Consistent and Current Data

© 2016 Microsoft Corporation. All rights reserved. Microsoft, Windows, Microsoft Azure, and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION