Contents
About
Introduction
Overview of SAS Data Integration
About SAS Data Integration
Advantages of SAS Data Integration
A Basic Data Integration Environment
Online Help for SAS Data Integration Studio
Administrative Documentation for SAS Data Integration Studio
Accessibility Features in SAS Data Integration Studio
Upgrading from Earlier Versions
General User Tasks
Getting Started
Setup for SAS Data Integration Studio
Security for SAS Data Integration Studio
Main Tasks for Creating Process Flows
Starting SAS Data Integration Studio
Connecting to a SAS Metadata Server
Working with the Folders Tree
Selecting a Default SAS Application Server
Registering SAS Libraries
Working with User-Defined Formats
Registering Tables and Cubes
Specifying Global Options in SAS Data Integration Studio
Working with Change Management
Add a Note or Document to a Registered Object
View the Content of Notes or Documents
Importing, Exporting, and Copying Metadata
Metadata Import and Export in SAS Data Integration Studio
Working with SAS Package Metadata
Preparing to Import or Export SAS Package Metadata
Exporting SAS Package Metadata
Importing SAS Package Metadata
Copying and Pasting Metadata Objects
Working with SAS Metadata Bridges
Usage Notes for Importing or Exporting with a SAS Metadata Bridge
Preparing to Import or Export with a SAS Metadata Bridge
Importing New Metadata with a SAS Metadata Bridge
Importing Updated Metadata with a SAS Metadata Bridge
Exporting Metadata with a SAS Metadata Bridge
Working with Tables
About Tables
Registering Existing Tables with the Register Tables Wizard
Registering New Tables with the New Table Wizard
Viewing or Updating Table Metadata
Using a Physical Table to Update Table Metadata
Specifying Options for Tables
Supporting Case and Special Characters in Table and Column Names
Maintaining Column Metadata
Maintaining Keys
Maintaining Indexes
Browsing Table Data
Editing SAS Table Data
Using the View Data Window to Create a SAS Table
Specifying Browse and Edit Options for Tables and External Files
Working with External Files
About External Files
Registering a Delimited External File
Registering a Fixed-Width External File
Registering an External File with User-Written Code
Viewing or Updating External File Metadata
Overriding the Code Generated by the External File Wizards
Specifying NLS Support for External Files
Accessing an External File with an FTP Server or an HTTP Server
Viewing Data in External Files
Registering a COBOL Data File That Uses a COBOL Copybook
Using an External File in the Process Flow for a Job
Creating Jobs
About Jobs
Creating an Empty Job
Creating a Process Flow for a Job
Creating a Job That Contains Jobs
Working with Default Temporary Output Tables
About Job Options
Documenting Process Flow Diagrams
Accessing Local and Remote Data
Viewing or Updating Job Metadata
Displaying the SAS Code for a Job
Common Code Generated for a Job
Managing Jobs
About Managing Jobs
Submitting a Job for Immediate Execution
Meeting Prerequisites for Collecting Job Statistics
Reviewing a Successful Job
Diagnosing and Correcting an Unsuccessful Job
Maintaining Column Mappings
Managing the Scope of Column Changes in Jobs
Managing Connections in Job Editor Windows
Viewing the Code for a Transformation
Viewing or Updating the Metadata for Transformations
Managing the Status of Jobs and Transformations
About Status Handling for Jobs and Transformations
Default Conditions, Actions, and Conditional Action Sets
Prerequisites for Actions
Perform Actions Based on the Status of a Job
Perform Actions Based on the Status of a Transformation
Macro Variables for Status Handling
Deploying Jobs
About Deploying Jobs
About Deploying Jobs for Scheduling
Prerequisites for Deploying a Job for Scheduling
Deploying Jobs for Scheduling
Redeploying Jobs for Scheduling
Using Scheduling to Handle Complex Process Flows
Using Deploy for Scheduling to Execute Jobs on a Remote Host
About Deploying Jobs as Stored Processes
Prerequisites for Deploying a Job as a Stored Process
Deploying Jobs as Stored Processes
Redeploying Jobs to Stored Processes
Viewing or Updating Stored Process Metadata
About Deploying Jobs as Web Services
Prerequisites for Web Service Jobs
Requirements for Web Service Jobs
Creating a Web Service Job
Deploying a Web Service Job as a Stored Process
Deploying a Stored Process as a Web Service
Working with Generated Code
About Code Generated for Jobs
Displaying the Code Generated for a Job
Displaying the Code Generated for a Transformation
Specifying Options for Jobs
Specifying Options for a Transformation
Modifying Configuration Files or SAS Start Commands for Application Servers
Working with User-Written Code
About User-Written Code
Adding User-Written Code to the Precode and Postcode Tab
Adding a User Written Code Transformation to a Job
Creating and Using a Generated Transformation
Maintaining a Generated Transformation
Editing the Generated Code for a Job or Transformation
Replacing the Generated Code for a Job or Transformation
Optimizing Process Flows
About Process Flow Optimization
Managing Process Data
Managing Columns
Streamlining Process Flow Components
Using Simple Debugging Techniques
Using SAS Logs
Reviewing Temporary Output Tables
Additional Performance Optimization Information
Using Impact Analysis
About Impact Analysis and Reverse Impact Analysis
Performing an Impact Analysis
Performing Impact Analysis on a Generated Transformation
Performing Reverse Impact Analysis
Working with Reports
About Reports
Opening the Reports Window
Selecting the Reports Perspective
Customizing the Tables Report
Customizing the Job Documentation Report
Running and Saving a Report
Saving a Report As a Document Object
Viewing a Report
Creating Your Own Report
Working with Transformations
Working with Loader Transformations
About Loader Transformations
About the SPD Server Table Loader Transformation
About the Table Loader Transformation
Setting Table Loader Transformation Options
Selecting a Load Technique
Removing Non-Essential Indexes and Constraints during a Load
Considering a Bulk Load
Working with SAS Sort Transformations
About Sort Transformations
Optimizing Sort Performance
Creating a Table That Contains the Sorted Contents of a Source
Working with SQL Join Transformations
About SQL Join Transformations
Using the Designer Window
Reviewing and Modifying Clauses, Joins, and Tables in an SQL Query
Understanding Automatic Joins
Selecting the Join Type
Adding User-Written SQL Code
Debugging an SQL Query
Adding a Column to the Target Table
Adding a Join to an SQL Query on the Designer Tab
Creating a Simple SQL Query
Configuring a SELECT Clause
Adding a CASE Expression
Creating or Configuring a WHERE Clause
Adding a GROUP BY Clause and a HAVING Clause
Adding an ORDER BY Clause
Adding Subqueries
Validating or Submitting an SQL Query
Joining a Table to Itself
Using Parameters with an SQL Join
Constructing a SAS Scalable Performance Data Server Star Join
Optimizing SQL Processing Performance
Performing General Data Optimization
Influencing the Join Algorithm
Setting the Implicit Property for a Join
Enabling Pass-Through Processing
Using Properties Window Options to Optimize SQL Processing Performance
Working with Iterative Jobs and Parallel Processing
About Iterative Jobs
Creating and Running an Iterative Job
Creating a Parameterized Job
Creating a Control Table
About Parallel Processing
Setting Options for Parallel Processing
Working with Slowly Changing Dimensions
About Slowly Changing Dimensions
About Dimension Tables
About Fact Tables
Loading a Dimension Table with Type 1 and 2 Updates
Loading a Fact Table Using Dimension Table Lookup
Loading a Table and Adding a Surrogate Primary Key
Tracking Changes in Source Datetime Values
Closing Out Rows in Datetime Change Tracking
Working with Change Data Capture
About the Change Data Capture Transformations
About CDC Changed Data Tables
About CDC Control Tables
Capture Changed Data from Oracle
Working with Message Queues
About Message Queues
Prerequisites for Message Queues
Selecting Message Queue Transformations
Processing a WebSphere Queue
Polling a Websphere Message Queue
Processing a Microsoft Queue
Working with SPD Server Cluster Tables
About SPD Server Cluster Tables
Creating an SPD Server Cluster Table
Maintaining an SPD Server Cluster
Appendixes
Main Windows and Wizards
Analysis Window
Checkouts Tree
Code Editor
Comparison Results Window
Connection Profile Window
Desktop
Details Pane
Expression Builder
Folders Tree
Inventory Tree
Job Editor
Properties Windows
Reports Window
Tools-Options Window
Transformations Tree
Tree View
View Data Windows
Wizards
Java Code and Methods for Report Plug-ins
Example Java Code for a Report Plug-in
Reporting Interface Methods
Glossary
Product
Release
SAS Data Integration Studio Server Data
9.2
SAS Data Integration Studio
4.2
SAS Enterprise Data Integration Server
4.2
SAS Data Integration Server
4.2
Type
Usage and Reference
Copyright Date
February 2009
Last Updated
02Jul2009