4.2. Configuring Persistence for Dashbuilder

Dashbuilder dependents on the configuration of Business Central. Ensure that Business Central is configured according to Section 4.1, “Configuring Persistence for Business Central”.

Important

On Unix-like systems override the default value of MySQL lower_case_table_names from 0 (case sensitive) to 1 (case insensitive). The Red Hat JBoss BPM Suite KPI queries are written in lowercase, but the table names are in CamelCase. By changing the lower_case_table_names property you prevent exceptions from occurring later on.

To change the database for Dashbuilder:

  1. Prepare your database:

    1. Go to the Product Downloads on the Customer Portal and select Red Hat JBoss BPM Suite.
    2. Download Red Hat JBoss BPM Suite 6.3.0 Supplementary Tools.
    3. Unzip jboss-brms-bpmsuite-6.3-supplementary-tools/ddl-scripts, for example into /tmp/ddl.
    4. Import the DDL script for your database into the database you want to use, for example:

      psql jbpm < /tmp/ddl/postgresql/postgres-dashbuilder-schema.sql
  2. Install the Java Database Connectivity (JDBC) driver onto your application plaform. For more information, see Section 4.1, “Configuring Persistence for Business Central”.
  3. Create a new data source in EAP_HOME/standalone/configuration/standalone.xml. For more information, see Section 4.1, “Configuring Persistence for Business Central”.
  4. Register the data source in Dashbuilder:

    1. Open EAP_HOME/standalone/deployments/dashbuilder.war/WEB-INF/jboss-web.xml.
    2. Change the <jndi-name> to the JNDI name of your data source, for example:

      <jndi-name>java:jboss/datasources/PostgresqlDS</jndi-name>