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. EMS and database Hotfix scripts are never cumulative. You have to run the upgrade scripts for every Hotfix.
TIBCO Order Management supports the PostgreSQL and Oracle databases. Depending on the database you use, choose the following tasks.
-
PostgreSQL database
- Creating a PostgreSQL Database for the Admin User
- Creating a PostgreSQL Database for Catalog User
- Creating a PostgreSQL database for Order User
- Creating a PostgreSQL Database for the Archival Service User
- Creating a PostgreSQL Database for Jeopardy Service User
- Creating a PostgreSQL User Database
- Creating a PostgreSQL Database for the Broker Service User
-
Oracle database
- Creating an Oracle Database for the Admin User
- Creating an Oracle Database for Catalog User
- Creating an Oracle Database for Order User
- Creating an Oracle Database for the Archival Service User
- Creating an Oracle Database for Jeopardy Service User
- Creating an Oracle User Database
- Creating an Oracle Database for the Broker Service User
Note: Only when the identityProviderType=postgres/oracle, the Oracle user database or PostgreSQL user database are needed.
Subtopics