Upgrade Guide › Upgrading Databases › Upgrading the Data Warehouse › Run a Native Script to Upgrade the Data Warehouse

Run a Native Script to Upgrade the Data Warehouse

(Oracle data warehouses only)

This procedure upgrades the data warehouse tables. There is a separate procedure for upgrading the main CMS database tables using native scripts.

Note: You do not need to create a separate database schema owner and primary user account. The data warehouse uses the same accounts that you created when running the native script for the main CMS database tables, native_wrapper.sql.

Upgrade the data warehouse tables

1. Verify that you have modified the DWGrant_user.sql script to reference the primary user.

   (Optional) Verify that you have modified the DWSynonyms.sql script to reference the schema owner.

   For details, see Modify the Grant_User and Synonyms Scripts.

2. Copy the modified script files to a location where SQL*Plus can access them.
3. Browse to the folder containing the script files and open Native_DWWrapper.sql.
4. Start SQL*Plus, and connect to the database as the user who will own the CA DataMinder schema tables. That is, you must connect as the:
   • Schema owner if you have created a separate schema owner, or

     Primary user if you have not created a separate schema owner.

5. From the SQL*Plus prompt, type:

   start native_dwwrapper
   

   This upgrades the tables and indexes, and populates the tables with basic data.

6. Review the native-dwwrapper.log file to confirm that the script executed correctly.
7. If you have created separate Primary User and Schema Owner accounts, go to step 8.

   If you do not have separate accounts (that is, the primary user also owns the CA DataMinder schema tables), this completes the script installation.

8. You now need to grant the primary user access to the tables you created in step 5, and create synonyms for this user.
   1. Verify that you are connected to the database as the schema owner.
   2. In SQL*Plus, type this command:

      start DWGrant_user
      

   3. Still in SQL*Plus, reconnect to the database as the primary user. See step 4 for command details.
   4. To create the Oracle synonyms against the primary user, type this command:

      start dwsynonyms
      

   This completes the native script upgrade for the data warehouse.

9. If you have not yet upgraded the CMS, run setup.exe to upgrade the CMS and the date warehouse together.

   If you have already upgraded the CMS, run setup.exe to upgrade the date warehouse only.