Overview of SAS Data Integration
https://sasdataintegrationonlinetraining.blogspot.com/2015/11/overview-of-sas-data-integration.html
Data integration is the process of consolidate
data from a multiplicity of sources in order to produce a unified view of the
data. SAS supports data integration in the following ways:
• Connectivity and metadata. A shared
metadata environment provides reliable data definition across all data sources.
SAS software enables you to connect to, obtain, store, and write data back to a
variety of data stores, streams, applications, and systems on a variety of
platforms and in many different environments. For example, you can manage
information in Enterprise Resource Planning (ERP) system, relational database management
systems (RDBMS), flat files, inheritance systems, message queues, and XML.
• Data cleansing and enhancement.
Integrated SAS Data Quality software enables you to profile, wash, supplement,
and monitor data to create steady, reliable information.SAS Data Integration
Studio provides a number of transformation and functions that can improve the
quality of your data.
• Data federation. SAS Data Integration
Studio enables you to query and use data across multiple systems without the
physical association of source data. It provides virtual access to database
structures, ERP applications, legacy files, text, XML, message queues, and a
host of other sources. It enables you to join data across these virtual data sources
for real-time access and analysis. The semantic business metadata layer shields
business staff from original data complexity.
• Extraction, alteration, and loading.
SAS Data Integration Studio enables you to extract, transform, and load data
from across the enterprise to create consistent, accurate information. It
provides a point-and-click interface that enables designers to build process
flows, quickly recognize inputs and outputs, and create business rules in metadata,
all of which enable the rapid production of data warehouses, data marts, and data
streams.
• Migration and synchronization. SAS
Data Integration Studio enables you to migrate, synchronize, and duplicate data
among different operational systems and data sources. Data transformations are
available for altering, reformatting, and consolidating information. Real-time
data quality integration allows data to be cleansed as it is being moved,
replicated, or synchronized, and you can with no trouble build a library of
reusable business rules.
• Master data management. SAS Data
Integration Studio enables you to create a unified view of enterprise data from
multiple sources. Semantic data descriptions of input and output data sources
uniquely identify each instance of a business element (such as customer,
product, and account) and standardize the master data model to provide a single
source of truth. Transformations and embedded data quality processes ensure that
master data is correct.
