Qlik Community

Ask a Question

Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY

Qlik Sense connection to MariaDB

Sonja_Bauernfeind
Digital Support
Digital Support

Qlik Sense connection to MariaDB

 

User is able to connect to MariaDB using an ODBC connection (DSN), however the load cannot be performed as the fields are not visible in the wizard.

000050451a.png

 

Environment:

Qlik Sense Enterprise on Windows 

Resolution:

 

As there isn't a specific connector for MariaDB, there are 2 suggested 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.
 

Labels (1)
Version history
Revision #:
2 of 2
Last update:
2 weeks ago
Updated by:
 
Contributors