SAS IT Resource Management Transformations

SAS IT Resource Management supplies many transformations that enable you to work with your IT data. To specify a transformation, you must first open (or create) a job. This action creates a process flow diagram on the Diagram tab of the Job Editor window. Transformations can be dragged and dropped onto the process flow diagram of the job, and their properties, data sources, and resulting tables can then be specified according to your requirements. The Adapter Setup wizard specifies the necessary transformations programmatically, or you can do so by working directly with the transformations.

In addition to the standard SAS Data Integration Studio transformations that are accessible from the Transformations tree, SAS IT Resource Management provides the following transformations:

Type of Transformation	Description
Aggregation	Specifies how a staged (or other) table is to be aggregated into a simple or summarized aggregation table. This transformation also supports the creation of aggregation tables from templates.
Data Acquisition	Specifies how to extract a subset of VMware data from a database.
Exception	Specifies how to detect exceptional conditions that might exist in the source data.
Information Map	Creates information maps from aggregation tables.
Performance Report	Specifies the reports that are to be generated from information maps or aggregation tables and how these reports are to be stored in the SAS Content Server.
Staging (one for each supported adapter)	Specifies how raw data is to be processed and loaded into staged tables for the supported adapters.
User-Written Staging	Specifies how raw data is to be processed and loaded into staged tables for data that is not supported by IT Resource Management adapters.

To locate these transformations, select the Transformations tree and navigate to the SAS IT Resource Management folder. For information about the properties of transformations, see Transformations Tree.