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
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.
Qlik Sense Enterprise on Windows
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.