Running the Oracle database scripts

Before you run the AX Server setup wizard to install the application, run the supplied Oracle database scripts to create:

  • the tablespace
  • the AX Server database user
  • the database schema

Note

The scripts to create the tablespace and the database user must be run manually on the Oracle database server before you run the AX Server setup wizard.

It is strongly recommended that you also manually run the set of scripts that create the database schema before running the setup wizard. The setup wizard can run the database schema scripts automatically, but creation of the schema is not always successful.

Download the installers

Note

The installer download page provides the latest version of Analytics Exchange. If you require an installer for a previous version, you must contact Support for a copy of the installer for that version.

  1. Sign in to Launchpad (www.highbond.com).

    Your company's System Admin should have already received sign-in information from notifications@highbond.com. If you are unable to sign in to your Launchpad account, contact your company’s System Admin or Support for assistance.

  2. Under Resources, click Downloads.
  3. In the top menu, click Analytics Exchange.
  4. 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.

  5. Click Download Version <version_number> and save the installer to the computer where you will install the application.

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.

    Note

    If you are hosting your database on Amazon RDS, do not run this script. Instead, see Hosting Oracle on Amazon RDS.

  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

    Note

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

  7. If you are installing AX Exception as part of your 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.

Hosting Oracle on Amazon RDS

If you are hosting an Oracle instance on Amazon RDS, instead of running CREATE_AX_TABLESPACES.sql, use the following commands:

create tablespace AX_DATA datafile size 1G autoextend on maxsize 10G;
create tablespace AX_INDEX datafile size 1G autoextend on maxsize 10G;
create temporary tablespace AX_TEMPORARY

Have your Database Administrator adjust the tablespace sizes as required for your installation.