Install on macOS

Install the Delta Forge ODBC Driver on macOS from the .pkg installer and register it with iODBC.

Syntax

DeltaForgeODBC-<version>.pkg

Description

## Overview The driver ships as a `.pkg` installer for macOS. It registers with iODBC, the macOS-native driver manager that comes preinstalled. ## Prerequisites - macOS 12 (Monterey) or later. macOS 11 is best-effort; nothing in the driver intentionally breaks on it but it is not part of CI. - Administrator rights to run the .pkg. The package writes under `/usr/local/`. - iODBC is preinstalled. If you have replaced it with unixODBC via Homebrew, you must register the driver manually in `~/.odbc.ini` and `~/.odbcinst.ini` instead. ## Steps 1. Download the `DeltaForgeODBC-<version>.pkg` from the Delta Forge release page. 2. Double-click to launch the installer and follow the prompts. If Gatekeeper blocks the install, confirm the publisher matches the expected signer. 3. The installer drops the dylib at `/usr/local/lib/libdeltaforgeodbc.dylib` and renders an iODBC registration fragment under `/usr/local/share/deltaforge/odbcinst.ini`. The package's postinstall script runs `iodbcinst -i -d -f <fragment>` so iODBC picks the driver up from `/Library/ODBC/odbcinst.ini`. 4. Open **ODBC Manager** (a free third-party app, not bundled with macOS) or edit `~/Library/ODBC/odbc.ini` directly to add a user DSN. 5. Smoke-test with `iodbctest`. The `iodbctest` binary ships with iODBC and accepts a connection-string argument; on a successful connect it prints driver version information and an interactive prompt. ## Uninstall The .pkg does not register a removal scriptlet. Remove the dylib, drop the iODBC registration fragment, and edit `/Library/ODBC/odbcinst.ini` to delete the `[DeltaForge ODBC Driver]` section: ``` sudo rm -f /usr/local/lib/libdeltaforgeodbc.dylib sudo rm -rf /usr/local/share/deltaforge sudo sed -i '' '/^\[DeltaForge ODBC Driver\]/,/^\[/d' /Library/ODBC/odbcinst.ini ``` User DSNs in `~/Library/ODBC/odbc.ini` are left in place so a re-install picks up the existing configuration.

Examples

# GUI install
open DeltaForgeODBC-1.0.0.pkg

# Silent install (admin)
sudo installer -pkg DeltaForgeODBC-1.0.0.pkg -target /

# Verify the driver is registered with iODBC
iodbctest 'DSN=DeltaForge'

# Inspect the iODBC driver registration file
cat /Library/ODBC/odbcinst.ini

Pitfalls

• Some BI tools on macOS link against unixODBC from Homebrew rather than the system iODBC. If the driver is registered only with iODBC, those tools will not see it. Either install unixODBC and register the driver there too, or use the iODBC-aware build of the tool.
• Tableau Desktop on macOS uses iODBC by default; its DSN dialog only enumerates iODBC-registered drivers. The .pkg installer covers this case.
• The macOS keychain prompts for permission on first credential read. If the prompt is dismissed, the driver falls back to the connection-string `Pwd=` value. Approve the prompt once and the keychain remembers the granted access.

See Also

• ODBC_INSTALL_WINDOWS
• ODBC_INSTALL_LINUX
• ODBC_FIRST_CONNECT
• ODBC_DSN_LOCATIONS
• ODBC_CRED_STORE