Database Schema
Use provided scripts to set up the database schema.
Tip: See
Resetting the Backing Store Tutorial for various levels of reset you can do if you want to reuse this tutorial example.
- What happens if I change the project ontology after setting up the database schema?
- If you change the project ontology you must update the database schema. You must also update the schema if you add an entity that you previously excluded from the backing store.
- What are the minimum permissions for the database user?
- At a minimum, the user must be able to create tables and views. By default the BE_USER user created by the scripts has DBA privileges.
- Running the Initialize Database Script as the DBA or System User
This script creates the TIBCO BusinessEvents user and initializes the database. - Running the Create Tables Scripts as the TIBCO BusinessEvents User
Next you log on as the TIBCO BusinessEvents user, BE_USER by default, and run a script to create non-project specific tables. - Generating the Project-Specific SQL Scripts
Ensure that you have generated the project EAR file before beginning. - Running the Table Creation Script
Now you can run the table creation script.
Copyright © TIBCO Software Inc. All rights reserved.