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.
Data Acquisition
Specifies how to extract a subset of VMware data from a database.
Gallery
Specifies the gallery reports that are to be generated from information maps or aggregation tables and how these reports are to be stored on the SAS Content Server.
Information Map
Creates information maps from aggregation tables.
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 ITRM Transformations folder. For information about the properties of transformations, see Transformations Tree.