Creating Seed Data for TIBCO Product and Service Catalog in PostgreSQL Database

SQL scripts are used for adding TIBCO Product and Service Catalog specific seed data into the database. TIBCO Product and Service 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 Product and Service 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.