Initializing help system before first use

Configuring Xpress Insight for Tableau for FICO Server

A non-production deployment of Xpress Insight can use either the filesystem or a MySQL database for its scenario repository. This Quick Installation guide covers only the simple filesystem-based deployment. These instructions install MySQL solely for the purpose of hosting the mirror reporting database. Users who wish to also adopt MySQL for the scenario repository should follow the instructions in the full Installation Guide.

These instructions assume Tableau for FICO Server is installed locally.

Installing a local MySQL 8 service:

  1. Install the latest MySQL 8 from https://dev.mysql.com/downloads/installer/. Select the developer package which includes server and command line shell.
  2. Accept all defaults. When prompted for an administrator username and password, use admin and admin123.
  3. Choose to open the MySQL Shell at the end of the installer process and then enter the following commands: 
    \sql
\connect root@localhost
CREATE DATABASE mirror DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE USER 'insight'@'%' IDENTIFIED BY 'insight';
GRANT ALL PRIVILEGES ON *.* TO 'insight'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

    These commands create the main mirror database and a user with both username and password as "insight" with privileges to create new databases and users.

  4. Open the windows Services dialog as administrator and restart the MYSQL80 service.

    In this next steps, you will configure Insight to use the MySQL service.

  5. Open the Xpress Insight Server configuration file at \ProgramData\XpressInsight\Server\config\application.properties
  6. Find the Mirror section of the server configuration. Uncomment the first 3 properties and set them to the following values: 
    #------------------------------------------------------------------------------
# Mirror
#------------------------------------------------------------------------------

# The mariadb jdbc URL to the database containing the mirror plus any database connection query parameters
insight.server.visualization.mirror.url=jdbc:mysql://localhost:3306/mirror?useUnicode=yes&characterEncoding=UTF-8&allowPublicKeyRetrieval=true
# The username for authentication into the database. This user must have database CREATE permissions.
insight.server.visualization.mirror.username=insight

# The password for authentication into the database.
insight.server.visualization.mirror.password=insight
    Note: It is recommended that the passwords entered in the properties file are encrypted for production systems and multi-user development systems. This step is omitted here for simplicity. See the main Insight Installation guide for more information on securing an Insight installation.
  7. Find the Tableau section of the server configuration. Uncomment the first 3 properties and set them to the following values: 
    #------------------------------------------------------------------------------
# Tableau
#------------------------------------------------------------------------------
# The URL you want Insight to use to access your Tableau server
insight.server.visualization.tableau.url=http://localhost:80

# A user configured as a System User within Tableau
insight.server.visualization.tableau.system-user=admin

# The password for the provided system user
insight.server.visualization.tableau.system-password=admin123
  8. Save and close the application.properties file.
  9. Open the windows Services dialog as administrator and restart the FICO Xpress Insight Server service.
Parent Topic Installing Tableau for FICO

© 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.