This article describes how to connect a MySQL database to Peliqan. This is referred to as an “external DB connection” in Peliqan, a direct DB connection is made to query data, without duplicating the data to the Peliqan data warehouse.
<aside> ☝
The minimum supported version for MySQL is 8.x. Older versions cannot be connected to Peliqan ! Run "SELECT VERSION();" in your DB to check your version.
</aside>
In Peliqan, go to Connections > Add Connection > Select MySQL in the list > Enter the details of your MySQL instance:
Make sure to configure following permissions in MySQL, so that Peliqan can connect remotely:
Use wildcard % for the hostname in the user, so that the user can connect remotely (from Peliqan) to your MySQL database:
CREATE USER 'newuser'@'%' IDENTIFIED BY 'StrongPassword123!';
If the user is created using e.g. CREATE USER 'newuser'@'localhost', Peliqan will not be able to connect.
Use the wildcard % for the hostname, also when granting permissions:
GRANT ALL PRIVILEGES ON mydatabase.* TO 'newuser'@'%';
Make sure to add Peliqan’s IP addresses, as well as the AWS hostnames for each IP, in case that IP whitelisting is active on your database. More info:
Example to add IP whitelisting for the Peliqan EU instance, when creating a user: