There are shortcuts which invoke wizards that aid the user in performing various tasks with Sas ETL Studio.
Some of these wizards are:
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.
>>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.
Subscribe to our youtube channel to get new updates..!
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
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.
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.
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:
||enables you to import metadata from other applications that support the Common Warehouse Metamodel (CWM) format. Optional bridges are available for other formats.|
||enables you to export metadata to other applications that support the Common Warehouse Metamodel (CWM) format. Optional bridges are available for other formats.|
||is a target designer that enables you to create a cube, a data store that supports Online Analytical Processing.|
enables you to create a user-written, SAS code transformation and make it available in the Process Library tree.
The Options window can be used to define standard settings for the SAS ETL Studio interface.
There are several tabs in the Options window:
- 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.|
||specifies the SAS server to be used with SAS ETL Studio, and tests the connection to the server.
||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).|