Initializing help system before first use

Using MySQL for the Mirror Storage

When configured to integrate with a third-party business intelligence tool such as Tableau, Xpress Insight manages a second set of data called the mirror. MySQL is the only option for the mirror.
The first step is to create a database of the correct type for Xpress Insight to use. The database can be given any name. In the command below, the name mirror is used. 
CREATE DATABASE mirror DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

Xpress Insight expects to fully manage the database schema supplied to it. This capability requires a user with all privileges on the database schema. Xpress Insight automatically creates one additional database and user account for each app it hosts that has a mirror tables definition. The user account therefore needs the authority to grant equivalent privileges to the per-app users.

The user account can be the same account that the repository database uses, or a separate one. In the example below a separate insightmirror account is created.

The user is given access to localhost. It is expected that the MySQL service is not co-located with Insight. Therefore localhost should be replaced with the hostname of the MySQL service (or % for all hosts).

Finally, replace myPasswordHere with a suitable password. 

CREATE USER 'insightmirror'@'localhost' IDENTIFIED BY 'myPasswordHere'; 
GRANT ALL ON mirror.* TO 'insightmirror'@'localhost' WITH GRANT OPTION; 
FLUSH PRIVILEGES;
Xpress Insight can be configured to use the new MySQL database for mirroring within the application.properties file. The following table describes the available properties. Review the description of each property and set its value accordingly in the properties file. Then save the file and restart Xpress Insight for changes to take effect.
Configuration property Description
insight.server.visualization.mirror.url The mariadb jdbc URL to the database containing the mirror plus any database connection query parameters (for example, jdbc:mysql://localhost:3306/mirror?useUnicode=yes&characterEncoding=UTF-8&allowPublicKeyRetrieval=true
insight.server.visualization.mirror.username The username for authentication into the database. This user must have database CREATE, user create and GRANT OPTION permissions.
insight.server.visualization.mirror.password The user account Xpress Insight should use to authenticate into the mirror database. This should be added as an encrypted property.
Parent Topic Using MySQL with Insight 5

© 2001-2024 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.