Database Guidelines

TIBCO MFT Internet Server provides a utility that will create and populate the required database tables. However, before running the installation, you must create a TIBCO MFT Internet Server database in whichever database application you have chosen to use. We suggest creating DB Tables using a UTF-8 character set and a case insensitive collation. For Oracle you may need to create a logon trigger to make searches case insensitive. When you run PostgreSQL, the CITEXT extension must be installed. MFT uses the POSTGRES CITEXT data type to provide case insensitive searches. In addition, for case insensitive searches to work, you should use the PostgreSQL JDBC driver at level 42-2.12 or at a later level.

A PostgreSQL superuser must run the following command to add the extension to the database that MFT uses:

CREATE EXTENSION IF NOT EXISTS citext;

Note: MFT installer executes this SQL statement when creating the database tables. Only a superuser can add this extension. If you do not want to grant superuser rights to the MFT database user, you should execute this SQL statement after the database is created and before the MFT installation starts.

TIBCO MFT Internet Server supports the following databases:

  • MS SQL Server
  • Oracle
  • MySQL
  • IBM DB2
  • PostgreSQL

Have your database administrator create a database as well as a user name and password on the server that will host the TIBCO MFT Internet Server database tables.

It is recommended that the database and user name be named cfcc, but this is not required. This user name must have the ability to read, write, and create tables in the TIBCO MFT Internet Server database. The exact steps to accomplish this step vary significantly depending on the database application you are using; consult the documentation provided by your database vendor on how to perform this step.

Follow the guidelines when creating the database:
  • Database password must not contain an equal sign (=).
  • MS SQL Server properties can be configured in the Security tab to do authentication via SQL Server or Windows. The default is Windows only.
  • If you are using an IBM DB2 database, see Creating an IBM DB2 Database.
  • If you are using an Oracle 10i or later, using Cost Based Optimization (CBO), it is strongly recommended that the optimization is tuned for first_rows for the TIBCO MFT Internet Server database. To enable this, the following command should be issued from SQL*Plus as SYSDBA, after creating the database:

    alter system set optimizer_mode=first_rows_100;

Note: The database user account used for the TIBCO MFT Internet Server installation must not have the DBA role assigned because this will cause the installation to fail. The database user needs only the following right granted:

GRANT CONNECT, RESOURCE TO <schema>

Warning: TIBCO strongly suggests not to create database triggers on tables in the MFT Database. Creating database triggers can cause unintended consequences and can impede the support process. If you need to create a trigger, you must notify TIBCO Support.