Post-Installation Task 2: Creating the Database

If this is your first time installing TIBCO Order Management, then create the database by running the provided scripts.

Note: To run the SQL scripts, you must have appropriate permission.

TIBCO Order Management has the following two types of database:

Admin database: for the admin database, you can either use Oracle or PostgreSQL. See the following topics for more information on how to create an admin user in the Oracle and PostgreSQL database.
- Creating a PostgreSQL Database for the Admin User
- Creating an Oracle Database for the Admin User
In-memory database: for in-memory database, you can use Redis or Oracle/PostgreSQL (relational DB).
You have the option to maintain separate in-memory database for Catalog (such as Models and PlanFragments) and Order data. You can choose any combination of supported in-memory database type or you can also choose one database for both Catalog and Order data.

For Redis as a store, no separate in-memory database creation is required.
For Oracle and PostgreSQL, follow the below procedures to create in-memory database.