Share via

SQL Server: Enterprise Information Management

  • Article

Managing information, and using it to make critical business decisions, is a growing priority for businesses today. However, the increasing volume, complexity, and diversity of data across a typical enterprise, together with the demands of meeting compliance and regulatory requirements, can make the challenge of integrating data extremely daunting.

Microsoft’s Enterprise Integration Management (EIM) technologies, built on the foundation of Microsof SQL Server 2012, provide a scalable, user-driven solution that empowers organizations to unlock the business value of their data.

SQL Server 2012 provides all the components needed for an effective Enterprise Information Management (EIM) solution in a single product.

Key components of SQL Server 2012 that help you build an EIM solution are:

  • SQL Server Integration Services
  • SQL Server Data Quality Services
  • SQL Server Master Data Services

SQL Server Integration Services

SSIS provides a powerful, extensible platform for integrating data from a variety of sources in a comprehensive extract, transform, and load (ETL) solution that supports business workflows, a data warehouse, or master data management. See Integration Services Overview topic for a quick overview and typical uses of SSIS.

SQL Server Data Quality Services

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. See Introducing Data Quality Services topic for the business need for DQS and how DQS answers the need.

SQL Server Master Data Services

MDS provides a central data hub that ensures that the integrity of information and consistency of data is constant across different applications.

Overview

See Master Data Services Overview/a> topic for brief descriptions of important features of MDS