Database Guide › Database Storage and Partitioning › Run the DDL Scripts › Run the Oracle Scripts: Data Warehouse

Run the Oracle Scripts: Data Warehouse

This procedure installs the data warehouse tables. There is a separate procedure for installing main database tables for the CMS.

Run the Oracle scripts from the SQL*Plus utility.

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 'main tables' script, native_wrapper.sql.

Install the data warehouse tables

1. Create the tablespaces required by the scripts. The default tablespaces are:
   • WGNDWTSS: Holds the staging area tables.
   • WGNDWTSF: Holds the large data warehouse fact tables.
   • WGNDWTSD: Holds the data warehouse dimension tables.

   If you want to use your own tablespace names, edit Native_DWWrapper.sql and replace the default tablespace names with your new ones.

2. Verify the schema owner and primary user accounts have access to and sufficient quota on the tablespaces created in step 1.
3. 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.

4. Copy the modified script files to a location where SQL*Plus can access them.
5. Browse to the folder containing the script files and open Native_DWWrapper.sql.
6. 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.

7. From the SQL*Plus prompt, type:

   start native_dwwrapper
   

   This creates the tables and indexes and populates the tables with basic data.

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

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

10. You now need to grant the primary user access to the tables you created in step 7, 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 6 for command details.
    4. To create the Oracle synonyms against the primary user, type this command:

       start dwsynonyms
       

    This completes the native script installation for the data warehouse.

11. If you have not yet installed the CMS, run the CMS installation wizard now before you contine to step 12.

    Note: The CMS installation wizard allows you to install the CMS and data warehouse at the same time.

12. Install the data warehouse.

    See the Platform Deployment Guide for details.