Running Oracle database scripts

Before you run the AX Server setup wizard to install the application, run the supplied SQL script to create the AX Server database user. You can also run the set of SQL scripts that create the database schema manually if you do not want to complete this step using the setup wizard.

Download the installers

1. Sign in to Launchpad (www.accounts.highbond.com) and click Analytics Exchange.

   An email with sign in instructions is sent from notifications@highbond.com to your company's ACL account administrator. If you are unable to sign in to your Launchpad account, contact your company’s ACL account administrator or ACL Support Services for assistance.

2. From the Select software package to download list, select the installer you want to download.

   Note

   Ensure that you download the correct edition (non-Unicode or Unicode) as all installed applications must use the same edition.

3. Click Download <Version> and save the installer to the computer that you plan to install the application on.

Run the database scripts

1. Open Windows Explorer and navigate to the DBScripts\Oracle subfolder where you extracted the setup wizard files.
2. Copy the SQL script files to the Oracle server, or a location you can run the scripts from.
3. Run the CREATE_AX_TABLESPACES.sql script to define the physical allocation of space for the database.
4. Open Create Database User.sql and update the V_USER and V_USERPWD variables defined at the top of the script, with the username and password you want to use for the AX Server database user. Save and close the file when you have made the necessary changes.
5. Run the Create Database User.sql script using a database administrator account running under the SYSDBA role.
6. To create the database schema manually run the following SQL scripts using the AX Server database user account:

   Create Schema.sql

   CreateQuartzTables.sql

   Create Core Data.sql

   If you run the AX Server schema scripts manually, and someone else will run the AX Server setup wizard, you must instruct them to choose the Use an existing ACL Analytics Exchange database option in the AX Server database connection settings page.

7. If you are installing AX Exception as part of your ACL GRC Analytics Exchange configuration, you also need to run an additional SQL script to add the required AX Exception roles to the database. You must select the file that corresponds to the language you are installing. For example, if you are completing the English installation, run the SQL script file named EMRole_EN.sql.

[ Back to top ]