Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
tal32123
Contributor
Contributor

qlik cloud mariadb

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!

Labels (3)
2 Replies
Vikram_Jayakumar

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.

If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
tal32123
Contributor
Contributor
Author

I do not see an option to do this in Qlik cloud