4.3. Configuring Persistence for the Intelligence Process Server

When changing the database for the Intelligence Process Server, the best practice is to use a separate database from the one for Business Central and Dashbuilder applications. To change the database for the Intelligence Process Server:

  1. Open EAP_HOME/standalone/configuration/standalone.xml and locate the <system-properties> tag.

  2. Add the following properties:

    • org.kie.server.persistence.ds: The JNDI name of your data source.

    • org.kie.server.persistence.dialect: The hibernate dialect for your database.

      For example: 

      <system-properties>
    <property name="org.kie.server.repo" value="${jboss.server.data.dir}"/>
    <property name="org.kie.example" value="true"/>
    <property name="org.jbpm.designer.perspective" value="full"/>
    <property name="designerdataobjects" value="false"/>
    <property name="org.kie.server.user" value="bpmsUser"/>
    <property name="org.kie.server.pwd" value="bpms123!"/>
    <property name="org.kie.server.location" value="http://localhost:8080/kie-server/services/rest/server"/>
    <property name="org.kie.server.controller" value="http://localhost:8080/business-central/rest/controller"/>
    <property name="org.kie.server.controller.user" value="kieserver"/>
    <property name="org.kie.server.controller.pwd" value="kieserver1!"/>
    <property name="org.kie.server.id" value="local-server-123"/>

    <!-- Data source properties. -->
    <property name="org.kie.server.persistence.ds" value="java:jboss/datasources/PostgresqlDS"/>
    <property name="org.kie.server.persistence.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/> -->
</system-properties>