qlik cloud mariadb

tal32123 — Wed, 15 Dec 2021 18:22:46 GMT

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!

Re: qlik cloud mariadb

Vikram_Jayakumar — Mon, 26 Jul 2021 01:14:25 GMT

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.

Re: qlik cloud mariadb

tal32123 — Mon, 26 Jul 2021 08:38:48 GMT

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

topic qlik cloud mariadb in Connectivity & Data Prep

qlik cloud mariadb

Re: qlik cloud mariadb

Re: qlik cloud mariadb