Adjusting the webserver to support non SSL port

The Informatica BPM web endpoint does enforce SSL by default. To disable that behavior it is possible to set a JVM property:

Configuration during installation

In this case it's better to use the silent installation and configuration mode

1. Create a Windows service user which will be used to execute BPM Server. (e.g. INFA\bpm-service)

2. Create the same user as MSSQL Server user and configure this user to use Windows Authentication (INFA\bpm-service)

3. Create manually a new ActiveVOS database and configure the owner of this database to newly created user (INFA\bpm-service).

4. Install the Webserver (in our case it's Apache Tomcat) and copy the SQL Server driver class and the additional dll (sqljdbc42.jar and sqljdbc_auth.dll) in the lib folder of Tomcat

5. Adapt the service.bat to use tomcat lib folder additional to a java.lib.path like this: --JvmOptions "...; ...;-Djava.library.path=%CATALINA_HOME%\lib"

6. Extract the installation and configuration tool for "Informatica BPM".
   Go to the <installation_tool>\server-enterprise\tomcat_config\bin folder and adapt the install.properties for server configuration. See example for properties relevant to integrated security. The content of username and password is mandatory but not relevant for the connection. So you can use any signs.

   Properties

   jdbc.database.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver

   jdbc.database.driver.jar=<tomcat_path>\\lib\\sqljdbc42.jar

   jdbc.database.url=jdbc\:sqlserver\://<sqlserver_host>;databaseName\=Active_VOS;integratedSecurity=true;

   jdbc.database.name=Active_VOS

   jdbc.database.password=xxxx

   jdbc.database.username=xxxx

7. Go to the <installation_tool>\server-enterprise\tomcat_config\bin folder and adapt the config_deploy.bat to use tomcat lib folder additional to a java.lib.path like this:

   Configuration

   "<jdk_path>\bin\java" -Xms128m -Xmx512m -Djava.library.path="<tomcat_path>\lib" -jar config.jar %1

8. Open the command window and execute the config_deploy.bat in silent mode.

9. Install the Tomcat service using service.bat install

10. Configure the "Log on" for this service to use the BPM service account (INFA\bpm-service)

11. Start the service and call the ActiveVOS Console.

Re-configuration of already installed server

Following steps can be made to re-configure the existing BPM Server installation to use the integrated security for database connection:

1. Stop and uninstall the Tomcat service for BPM Server. Use service.bat uninstall [ tomcat service name ]
   

2. Create a Windows service user which will be used to execute BPM Server. (e.g. INFA\bpm-service)

3. Create the same user as MSSQL Server user and configure this user to use Windows Authentication (INFA\bpm-service)

4. Configure the owner of the existing ActiveVOS database to newly created user (INFA\bpm-service).

5. Go to the webserver (Tomcat) installation ({install_dir}/apache-tomcat/conf/Catalina) and to the BPM server ({install_dir}/server-enterprise/tomcat_config/conf) and adapt activevos.xml and active-bpel.xml in both places to use integrated security (s. example). The content of username and password is mandatory but not relevant for the connection. So you can use any signs like in example.

   Configuration

   <Context displayName="ActiveBPEL Enterprise Tomcat Database context" path="/active-bpel">

   <Resource name="jdbc/ActiveVOS" auth="Container" type="javax.sql.DataSource"

   maxActive="100"

   maxIdle="10"

   maxWait="1000"

   username="xxxx"

   password="xxxx"

   driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

   url="jdbc:sqlserver://server.informatica.com;databaseName=Active_VOS;integratedSecurity=true;"/>

   </Context>

6. Copy the driver class and the additional dll (sqljdbc42.jar and sqljdbc_auth.dll) in the lib folder of Tomcat

7. Adapt the service.bat to use tomcat lib folder additional to a java.lib.path like this: --JvmOptions "...; ...;-Djava.library.path=%CATALINA_HOME%\lib"

8. Install the Tomcat service using service.bat install

9. Configure the "Log on" for this service to use the BPM service account (INFA\bpm-service)

10. Start the service and call the ActiveVOS Console.

ActiveMQ client library

To make Informatica BPM service ready for working with messaging an additional library has to be installed.

• Download https://repo1.maven.org/maven2/org/apache/activemq/activemq-all/5.15.9/activemq-all-5.15.9.jar

• Put the downloaded file activemq-all-5.15.9.jar into the lib folder of the Tomcat container

• Ensure the JDK version is >=1.8 as the active mq lib requires that

Make sure to restart the Informatica BPM service so that the changes take effect.

Detail configuration of the message manager

To finish the configuration of the manager you have to add the following values as minimum configuration

Verifying the configuration

After the manager configuration has been validated and saved you can go back to the Messaging Service overview page. Your manager should now appear in the list with status running.