SAS ETL Studio Wizards - SAS BI

 

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.

Source Designer

>>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

Target Designer

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

MindMajix Youtube Channel

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.

New Job Wizard

An empty job can be created, without importing metadata from any predefined target table, by clicking  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.

                                                   Checkout SAS BI Interview Questions

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:

Generalcontrols the overall display of SAS ETL Studio and the functionality of the wizards.
Processcontrols the look and feel of the process editor window.
Editorcontrols the look and feel of the SAS text editor for generated code.
Metadata Treecontrols 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).

 

About Author

Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.

read less
  1. Share:
SAS BI Articles