Configuring TIBCO Fulfillment Catalog for PostgreSQL

This topic explains the configuration of TIBCO Fulfillment Catalog for use with PostgreSQL 9.6.x version and later.

If you install TIBCO MDM using a standalone installer and if you install PostgreSQL 9.6.x on your system, you must configure TIBCO Fulfillment Catalog for PostgreSQL.

Prerequisites

Before configuring the TIBCO Fulfillment Catalog for PostgreSQL 9.6.x version, the following prerequisites have to be met:
  • Install TIBCO MDM 9.1.0 HF-05, which supports JBOSS, and verify the installation logs to confirm a successful installation. For more details related to TIBCO MDM 9.1.0 HF-05 installation, seeTIBCO® MDM Installation and Configuration Guide and the TIBCO MDM 9.1.0 HF-05 Readme file.
  • Configure JBOSS EAP 7.0. For more details related to configuring JBOSS EAP 7.0, see the topic "TIBCO MDM Installation on Application Servers" within the TIBCO® MDM Installation and Configuration Guide.
  • Install TIBCO Enterprise Message Service 8.4 and create the channels for TIBCO MDM. For more details, see TIBCO® MDM Installation and Configuration Guide.
  • Install PostgreSQL 9.6.x, verify the installation, and ensure that the folder structure conforms to the requirements of TIBCO MDM 9.1.0 database script creation.

Procedure

  1. Run the install.sh file within the $MQ_HOME/db/postgreSQL/install/ location. Enter the necessary details, verify whether the tables and seed data are proper or not.
  2. Edit the ConfigValues.xml file, within the $MQ_HOME/config/ location, and also edit the standalone.xml file within the $JBOSS_HOME/standalone/configuration/ location and specify the database details. In the ConfigValues.xml file search for the group DatabaseServerType and enter the value POSTGRES. You can specify the database details using the Configurator as well.
  3. Start the following servers: EMS, PostgreSQL, and JBOSS EAP.
  4. Login to the TIBCO MDM enterprise using the super admin enterprise name Tibcocim.
    Note: This step is performed only to verify if TIBCO MDM installation was successful.
  5. Stop the JBOSS server.
  6. Install TIBCO Fulfillment Catalog and check the logs to see if the post installation activities were successful.
  7. Ensure that PostgreSQL server is up and running.
  8. Create the TIBCO Fulfillment Catalog seed data in the TIBCO MDM database.
    1. Browse to the $AC_HOME/db/postgreSQL/install.
    2. Run install_ac.sh.
    Note: The install_ac.sh file creates seed data only for the TIBCO Fulfillment Catalog and not for the TIBCO MDM database.
  9. Start/Restart the following servers on: EMS, PostgreSQL, and JBOSS EAP. For more details on TIBCO Fulfillment Catalog Enterprise, see Creating TIBCO Fulfillment Catalog Enterprise with Metadata Manually.