Mindmajix

SAS ETL Studio Wizards

There are shortcuts which invoke wizards that aid the user in performing various tasks with SAS ETL Studio.

Some of these wizards are:

■      Source Designer
■      Target Designer
■      New Job.

Source Designer

The Source Designer is a wizard-driven interface that enables you to define the physical layout of existing tables using a data dictionary or metadata information from the source system.

The result of running the Source Designer successfully is a metadata registration that describes the data source.

Screenshot_1249

Unlike the SAS Warehouse Administrator product, which requires that, you must create Operational Data Definitions (ODDs) one table at a time, the Source Designer enables you to input the metadata from multiple tables with one pass through the wizard.

If the table is stored in an ERP System, the corresponding Data Surveyor will be invoked. The Data Surveyor contains information about the metadata of the source system.

If the table is a flat file, you can use a wizard to define the record layout. The Source Designer can be invoked by following these steps:

  • Click on the Source Designer icon from the Shortcut
  • Select Tools Ð Source Designer….
  • Right-click on the Source Tables group and select New Object Ð Source Table.

Target Designer

The Target Designer is a wizard that allows metadata to be entered for a target.

In designing the target table, you can

  • access any metadata about any source tables and columns registered in the metadata repository
  • override any metadata that was imported from another source and add new columns to the target table
  • create indexes on the target table being

Screenshot_1250

The target designer can also specify

  • the location of the target table
  • table-specific options to be stored in the metadata

The Target Designer can be invoked by following these steps:

  • Click on the Target Designer icon from the Shortcut bar.
  • Select Tools Ð Target Designer….
  • Right-click on the Target Tables group and select New Object Ð Target Table.

The person designing the target table has full control over the type of table being built.

The types of targets that can be built include

■      database types that are supported by the SAS/ACCESS products
■      SAS data sets (including both data files and data views)
■      SAS/SHARE data sets
■      SPDE tables.

SPDE – Scalable Performance Data Engine

New Job Wizard

The New Job wizard enables you to define the metadata necessary to run an ETL process to load data into a target or targets.

Screenshot_1251

An empty job can be created, without importing metadata from any predefined target table, by clicking Screenshot_1252 without selecting the metadata for a table. Objects from the tree view can then be dragged and dropped into the empty job.

You can invoke the New Job wizard by following these steps:

  • Click on the Process Designer icon from the Shortcut
  • Select Tools Ð Process Designer….
  • Right-click on the Jobs group and select New Object Ð Job.

Additional Wizards

Other wizards available to provide assistance with various tasks in SAS ETL Studio include

■      Metadata Importer
■      Metadata Exporter
■      Cube Designer
■      Transformation Generator wizard.

You can also install optional data surveyor wizards, which provide access to the metadata in enterprise applications, such as PeopleSoft, SAP R/3, Siebel, and Oracle.

These wizards can be invoked from the Shortcut Bar or the Tools pull-down menu of SAS ETL Studio:

Metadata Importer

enables you to import metadata from other applications that support the Common Warehouse Metamodel (CWM) format. Optional bridges are available for other formats.

Metadata Exporter

enables you to export metadata to other applications that support the Common Warehouse Metamodel (CWM) format. Optional bridges are available for other formats.

Cube Designer

is a target designer that enables you to create a cube, a data store that supports Online Analytical Processing.

Transformation Generator

enables you to create a user-written, SAS code transformation and make it available in the Process Library tree.

Options Window

The Options window can be used to define standard settings for the SAS ETL Studio interface.

There are several tabs in the Options window:

■      General
■      Process
■      Editor
■      Metadata Tree
■      SAS Server
■      Data Quality.

Using the Options window tabs, you can control the following:

General

controls the overall display of SAS ETL Studio and the functionality of the wizards.

Process

controls the look and feel of the process editor window.

Editor

controls the look and feel of the SAS text editor for generated code.

Metadata Tree

controls the tree view in the middle portion of SAS ETL Studio.

SAS Server

specifies the SAS server to be used with SAS ETL Studio, and tests the connection to the server.

Data Quality

specifies options to control the locale, the types of files to be used by the data quality plug-ins, and the location of the Quality Knowledge Base (QKB).


 

0 Responses on SAS ETL Studio Wizards"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.