Qlik Replicate: No MySQL ODBC Unicode Driver error while connecting to MariaDB

[Dineshan]

Testing the connection to an AWS RDS hosted Mariadb database fails with:

SYS-E-HTTPFAIL, No MySQL ODBC Unicode Driver version x.x or above is installed..
SYS,GENERAL_EXCEPTION, No MySQL ODBC Unicode Driver version x.x or above is installed.

Resolution

Verify that the Qlik Replicate documentation was followed correctly and that the /etc/odbcinst.ini file contains an entry for MySQL. See Driver prerequisites | Qlik Replicate Help.

If a new driver was installed, it may have overwritten a previous entry or wrongly added a new one.

Per Qlik documentation:

[MySQL ODBC 5.3.13 Unicode Driver]
Driver = /usr/lib64/libmyodbc5w.so
UsageCount = 1

Per the driver installation:

[MySQL ODBC 5.3 Unicode Driver]
Driver=/usr/lib64/libmyodbc5w.so
UsageCount=1

Remove .13 in the .ini file to resolve this.

Environment

Qlik Replicate