Generating the Project-Specific SQL Scripts

Ensure that you have generated the project EAR file before beginning.

Procedure
1. In TIBCO BusinessEvents Studio Explorer, right-click the FraudDetectionStore project name and select Export > TIBCO BusinessEvents > Backingstore Deployment.
2. Click Next.
   You will see the Deploy wizard.
3. In the Backingstore Type field, select Relational Database (JDBC) and click Next.
4. Complete the values as follows.
   1. In the Database Type field, select your database type. The default is oracle.
   2. In the Cluster Deployment Descriptor field, browse to and select the fdstore CDD.
   3. In the Output Directory field, browse to and select the directory where the scripts will be generated. The tutorial project uses BE_HOME/bin.
   4. In the Output Script Name Prefix field, type fdstore.
5. Click Finish.
   The generated scripts appear in the directory you specified. If you are following the tutorial instructions, the following files appear in the BE_HOME/bin directory:

      fdstore.sql
      fdstore_cleanup.sql
      fdstore_delete.sql
      fdstore_alter.sql
      fdstore_remove.sql
      fdstore.aliases

   The use of these scripts is explained in "Resources Required for JDBC Backing Store Implementation" in TIBCO BusinessEvents Developer’s Guide.