Setting Up Database Tables

Regardless of which database you want to use as the JDBC-based SmartMapper service, you need to set up some basic tables by running database scripts.

See the readme file for supported versions of each database.

Note: If two ER Models are assigned to the same database, they need to be assigned through different users to avoid the conflict between tables.

Procedure

  1. Select a user name and password to create a database account for a user. This account can also be created by your database administrator.
    If you use Oracle database, you need to have the following privileges to run scripts:
    • CREATE SESSION
    • CREATE ANY TABLE
    • CREATE SEQUENCE
    • UNLIMITED TABLESPACES
  2. Run the database script according to the database that you want to use. The scripts are located in the TIBCO_HOME\bw\palettes\smartmapper\7.1\sql directory.
    See TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper User’s Guide for more details regarding using JDBC-Based Database Service.