Databases Reference
In-Depth Information
What Is SAS Data Integration Studio?
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 (ETL) 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 integrate information from any platform
that is accessible to SAS and from any format that is accessible to SAS.
Note:
SAS Data Integration Studio was formerly named SAS ETL Studio.
Important Concepts
Process Flows and Jobs
In SAS Data Integration Studio, a job is a metadata object that specifies processes
that create output. Each job generates or retrieves SAS code that reads data sources
and creates data targets in physical storage. To generate code for a job, you create a
process flow diagram that specifies the sequence of each source, target, and process in
the job. For example, the following display shows the process flow for a job that will
read data from a source table named STAFF, sort the data, then write the sorted data
to a target table named Staff Sorted.
Display 2.1
Process Flow Diagram for a Job
Each process in the flow is specified by a metadata object that is called a
transformation. In the previous figure, SAS Sort and Loader are transformations. A
Search WWH ::
Custom Search