I’m trying to connect to my Heroku PostgreSQL database through Tableau and ODBC, this needs to be over ODBC because it needs to be SSL connection. This being said, I have configured a User DSN. I followed some of the steps from this blog.
- First, I ran this to install a driver:
brew install psqlodbc
- I edited my
/usr/local/etc/odbcinst.inifile:
[PostgreSQL Unicode]
Description = PostgreSQL ODBC driver (Unicode version)
Driver = /usr/local/lib/psqlodbcw.so
- I edited my
odbc.ini.
nano ~/.odbc.ini
[ib3db]
Driver = PostgreSQL Unicode
Description = None
SSLMODE = verify-ca
ServerName = <host>
Database = <db_name>
Port = 5432
Username = <username>
Password = <pwd>
Pqopt = sslcert=<.crt> sslkey=<.key> sslrootcert=<.crt>
I tested this in the terminal and it’s working fine, I’m able to connect to my DB successfully. So, the configuration seems to be correct.
The issue arises when I try to connect via Tableau. After selecting To a Server > ODBC > DSN, I choose the previously created DSN named ib3db, and then I get this error:
[iODBC][Driver Manager]dlopen(PostgreSQL Unicode, 0x0006): tried: ‘PostgreSQL Unicode’ (relative path not allowed in hardened program), ‘/System/Volumes/Preboot/Cryptexes/OSPostgreSQL Unicode’ (no such file), ‘/Applications/Tableau Desktop 2024.3.app/Contents/MacOS/PostgreSQL Unicode’ (no such file), ‘/Applications/Tableau Desktop 2024.3.app/Contents/MacOS/PostgreSQL Unicode’ (no such file), ‘/Applications/Tableau Desktop 2024.3.app/Contents/MacOS/PostgreSQL Unicode’ (no such file), ‘/Applications/Tableau
[iODBC][Driver Manager]Specified driver could not be loaded
Generic ODBC requires additional configuration. The driver and DSN (data source name) must be installed and configured to match the connection.
Do I need to rename the previously installed driver to match the path Tableau is looking for?
How can I tell Tableau to go to the correct path to find the Driver I’ve installed?
1