Configuring Fulfillment Catalog for PostgreSQL
In this topic we show you how to configure 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 have to configure Fulfillment Catalog for PostgreSQL.
Prerequisites
- Install TIBCO MDM 9.1.0 HF-02, which supports JBOSS, and verify the installation logs to confirm a successful installation. For more details related to TIBCO MDM 9.1.0 HF-02 installation, refer the TIBCO® MDM Installation and Configuration Guide and the TIBCO MDM 9.1.0 HF-02 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 EMS 8.3 and create the channels for MDM. For more details, see the 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 MDM 9.1.0 database script creation.
Procedure
- 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.
- 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.
- Turn up the following servers: EMS, POSTGRES, and JBOSS EAP.
- Login to the MDM enterprise using the enterprise name Tibcocim.
- Stop the JBOSS server.
- Install Fulfillment Catalog and check the logs to see if the post installation activities were successful.
- 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.
- Turn the following servers on: EMS, POSTGRES, and JBOSS EAP.
- For the creation of Fulfillment Catalog Enterprise, refere to the Creating Fulfillment Catalog Enterprise with Metadata Manually section.
Copyright © Cloud Software Group, Inc. All rights reserved.