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 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.