Qlik Sense connection to MariaDBArticle Number: 000050451 | Last Modified: 2019/01/17
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.
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.
LIB CONNECT TO 'mariadbdsn (domain_qvservice)';
SQL SELECT `emp_no`,
SQL SELECT `dept_no`,
2. Another workaround is to use the open source Mariadb connector (https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.0.3/) and install it as a DSN connector.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.