Setting up the Oracle database server

Prepare your Oracle database server and then run the AX Server SQL scripts. You must complete the Oracle setup prior to installing Analytics Exchange.

Prepare the database

Setup an Oracle database instance for AX Server and if required, configure the database server to allow encrypted connections between the database server and AX Server.

Run the tablespace and user SQL scripts

The database administrator must run the following scripts prior to installing AX Server:

• CREATE_AX_TABLESPACE.sql: defines the physical allocation of space for the Analytics Exchange database

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

• CREATE_DATABASE_USER.sql: creates the Analytics Exchange database user

The following variables must be set for CREATE_DATABASE_USER.sql:

• V_USER
• V_USERPWD

For more information, see Running Oracle database scripts.

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.

Run the create database schema SQL scripts

Run the additional SQL scripts provided to create the AX Server database schema rather than relying on the AX Server setup wizard to create the schema:

• Create Schema.sql
• CreateQuartzTables.sql
• Create Core Data.sql

For more information, see Running Oracle database scripts.