Configuring External Databases

The in-process HSQLDB database must only be used in trial setups where data loss is acceptable. If not, you must use an external database with your ActiveMatrix enterprise.

Prerequisite: If you are using an external database, you have to perform database-specific configuration before you can create runtime objects such as the Administrator server.

Set up your database, depending on the database vendor. The database schema can either be created automatically or manually. The DDL Script Generator utility generates the database scripts that can be executed manually. The database permissions needed will vary accordingly.

To create an ActiveMatrix Administrator server, you must provide database information including a database username. This database user account needs the right privileges for proper operation.

Permissions Needed to Create the Database Schema
Creation of The Database Schema Database Privileges Needed
Automatically
  1. Grant DDL privileges, such as permissions to access create tables, indexes, constraints, and so on to the database user account.
  2. Grant DML privileges, such as permissions to select, insert, update, delete records in the tables, or query for table meta-data.

The permissions are specific to the database type and are listed under Database Permissions Needed for Automatic Schema Creation.

Manually Grant DML privileges, such as permissions to select, insert, update, delete records in the tables, or query for table meta-data. The permissions are specific to the database type and are listed under Database Privileges Needed for Manual Schema Creation.