Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Backing Store Tutorial : Backing Store Setup — Overview

Backing Store Setup — Overview
This tutorial guides you through the basic steps required to set up a backing store for the Fraud Detection Cache project. Chapter 30, JDBC Backing Store Setup in TIBCO BusinessEvents Developer’s Guide covers more cases. The tutorial organizes the steps to create a convenient flow, as follows
First, Prerequisites: DBMS Product Setup
The tutorial explains the prerequisites in general. Refer to the TIBCO BusinessEvents readme for DBMS product requirements.
Task A, Ensure DBMS Software and Driver are in Place and Edit the TRA.
Then, TIBCO BusinessEvents Project Configuration
Some TIBCO BusinessEvents Studio project configuration can be done before or after database schema setup. If ontology-related configuration is required, however, it must be completed before running the database setup scripts.
Ontology-related configuration may be required for special cases that you won’t deal with in this example project. (See the section Cases That May Need Additional Setup in TIBCO BusinessEvents Developer’s Guide for more details.) Ontology-related configuration is also required if you want to exclude any entity types from the backing store (or to include types that were earlier excluded). Cache preloading settings are not related to backing store setup, and can be configured and changed at any time.
Task B, Rename the Fraud Detection Cache Project and Change Port
Task C, Add a JDBC Connection Shared Resource
Task D, Rename and Configure the CDD, then Build the EAR
Finally, Database Schema Setup
Schema setup is facilitated by the scripts provided with the product. The tutorial uses default values throughout. The scripts can also be used to reset the project.
Task E, Run the Initialize Database Script as the DBA or System User
Task F, Run the Create Tables Scripts as the TIBCO BusinessEvents User
Task G, Generate the Project-Specific SQL Scripts
Task H, Run the Table Creation Script

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved