Initializing help system before first use

Integrating with MySQL

You can configure Xpress Insight to use a MySQL database as its data repository.

Xpress Insight manages scenarios and other objects in a data store called the repository. By default, the repository is persisted using the local file storage of the server. This approach is adequate for small development installations. But for larger deployments, you can configure Insight to use a MySQL database to persist the repository. MySQL is recommended for large scale development installations and required for production systems.

You can also configure Insight to manage a second set of data called the mirror database. The mirror database is required if you want to integrate with a third-party business intelligence (BI) tool such as Tableau. MySQL is the only option for the mirror database.

Note: You must provide an installation of MySQL 8.x with vendor support for Insight to use.
Covered Topics
  • MySQL requirements
    Xpress Insight requires that you supply a schema within an existing MySQL server. Insight requires MySQL v8.x with vendor support.
  • Using MySQL for the Repository
    Xpress Insight can persist its repository data to a MySQL database. To use this option, you must create a database of the correct type for Insight to use.
  • Using MySQL for the Mirror Database
    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 database. MySQL is the only option for the mirror database.
Parent Topic Insight 5 Administrator Guide

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