Connecting Cloud Application Business Insights to the cluster

After you set up the PostgreSQL HA cluster, you must configure Cloud Application Business Insights to connect to the remote PostgreSQL HA cluster.

Complete the following steps to configure Cloud Application Business Insights to connect to Patroni cluster node:

1. Replace localhost with IP address of HAProxy server in the following files:
   • Open the prddb_config.sh file from the following location:

     
     cd $install_dir/prddb/custom/
     vi prddb_config.sh

     Where: install_dir is the directory where you installed the application.

     Replace localhost with HAProxy IP address for the following parameter:

     PRD_DB_SVC_HOST=localhost

   • Open the bootstrap.properties file from the following location:

     
     cd $install_dir/wlp/usr/servers/prdapp/
     vi bootstrap.properties

     Replace localhost with HAProxy IP address for the following parameter:

     database.server=localhost

   • Open the prdutil_config.sh file from the following location:

     
     cd $install_dir/prdutil/
     vi prdutil_config.sh

     Replace localhost with HAProxy IP address for the following parameter:

     PRD_DB_SVC_HOST=localhost

   • The following configurations are needed only if Apache NiFi-based connectors are installed:
     • Open the prdconfigdb.properties file from the following location:

       
       cd $install_dir/connector/nifi-1.8.0/conf/
       vi prdconfigdb.properties

       Replace localhost with HAProxy IP address for the following parameter:

       prdconfigdb_host=localhost

     • Open the PRD_Connector_Tenant_Creator.sh file from the following location:

       
       cd $install_dir/connector/scripts/
       vi PRD_Connector_Tenant_Creator.sh

       Replace localhost with HAProxy IP address for the following parameter:

       databaseConnectionUrl="jdbc:postgresql://localhost:5432/prddb"

     • Open the PRD_Connector_Uninstall_DB_Setup.sh file from the following location:

       
       cd $install_dir/connector/scripts/
       vi PRD_Connector_Uninstall_DB_Setup.sh

       Replace localhost with HAProxy IP address for the following parameter:

       databaseConnectionUrl="jdbc:postgresql://localhost:5432/prddb"

2. Restart Cloud Application Business Insights server.

   For more information, see Restarting the Cloud Application Business Insights server.