This page provides additional configuration aspects for the actual Informatica BPM application. As Informatica BPM is a stand alone product we refer to it's own installation and operation manuals. This page just summarizes some how tos which we found useful.

How to create and configure a workflow which interacts with Product 360 is described in the Knowledge Base: Business Process Management

How to configure a secure database connection for Product 360 BPM

In order to establish a secure database connection, ensure, that the DBMS's (Oracle/MSSQL) public key certificate is known by the BPM server's Java Runtime Environment (JRE). There are different possibilities to achieve this. Please refer to the JSSE Reference Guide (https://docs.oracle.com/javase/8/docs/technotes/guides/security/jsse/JSSERefGuide.html) and here especially the chapters "Creating an X509TrustManager" and "Creating a Keystore to Use with JSSE".

Configure Product 360 BPM

Ensure to do the following configuration changes on all Product 360 BPM servers. The Product 360 BPM servers need to be restarted in order to have changes take effect.

in <INSTALLATION_ROOT>/server/server-enterprise/tomcat_config/bin/install.properties:
- for Oracle:
  - change the jdbc.database.url property to the following: jdbc\:oracle\:thin\://@(DESCRIPTION\=(ADDRESS\=(PROTOCOL\=tcps)(HOST\=<YOUR_DATABASE_HOST>)(PORT\=<DB_SSL_PORT>))(CONNECT_DATA\=(SERVICE_NAME\=<DATABASE_NAME>)))
- for MSSQL:
  - add ";encrypt=true" to the end of the JDBC connection URL in the jdbc.database.url property .
run the config_deploy.sh file in the same directory as follows: sudo ./config_deploy.sh console
restart the BPM service