Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to connect a Mariadb instance to Qlik cloud. How would this work exactly as I did not see a Mariadb connector.
Thanks in advance!
Hi @TA
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.
I do not see an option to do this in Qlik cloud