Use SQL scripts to create a dedicated schema if you are using a database as your persistence layer.
The script that creates the database schema is named repository_<DatabaseName>.sql. SQL scripts can be found in this directory <InstallDir>/executionserver/databases
If you want to use Decision Warehouse, you can also create the required database table by running the script trace_<DatabaseName>.sql. If you are also persisting the Java™ XOM in a database, you must create these tables by running the xomrepository_<DatabaseName>.sql script.
If you use Command Editor to run the scripts, you must log in with the credentials you use for the data source for Rule Execution Server.
Use any tool that can handle SQL to import and run the SQL scripts. The tools provided for each database include:
| Database | Database tool |
|---|---|
| IBM® DB2® | DB2 command line processor |
| Derby | ij command line processor |
| MySQL | mysql command line processor |
| Oracle | sqlplus command line processor |
| Postgre QL | Postgre SQL command line tool |
| SQL Server | Query Tool |
| Sybase | isql command line processor |
To access the database, the database user must have a user ID and a password. The database user must also have:
complete privileges on the tables and view of the schema (create, insert, delete)
create index privileges
On Oracle, the database user must also have create trigger and create sequence privileges.
When using an Oracle database, run all the scripts in the SQL Plus client.
Install a database client for the database that you use. Refer to the documentation of the database you are using for more information.