B Loading Metadata into the Database

The information in this appendix explains how to run the LoadXML and LoadXML_XACM scripts that load metadata into your database. Complete the following steps to run the LoadXML and LoadXML_XACM scripts located in the <PATCH>/Database/Utilities/ directory:

1. As appropriate for your environment (depending on operating system and whether or not you deploy the Audit and Compliance Module), edit either the LoadXML or LoadXML_XACM script and update the JAVA_HOME variable.

2. As appropriate for your environment (depending on your database and operating system), complete the following steps:

   SQL Server:

   1. Launch a plain-text editor, open the file LoadXML.bat, and uncomment the following line:

      REM SET SQL_SERVER_DRIVER_DIR=
      
      

   2. Assign the path to the SQL Server driver directory that contains the msbase.jar, msutil.jar and mssqlserver.jar files:

      SET SQL_SERVER_DRIVER_DIR=<PATH_TO_SQL_DRIVER>
      
      

   Oracle on Windows:

   1. Launch a plain-text editor, open LoadXML.bat, and uncomment the following line:

      REM SET ORACLE_DRIVER_DIR=
      
      

   2. Assign the path to the Oracle driver directory containing the Oracle JDBC drivers:

      SET ORACLE_DRIVER_DIR=<PATH_TO_ORACLE_DRIVER>
      
      

   Oracle on UNIX and Linux:

   1. Launch a plain-text editor, open LoadXML.sh, then uncomment the following lines:

      #ORACLE_DRIVER_DIR=#export ORACLE_DRIVER_DIR
      
      

   2. Assign the path to the JDBC driver for Oracle, so that the line reads something like the following:

      ORACLE_DRIVER_DIR=<PATH_TO_ORACLE_DRIVER>export ORACLE_DRIVER_DIR
      
      

3. Open a command prompt or console and run the appropriate LoadXML or LoadXML_XACM script in the <PATCH>/Database/Utilities/ directory. Use the LoadXML script if you do not deploy the Audit and Compliance Module, and use the LoadXML_XACM script if you deploy the Audit and Compliance Module.

   Execute the script using the following parameters (in the following order) for the type of database you are using:

   Oracle:

   1. JDBC URL (for example: jdbc:oracle:thin:@<db_host_ip>:<port>:<SID>)

   2. Database user name

   3. Password

   SQL Server:

   1. JDBC URL (for example: jdbc:microsoft:sqlserver://<ipaddress>:<port>)

   2. Database name

   3. Database user name

   4. Password