SAS IT Resource Management
3.3 data models are designed to be consistent across adapters and
to perform efficiently as input to the reports supplied by the solution.
The Data Model Upgrade program is part of the SAS IT Resource Management
migration. It copies the physical data in the IT data mart that has
been migrated to SAS 9.3 to an IT data mart with a SAS IT Resource
Management 3.3 data model. At the same time, for those adapters that
are supported by the solution, it upgrades the physical data to the
SAS IT Resource Management 3.3 data model. Upgrading the data model
enables you to use your existing data with the new reports that are
provided with SAS IT Resource Management 3.2 and later.
The program compares
the metadata for the tables in a new SAS IT Resource Management 3.3
IT data mart (that was created using the
Adapter Setup wizard)
with the metadata for the tables in the migrated IT data mart (that
was migrated from a SAS IT Resource Management 3.1.1, 3.2, or 3.21
IT data mart or a SAS IT Resource Management 2.6 or 2.7 PDB). It then
produces a report that shows all the changes between the two IT data
marts. Based on the information in the report, you can modify the
new IT data mart as needed. For example, if there are columns in the
migrated IT data mart that you want to be copied to your new IT data
mart, you can add those columns to the tables. After you are satisfied
with the changes that are indicated on the report, you can run the
program again. This time, you can set the
DOREPORT and
DOUPGRADE parameters
so that the program copies and upgrades the aggregation data from
the migrated IT data mart to your new IT data mart.