Overview of Transformations
Introduction to Transformations
You want to select the right transformation to perform a specific task. The
transformation enables you to include that task in a SAS Data Integration Studio job
flow.
A transformation is a metadata object that specifies how to extract data, transform data,
or load data into data stores. Each transformation that you specify in a process flow
diagram generates or retrieves SAS code. You can also specify user-written code in the
metadata for any transformation in a process flow diagram.
Overview of the Transformations Tree
The Transformations tree organizes transformations into a set of folders. You can drag a
transformation from the Transformations tree to the Job Editor, where you can connect it
to source and target tables and update its default metadata. By updating a transformation
with the metadata for actual sources, targets, and transformations, you can quickly create
process flow diagrams for common scenarios. The following display shows the standard
Transformations tree.
Display 2.2 Transformations Tree
This document has an example of the main transformations used in SAS Data Integration
Studio, and the online Help has an example of all transformations. The following
sections describe the contents of the Transformations tree folders.
Access Folder
The following table describes the transformations in the Access folder in the
Transformations tree.
32 Chapter 2 Getting Started
Table 2.3 Access Folder Transformations
Name Description
DB2 Bulk
Table
Loader
Used to bulk load SAS and most DBMS source tables to a DB2 target table. For
more information, see “About the DB2 Bulk Table Loader” on page 426.
File Reader Reads an external file and writes to a SAS or DBMS table. For more
information, see “Using an External File in the Process Flow for a Job” on page
138.
File Writer Reads a SAS or DBMS table and writes to an external file. For more
information, see “Using an External File in the Process Flow for a Job” on page
138..
Library
Contents
Generates an output table that lists the tables contained in an input library. If
there is no input library, then the transformation generates a list of tables from all
of the libraries that are allocated on the SAS Workspace Server. For more
information, see “Creating a Control Table” on page 512.
Microsoft
Queue
Reader
Delivers content from a Microsoft MQ message queue to SAS Data Integration
Studio. If the message is being sent into a table, the message queue content is
sent to a table or a SAS Data Integration Studio transformation. If the message is
being sent to a macro variable or file, then these files or macro variables can be
referenced by a later step. For more information, see “Processing a Microsoft
Queue” on page 574.
Microsoft
Queue
Writer
Enables writing files in binary mode, tables, or structured lines of text to the
WebSphere MQ messaging system. The queue and queue manager objects
necessary to get to the messaging system are defined in SAS Management
Console. For more information, see “Processing a Microsoft Queue” on page
574.
Oracle Bulk
Table
Loader
Enables bulk loading of SAS or Oracle source data into an Oracle target. For
more information, see “About the Oracle Bulk Table Loader Transformation” on
page 425.
REST Enables you to use the REST approach to read from and write to a third-party
web service in the context of a SAS Data Integration Studio job. For more
information, see “Using REST to Access a Third-Party Web Service” on page
750.
SOAP Enables you to use the SAS SOAP procedure to read from and write to a third-
party web service in the context of a SAS Data Integration Studio job. For more
information, see “Using SOAP to Access a Third-Party Web Service” on page
747.
SPD Server
Table
Loader
Reads a source and writes to a SAS SPD Server target. Enables you to specify
options that are specific to SAS SPD Server tables. For more information, see
“About the SPD Server Table Loader Transformation” on page 422.
Table
Loader
Reads a source table and writes to a target table. Provides more loading options
than other transformations that create tables. For more information, see “About
the Table Loader Transformation” on page 424.
Overview of Transformations 33

Get SAS Data Integration Studio 4.9 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.