Configuring the DWH

The DWH configuration and initialization are covered in great detail in the ConSol CM Administrator Manual in section DWH administration. Please refer to this document for further information.

Two types of system properties can be set for ConSol CM:

• ConSol CM system properties which have to be set on the System properties page of the Web Admin Suite, or when configuring the DWH on the Administration page. The properties belong to the module cmas-dwh-server, see List of system properties.
• Java system properties which have to be provided as -D parameters at the start of a CM system. These properties are explained in the following section.

Java system properties for the DWH

There exist some options which effect the CMRF functionally, which can only be provided as Java system properties during application server startup. If you want to use these system properties, they should be added to the startup scripts of the application server. In this way, these parameters are used on every restart. The variable JAVA_OPTS is used to configure general startup parameters in the scripts for all supported application servers. You can add the CMRF system properties here.

The following command can be used to set the Java properties:

• Windows

  set JAVA_OPTS="%JAVA_OPTS% -D<option>=<value>"

• Linux

  set JAVA_OPTS="$JAVA_OPTS -D<option>=<value>"

This works for standalone and overlay installations.

Truncation of text fields (MySQL only)

On MySQL, the values of data fields of the type Text (string) are truncated to avoid exceeding the row size limit of MySQL (relevant when a field group contains several text fields to be transferred). By default, only the first 512 characters of the field values are written to the DWH database.

You can modify the number of characters by adding the property cmrf.mysql.truncate.string to the start command of the CMRF, e.g.:

-Dcmrf.mysql.truncate.string=256