Creating Seed Data for TIBCO Fulfillment Catalog in PostgreSQL Database

SQL scripts are used for adding TIBCO Fulfillment Catalog specific seed data into the database. TIBCO Fulfillment Catalog provides a utility for this task. The installer executes this utility automatically if the database is PostgreSQL as a part of the TIBCO MDM installation (one-click installer).

The procedure to create seed data must be performed only if the PostgreSQL database resides outside $MQ_HOME.

Perform the following steps to create seed data for TIBCO Fulfillment Catalog in PostgreSQL database:

Procedure

  1. Navigate to the location $AC_HOME/db/postgreSQL/install.
  2. Run install_ac.bat/install_ac.sh file based on the platform (Windows or Linux).
  3. Provide the inputs like PostgreSQL installation directory path, database name, host, port, username, and password.
    Important: Check the logs for database script execution at $AC_HOME/db/postgreSQL/install/logs.