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”.
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:
Prepare your database:
- Go to the Product Downloads on the Customer Portal and select Red Hat JBoss BPM Suite.
-
Download
Red Hat JBoss BPM Suite 6.3.0 Supplementary Tools. -
Unzip
jboss-brms-bpmsuite-6.3-supplementary-tools/ddl-scripts, for example into/tmp/ddl. 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
- Install the Java Database Connectivity (JDBC) driver onto your application plaform. For more information, see Section 4.1, “Configuring Persistence for Business Central”.
-
Create a new data source in
EAP_HOME/standalone/configuration/standalone.xml. For more information, see Section 4.1, “Configuring Persistence for Business Central”. Register the data source in Dashbuilder:
-
Open
EAP_HOME/standalone/deployments/dashbuilder.war/WEB-INF/jboss-web.xml. Change the
<jndi-name>to the JNDI name of your data source, for example:<jndi-name>java:jboss/datasources/PostgresqlDS</jndi-name>
-
Open
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.