KNOWLEDGE BASE

Errors "Driver Could Not Be Loaded ... code signature invalid" Connecting to Data from Tableau Desktop for macOS


Published: 18 Aug 2021
Last Modified Date: 23 Aug 2021

Issue

When connecting to a PostgreSQL, Greenplum, Redshift, Denodo, or Presto database using Tableau Desktop on macOS, an error occurs similar to one of the following:

An error occurred while communicating with PostgreSQL
The drivers required to connect to the data source are not installed.
Note that you might need to make local configuration changes to resolve the error.
Error Code: 37CE01A3
[iODBC][Driver Manager]dlopen(/usr/local/lib/psqlodbcw.so, 6): no suitable image found.  Did find:
    /usr/local/lib/psqlodbcw.so: code signature invalid for '/usr/local/lib/psqlodbcw.so'
[iODBC][Driver Manager]Specified driver could not be loaded

 

An error occurred while communicating with PostgreSQL
The drivers required to connect to the data source are not installed.
Note that you might need to make local configuration changes to resolve the error. 
Error Code: 4D78F526
[iODBC][Driver Manager]diopen{/user/local/lib/psqlodbcw.so, 6): no suitable image found. Did find: /user/local/lib/psqlodbcw.so: code signature invalid for '/user/local/lib/psqlodbcw.so' /usr/local/lib/psqlodbcw.so: stat() failed with errno-22
[iODBC][Driver Manager]Specified driver could not be loaded

 

 

Environment

  • Tableau Desktop
  • macOS
  • PostgreSQL
  • Greenplum
  • Redshift
  • Denodo
  • Presto
  • Oracle

Resolution

 

PostgreSQL 

  • For Tableau 2020.4 and newer versions, Install the JDBC driver for PostgreSQL, which can be downloaded from this link
  • For Tableau 2020.3 and earlier versions, install the updated Tableau Driver package.

Greenplum: 

1. Uninstall Tableau Greenplum drivers from /Library/ODBC/odbcinst.ini 
2. Install the updated Tableau Driver package.

Redshift

  1. Uninstall Tableau Redshift drivers from /Library/ODBC/odbcinst.ini
  2. Install the official Amazon Redshift ODBC driver.
If you're experiencing slow performance, try installing the version 1.4.10 ODBC driver

Denodo: 

1. Uninstall Tableau Denodo drivers from /Library/ODBC/odbcinst.ini 
2. Install the updated Tableau Driver package.

Presto

Oracle

  • For Tableau 2020.2 and newer, Oracle JDBC drivers are not impacted and will continue to work.
  • For Tableau 2020.1 and below: download the updated Tableau Driver package and re-install the oracle driver.

Additional Information

This error can also be encountered when connecting to an Amazon Redshift database if Redshift drivers are not installed, as Desktop will attempt to fallback to the PostgreSQL driver.

Related article: Unable to launch or install Tableau Desktop on Mac
Did this article resolve the issue?