SAS 9.1.3 ETL Studio: Users Guide

This manual is intended for people who assume the following roles:

• SAS ETL Studio user—a person who uses SAS ETL Studio software to extract, transform, and load information into a data warehouse or data mart.

• SAS ETL Studio metadata administrator—a person who uses SAS Management Console software to maintain the metadata for servers, users, and other global resources that are required by SAS ETL Studio.

This manual is not intended for server administrators—people who install and maintain server hardware or software. However, some SAS ETL Studio tasks depend on tasks that the server administrator performs.

A common scenario for SAS ETL Studio projects is as follows:

• A server administrator installs and starts servers. For details about maintaining these servers, administrators should see the documentation that came with the servers. See also the SAS Intelligence Platform: Planning and Administration Guide.

• A metadata administrator uses SAS Management Console to define metadata for servers, users, libraries, and other global resources, as described in Chapter 5, "Setup Tasks for Administrators," on page 37. For details about maintaining global metadata, see the online Help for in SAS Management Console. See also the SAS Management Console: User's Guide and the SAS Intelligence Platform: Planning and Administration Guide.

• SAS ETL Studio users create jobs that extract, transform, and load information into a data warehouse or data mart, as described in "Main Task Flow for Users" on page 59. Users are simply told which servers, user identities, libraries, and other global resources to use.