Search code examples
mariadbtableau-apiconnectortableau-desktop

Installing a MariaDB connector on Tableau Desktop


I'm on MacOS and I'm trying to install a MariaDB Connector on Tableau Desktop. But I keep getting this error message :

enter image description here

I followed the instructions by installing the MariaDB ODBC driver from the official website. After its installation I placed the driver folder under /User/username/Tableau/Drivers.

Although, I keep getting the same error. Do you have an idea on how to correctly install a MariaDB connector for Tableau on MacOS ?


Solution

  • Need to configure iODBC to recognise MariaDB Connector/ODBC as a Driver:

    1. Install [iODBC][1]http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads
    2. Modify the configuration file /Library/ODBC/odbcinst.ini as the following:
    [ODBC Drivers]
    MariaDB ODBC 3.1 Driver = installed
    
    [MariaDB ODBC 3.1 Driver]
    Description=MariaDB Connector/ODBC v.3.1
    Driver=/Library/MariaDB/MariaDB-Connector-ODBC/libmaodbc.dylib
    Threading=0