Initializing help system before first use

Using MySQL for the Mirror Storage

Xpress Insight manages a second set of data called the Mirror, when configured to integrate with a third-party Business Intelligence tool such as Tableau. 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;

Insight expects to fully manage the database schema supplied to it. This capability requires a user which has been granted all privileges on the database schema. Insight will automatically create one additional database and user account for each app it hosts which 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, you should 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;
Insight can be configured to use the new MySQL database for mirroring within the Insight Server 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 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 e.g., 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 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-2023 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.