The Extract311DataMart
and DeployDataMartTo33 tools are distributed in a JAR file called
Extract311Deploy33.jar. This JAR file can be found in the
deploy
subdirectory
of your installed IT Resource Management client. (The default location
of this JAR file is
C:\Program Files\SASHome\SASITResourceManagementClient\3.3\deploy
.)
Note: When running these tools,
you must use a SAS Administrator user account (typically sasadm@saspw).
This user account has privileges that are associated with the Metadata
Server: Unrestricted role. In addition, the SAS Administrator account
is initially a member of the SAS Administrators group. For more information
about this account, see
“Overview
of System Administration User Roles” in
the
SAS 9.3 Intelligence Platform: System Administration
Guide.
Before using the extract
and deploy tools, be sure to apply any hot fixes that are available
for this version of SAS IT Resource Management. Hot fixes for SAS
IT Resource Management 3.3 and later are accessible here:
http://ftp.sas.com/techsup/download/hotfix/HF2/H33.html
.
-
Move the Extract311Deploy33.jar
file to the SAS IT Resource Management 3.1.1 Windows system where
your client software is installed. This Windows system will have SAS
Management Console, which is part of your source SAS system. (This
system does not need to have SAS Foundation installed on it.)
Note: If you installed SAS Management
Console 9.1 in a location other than the default location, you need
to set an SMCCLIENT environment variable. That variable should point
to the non-default location before you run the Extract311ITDataMart.bat
script. To do so, open a DOS prompt window and issue a
set
smcclient =drive:alternate-directory
command.
Here is an example of that command for the SAS 9.1 system:
set smcclient=D:\Program Files\SAS\SAS Management Console\9.1
-
In a DOS prompt window,
make sure that the
..\bin
directory of a Java JDK is in your PATH environment
variable. For example:
set path=C:\j2sdk1.4.2_09\bin;%PATH%
Then
use the
jar –xf [jarname]
command
to unzip the Extract311Deploy33.jar file and place it in a new directory
tree. The following example creates a new directory called
Extract
,
sets the current working directory to
Extract
,
and unzips the JAR file into that directory.
mkdir c:\Extract
cd c:\Extract
jar –xf Extract311Deploy33.jar
The
jar
–xf [jarname]
command
creates a directory tree that is extracted from the JAR, which is
located in the current working directory.
-
Change the current working
directory to the
..\Extract311Deploy33\Utilities\metadata
folder of the directory you just extracted. This
directory contains a batch file, Extract311DataMart.bat, that you
can invoke to extract the metadata of the IT data mart that you want
to migrate.
-
Run the Extract311DataMart.bat
program.
Note: Before running this Windows
batch file, the JAVA_HOME environment variable should be set to the
correct Java Virtual Machine (JVM) using the correct version of Java.
The supported Java versions for SAS client applications are documented
at
Third-Party Software Reference. See
the section for SAS client applications under the appropriate Service
Pack for your SAS 9.1.3 environment.
Specify the following
positional parameters for the Extract311DataMart.bat program:
-
the name of the IT data mart that
you are migrating. This name is also used to identify the migrated
IT data mart on the SAS IT Resource Management 3.3 system. If the
name of the IT data mart contains spaces, enclose it in double quotation
marks.
Note: If an IT data mart with this
name already exists on the target SAS IT Resource Management 3.3 system,
the migrated IT data mart is renamed in order to avoid duplication.
-
the name of the metadata server
where the SAS IT Resource Management 3.1.1 system is located.
-
the port that is associated with
the specified metadata server.
-
the user ID that connects you to
the specified metadata server.
Note: The user ID should be authorized
to create new top-level folders in the ITMS repository. Use an administrative
user ID if necessary.
-
the password that is associated
with the specified user ID.
Here is an example.
Extract311DataMart “SampleDataMart”
your311server.domain.com
8561
youruserID
yourpassword
This extract program
produces the metadata about the IT data mart that you want to migrate
(in XML form). It then writes the extracted files to the directory
tree on the SAS IT Resource Management 3.1.1 system.
The messages written
by the Extract311DataMart batch file can be captured in the usual
Windows method, by redirecting output. Here is an example.
Extract311DataMart “SampleDataMart”
your311server.domain.com
8561
youruserID
yourpassword
> extract.log
Note: Warning messages that start
with either of the following texts can be ignored:
-
No objects of type Tree were found using the search criteria.
-
No objects were retrieved from the server during expansion.
-
On your SAS IT Resource
Management 3.3 system, create a metadata repository named
ITMS.
To create the repository,
perform the following steps:
-
Invoke SAS Management
Console 9.3 and log on using an administrative user account.
-
On the
Plug-ins tab,
expand
Environment Manager. In the Metadata
Manager section, select
Active Server.
-
On the
Actions menu,
select
New Repository. The
New
Repository wizard appears.
-
Specify the name of the new repository
as ITMS.
-
Specify a path. (For example, the
path could be
MetadataRepositories\ITMS
).
Note: You can also specify authorization
details for the new repository at this time. Alternatively, you can
change the authorization details later. The user account which will
be used for subsequent steps should have Write authority to this repository.
-
Move the entire directory
tree that was created in step 2 from your SAS 9.1.3 system to your
SAS IT Resource Management 3.3 client machine.
The directory contains
a batch file, DeployDataMartTo33.bat, that you can invoke to deploy
the migrated IT data mart onto your SAS IT Resource Management 3.3
system.
-
On your SAS IT Resource
Management 3.3 system, change the current working directory to the
../Utilities/metadata
folder
of the directory you just moved.
-
If you installed the
SAS IT Resource Management 3.3 client in a location other than the
default location, you need to set an ITRMCLIENTTIER environment variable.
That variable should point to the non-default location before you
run the DeployDataMartTo33.bat script. In the DOS prompt window,
issue the
set itrmclienttier =drive: alternate-directory
command.
Here is an example of that command:
set itrmclienttier= D:\Program Files\SASHome
\SASITResourceManagementClient\3.3
If you installed the
SAS Versioned Jar Repository into a non-default location, you need
to set a VJRPATH environment variable to point to the non-default
location before you run the DeployDataMartTo33.bat script. In the
DOS prompt window, issue the
vjrpath =drive: alternate-directory
command.
Here is an example of that command:
set vjrpath = D:\Program Files\SASHome\SASVersionedJarRepository\
If you installed the
SAS Platform Object Framework into a non-default location, or if you
want to use an alternate SAS Java external configuration file, you
need to set an EXTCONFIG environment variable to point to the non-default
location before you run the DeployDataMartTo33.bat script. (This
environment variable should point to a file location rather than a
directory location.) In the DOS prompt window, issue the
set
extconfig =drive:alternate-directory
filename
command. Here is an example
of that command:
set extconfig = D:\Program Files\SASHome\sas.java.ext.config
-
Run the DeployDataMartTo33.bat
program.
Note: Before running this Windows
batch file, the JAVA_HOME environment variable should be set to the
correct Java Virtual Machine (JVM) using the correct version of Java.
The supported Java versions for SAS client applications are documented
at
Third-Party Software Reference. See
the section for Java Runtime Environments under the appropriate maintenance
release for your SAS 9.3 environment.
Specify the following
positional parameters for the DeployDataMartTo33.bat program:
-
the name of the metadata server
where the SAS IT Resource Management 3.3 system is located
-
the port that is associated with
the specified metadata server
-
your user ID that connects you
to the specified metadata server
-
the password that is associated
with the specified user ID
Here is an example.
DeployDataMartTo33 your33server.domain.com
8561
youruserID
yourpassword
The IT data mart from
the SAS IT Resource Management 3.1.1 system is now available on your
SAS IT Resource Management 3.3 system.
The messages written
by the DeployDataMartTo33 batch file can be captured in the usual
Windows method, by redirecting output. Here is an example.
DeployDataMartTo33
your33server.domain.com
8561
youruserID
yourpassword
> deploy.log
Note: If you run the DeployDataMartTo33
tool for the same 3.11 IT Data Mart twice, or if another IT data
mart already exists with the same name, rename one of them. If one
of these IT data marts is not needed anymore, you can delete it. To
delete or rename an IT data mart, on the
IT Data Marts tree
of SAS IT Resource Management, right-click the IT data mart. For more
information about deleting or renaming an IT data mart, see “Working
with IT Data Marts” in Chapter 4, “Data Marts,”
in the
SAS IT Resource Management: Administrator’s
Guide.
-
This step is recommended,
although it is optional. Perform this step to ensure that existing
SAS IT Resource Management 3.1.1 physical data libraries are not overwritten
when the physical data is unpackaged on the SAS IT Resource Management
3.3 system.
Note: This step is required if
you are migrating between releases of the SAS System (for example,
from SAS 9.2 to SAS 9.3).
-
The Extract311DataMart
and DeployDataMartTo33 tools migrate only the metadata that is associated
with an IT data mart. To migrate the data from the SAS IT Resource
Management 3.1.1 IT data mart to the SAS IT Resource Management 3.3
IT data mart, use the package (%RMDMPKG) and unpackage (%RMDMUPKG)
macros.
Note: Skip this step if you meet
both of the following conditions:
-
You did not rename the pathnames
and data sets, as recommended in the previous step.
-
The existing pathnames point to
locations that already contain the correct physical contents of the
IT data mart that you are working with.
Note: In the specification of the
%RMDMUPKG macro, make sure that the SMU= parameter is set to
NO
.
This setting indicates that the SAS Migration Utility was not used
to migrate the metadata associated with this IT data.
-
The same folder structure
of the original IT data mart is carried over to the SAS IT Resource
Management 3.3 system. The following display shows the folder structure
of an IT data mart on a SAS IT Resource Management 3.1.1 system.
Structure of a SAS IT Resource Management 3.1.1 IT Data Mart
The following display
shows the folder structure of a SAS IT Resource Management 3.3 IT
data mart, after the Extract311DataMart and DeployDataMartTo33 tools
have been successfully run.
Structure of a SAS IT Resource Management 3.3 IT Data Mart
-
Redeploy all the jobs
that were migrated.