Connecting EQQ to MySQL and PostgreSQL Databases

EQQ is available for three database platforms: Microsoft SQL Server, MySQL, and PostgreSQL. Each EQQ installation is built for one database type only, chosen at installation time. This guide is for organizations whose EQQ installation is running on MySQL or PostgreSQL.

One Database Type Per Installation

When EQQ is installed, the database platform is selected and the entire installation — including the internal EQQ database and all business database connections — runs on that one platform. You cannot mix database types within a single EQQ installation. If your business runs MySQL, your EQQ installation is the MySQL edition; if PostgreSQL, it is the PostgreSQL edition.

The supported versions for each platform are:

  • Microsoft SQL Server — SQL Server 2014 or later
  • MySQL — version 5.7 or later
  • PostgreSQL — version 10 or later

Adding Business Database Connections (MySQL Installation)

Once EQQ is installed on MySQL, Administrators can add connections to one or more MySQL business databases that users will query. All connections use the same MySQL platform as the installation.

  1. Log in as an Administrator and go to Administration > Database Connections
  2. Click Add Connection
  3. Enter the connection details:
    • Server: hostname or IP address of your MySQL server
    • Port: default is 3306
    • Database: the name of your business database
    • Username and Password: credentials for a read-only MySQL user
  4. Click Test Connection to verify, then click Save

Adding Business Database Connections (PostgreSQL Installation)

On a PostgreSQL EQQ installation, Administrators add connections to PostgreSQL business databases in the same way.

  1. Go to Administration > Database Connections and click Add Connection
  2. Enter the connection details:
    • Host: your PostgreSQL server hostname or IP address
    • Port: default is 5432
    • Database: your PostgreSQL business database name
    • Username and Password: credentials for a read-only PostgreSQL user
  3. Click Test Connection to verify, then click Save

Creating a Dedicated Read-Only Database User

EQQ only ever reads your business data. Always create a dedicated, read-only account for EQQ on each business database:

  • MySQL: create a user and grant SELECT privilege only on the relevant database
  • PostgreSQL: grant CONNECT on the database and SELECT on the schemas or tables EQQ should access

Do not use a superuser or administrative account. EQQ does not need and should not have write permissions on your business database.

Registering Views for Query Creators

Once a connection is saved, the Administrator registers specific database views under Administration > Views. Query Creators use these views as the foundation for building queries. Exposing views rather than raw tables keeps the database structure clean and ensures only approved data sets are visible to users.

Need Help?

If you need assistance choosing the right EQQ edition for your database platform, configuring database users, or establishing connections, contact us via Get In Touch or explore our Install and Configure professional service.