SAS Data Integration Studio is a visual design tool
that enables you to consolidate and manage enterprise data from a
variety of source systems, applications, and technologies. This software
enables you to create process flows that accomplish the following
tasks:
-
extract, transform, and load data
for use in data warehouses and data marts
-
cleanse, migrate, synchronize,
replicate, and promote data for applications and business services
SAS Data Integration Studio enables you to create
metadata that defines sources, targets, and the processes that connect
them. This metadata is stored in one or more shareable repositories.
SAS Data Integration Studio uses the metadata to generate or retrieve
SAS code that reads sources and creates targets in physical storage.
Other applications that share the same repositories can use the metadata
to access the targets and use them as the basis for reports, queries,
or analyses.
Through its metadata,
SAS Data Integration Studio provides a single point of control for
managing the following resources:
-
data sources (from any platform
that is accessible to SAS and from any format that is accessible to
SAS)
-
data targets (to any platform that
is accessible to SAS, and to any format that is supported by SAS)
-
processes that specify how data
is extracted, transformed, and loaded from a source to a target
-
jobs that organize a set of sources,
targets, and processes (transformations)
-
source code generated by SAS Data
Integration Studio
-
user-written source code, including
legacy SAS programs
Note: SAS Data Integration Studio
was formerly named SAS ETL Studio.
For more information,
see the SAS Data Integration Studio Help, which is available from
within the product, and the
SAS Data Integration Studio: User's Guide, which
is available at
http://support.sas.com
. For information about administrative tasks associated with SAS
Data Integration Studio, see the
SAS Intelligence Platform: Desktop Application Administration Guide.