What's New Table of Contents  

What's New in SAS ETL Studio 3.3


SAS ETL Studio 3.3 (renamed to SAS Data Integration Studio in March 2006) makes it much easier to perform the following tasks:

Note: SAS ETL Studio 3.3 adds new features to the version of SAS ETL Studio that originally shipped with SAS 9.1.3.

Dynamic Grid Enablement and Parallel Processing

SAS ETL Studio uses a set of macros to enable parallel processing. These macros can be enabled in two ways:

When parallel processing is enabled for a SAS ETL Studio job, the transformations in the job can be executed in parallel on a single machine that supports symmetric multiprocessing (SMP) or by a grid computing network—if the grid software is licensed.

Dynamic Grid Enablement and Parallel Processing for Iterative Jobs

You can create iterative jobs (processing loops) with the following new components:

Change Analysis on Imported Metadata

When you import metadata to SAS ETL Studio, you can view the differences between the imported metadata and existing metadata and choose which changes to apply. Changes in tables, columns, indexes, and keys display in a Differences window. To help you understand the impact of a given change, you can run impact analysis or reverse impact analysis on imported tables and columns.

New Lookup Transformation

You can use the new Lookup transformation in a job to load a target with columns that are taken from a source and from a number of lookup tables. The Lookup transformation offers a number of advantages over the existing Fact Table Lookup transformation:

Enhanced Support for SPD Server Tables

The SAS Scalable Performance Data (SPD) Server is a high performance, multi-user, parallel-processing data server. It stores data in a special format that facilitates parallel processing. You can now use the properties window for an SPD Server table to specify options that are unique to those tables. You can also use a new loader transformation, the SPD Server Table Loader, to specify options that are unique to SPD Servers. The new loader generates code that is appropriate for the special data format that the SPD Server uses.

New Support for Cluster Analysis

The Create Match Code transformation now supports cluster analysis as well as match code analysis. Cluster analysis assigns cluster numbers based on multiple conditions. For example, suppose you wanted to eliminate duplicate mailings to members of the same household. When analyzing a demographic database, conditions can be defined for names and for street address and zip code. Rows that match either condition receive the same cluster number and would be considered as one household.

Enhanced Change Management

The following improvements make it easier to use change management in SAS ETL Studio:

You must have the latest metadata server for these features to be enabled.

Enhanced View Data Window

The View Data window now enables you to do the following tasks:

Enhanced Update Table Metadata Feature

This feature has been improved in the following ways:

Your SAS application server must have the latest SAS Workspace Server component for these features to be enabled.

Enhanced Support for Cubes

New options enable you to export and import cube metadata; save the OLAP procedure code that is generated for a cube; maintain calculated members that are associated with a cube; and tune aggregations.

General Enhancements

Some new features in SAS Data Integration Studio 3.3 require the latest servers. It is strongly recommended that you upgrade your metadata for the current release of SAS ETL Studio. See the installation instructions for further information.

For details about upgrading metadata as required for SAS 9.1.3, as well as installing and configuring servers, libraries, users, and other resources that are required by SAS ETL Studio, see the SAS 9.1.3 Intelligence Platform: Installation Guide and the SAS 9.1.3 Intelligence Platform: Administration Guide.