Wizards

---

The following wizards are available from the Shortcut Bar or the Tools item on the menu bar on the SAS ETL Studio desktop.

Table 2.4: SAS ETL Studio Wizards

Wizard	Description
Cube Designer	Enables you to create a cube, which is a data store that supports online analytical processing. See Chapter 11, "Creating Cubes," on page 161.
Data Surveyors (optional)	If installed, enable you to access the metadata in enterprise applications from vendors such as PeopleSoft, SAP R/3, Siebel, and Oracle.
Export Job to File	Enables you to export a SAS ETL Studio job to an XML file.
Job Import and Merge	Enables you to import jobs that have been exported from SAS ETL Studio.
Metadata Exporter	Enables you to export metadata to other applications that support CWM format. Optional bridges are available for other formats. See "Metadata Import and Export" on page 11.
Metadata Importer	Enables you to import metadata from other applications that support CWM format. Optional bridges are available for other formats. See "Metadata Import and Export" on page 11.
New Job	Enables you to select one or more tables as the target(s) (outputs) for a new job. Generates metadata for the new job. See "New Job Wizard" on page 103.
Source designers	Enable you to generate metadata for tables or external files that exist in physical storage. See "Using Source Designers" on page 61.
Target designers	Enable you to create metadata for an object that will be created in the future, but does not currently exist in physical storage. An example of such an object would be a table that will be created when a SAS ETL Studio job is executed. See "Using Target Designers" on page 63.
Transformation Generator	Enables you to create a user-written, SAS code transformation and make it available in the Process Library tree. One of the easiest ways to customize SAS ETL Studio. See "Transformation Generator Wizard" on page 112.

In addition the wizards that were described in the previous table, the following wizards are available from the New Object wizard selection window. This window is displayed by selecting File New Object from the SAS ETL Studio desktop. Some of these wizards are also available from the properties windows for some objects, as described in the following table.

Table 2.5: Wizards That Are Accessible from New Object Wizard Selection Window

Wizard	Description
New Document	Enables you to define a document that you can associate with one or more objects in a metadata repository.
New Group	Enables you to add a user-defined group to the Custom tree on the SAS ETL Studio desktop.
New Library	Enables you to define a SAS library for SAS data or for other data. See "Enter Metadata for Libraries" on page 44.
New Note	Enables you to define a note that you can associate with one or more objects in a metadata repository.

---