Creating Tables on the Database Server

If you want to use the SAP TIDManager shared resource in active mode, you have to create tables on the database server.

In the TIBCO_HOME\bw\palettes\sap\version_number\tools directory, you can find the following SQL scripts used to create tables for each supported database:
  • initSqlForOracle.sql
  • initSqlForSqlServer.sql

For the supported databases, see the Readme file.

Note: The Oracle database enabled as a Container Database is not supported.

Copy the corresponding script to your database server according to the database type, and then run the script to create a table to store the TID information.

The plug-in also provides two template scripts, initSqlForOracle.sql_template and initSqlForSqlServer.sql_template, as the original copies of the preceding scripts.