Qlik Sense and MariaDB

[Sonja_Bauernfeind]

UPDATE: December 2023. All ODBC data sources, except ServiceNow, are now supported with Qlik Data Gateway - Direct Access. A sample connections string for MariaDB can be found here.



MariaDB is not officially supported by the Qlik ODBC connector(s). No standalone connector is currently available. 

See ODBC Connector Package for a list of supported databases.

Connecting to MariaDB using an ODBC connection (DSN) will still work, however, the data load cannot be performed successfully as the fields are not visible in the wizard.

Resolution

As Qlik does not supply a specific connector for MariaDB, there are two possible workarounds: 

1. The reload can be performed if the script is added manually and in case that the fields that we need to load from MariaDB are known.
   
   Example:
   
   LIB CONNECT TO 'mariadbdsn (domain_qvservice)';
   LOAD `emp_no`,
       `dept_no`,
       `from_date`,
       `to_date`;
   SQL SELECT `emp_no`,
       `dept_no`,
       `from_date`,
       `to_date`
   FROM employees.`current_dept_emp`;
   
   LOAD `dept_no`,
       `dept_name`;
   SQL SELECT `dept_no`,
       `dept_name`
   FROM employees.departments;
   
   
2. Another workaround is to use the open source Mariadb connector (MariaDB Connector - Latest Version) and install it as a DSN connector.

[parkera]

24.April.23 - Link still accurate and ODBC (DSN) connections work fine. We ported (and consolidated) our back end systems onto Maria DB and saw 40% saving in cost (for hosting MYSQL) and performance bump to enterprise grade. Millisecond response times.