Datasheet

Chapter 1: SSIS Solution Architecture
12
In this diagram, data from different systems is integrated. Often, a master data management service
(sometimes called master dimension management ) helps to synchronize entities between systems so that an
organization ’ s data relates (for example, so that a customer record from the customer relationship
management, or CRM, system can tie into the ERP sales system). This data process contains some aspects
that are bidirectional, and other parts that perform extraction and loads. Data staging is used in this
example to help integrate the data, and a data store is used to centralize many of the corporate data
processes (which helps alleviate the long chains of system dependencies).
Of course, other variations of system integration solutions exist, such as consolidation of different
divisional data, especially when companies go through mergers and acquisitions.
Data Warehouse ETL
One of the more common uses of SSIS is for performing data warehouse ETL. Data warehousing focuses
on decision support , or enabling better decision making through organized accessibility of information.
As opposed to a transactional system such as a point of sale (POS), Human Resources (HR), or CRM that
is designed to allow rapid transactions to capture information data, a data warehouse is tuned for
reporting and analysis. Because data warehousing is focused on the extraction, consolidation, and
ERP/
Accounting
Point of Sale
Integration
Data Store
Competitive Data
Demographics
Bi-Directional Integration with Core Corporate Systems
Cycle Through Remote Inventory Systems
Customer
Relationship
Management
Master Data
Services
Integration
Services
Data Integration
Staging Area
External FTP File
Handling
Human
Resources
Figure 1-5
c01.indd 12c01.indd 12 9/24/09 11:26:33 AM9/24/09 11:26:33 AM