qlik cloud mariadb

[tal32123]

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!

[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.

[tal32123]

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