Configuring Fulfillment Catalog for PostgreSQL

In this topic we show you how to configure Fulfillment Catalog for use with PostgreSQL 9.5.x version and later.

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

Prerequisites

Before configuring the Fulfillment Catalog for PostgreSQL 9.5.x version, the following prerequisites have to be met:
  • Install TIBCO MDM 9.0.1 HF-02, which supports JBOSS, and verify the installation logs to confirm a successful installation. For more details related to TIBCO MDM 9.0.1 HF-02 installation, refer the TIBCO® MDM Installation and Configuration Guide and the TIBCO MDM 9.0.1 HF-02 Readme file.
  • Configure JBOSS EAP 6.4. For more details related to configuring JBOSS EAP 6.4, see the topic "TIBCO MDM Installation on Application Servers" within the TIBCO® MDM Installation and Configuration Guide.
  • Install TIBCO EMS 8.0 and create the channels for MDM. For more details, see the TIBCO® MDM Installation and Configuration Guide.
  • Install PostgreSQL 9.5.x, verify the installation, and ensure that the folder structure conforms to the requirements of MDM 9.0.1 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 Config_Values.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 Config_Values.xml file search for the group DatabaseServerType and enter the value POSTGRES. You can specify the database details using the Configurator as well.
  3. Turn up the following servers: EMS, POSTGRES, and JBOSS EAP.
  4. Note: This step is performed only to verify if MDM installation was successful.
    Login to the MDM enterprise using the enterprise name Tibcocim.
  5. Stop the JBOSS server.
  6. Install Fulfillment Catalog and check the logs to see if the post installation activities were successful.
  7. Note: Before performing this step, ensure that PostgreSQL server is up and running.
    Since PostgreSQL was already installed on the system, create the Fulfillment Catalog seed data in the MDM database. Browse to the $AC_HOME/db/postgreSQL/install location and run the install_ac.sh file. The install_ac.sh file creates seed data only for the Fulfillment Catalog and not for MDM.
  8. Turn the following servers on: EMS, POSTGRES, and JBOSS EAP.