macOS Installation

Prerequisites

• macOS 12+ (Apple Silicon or Intel)
• unixODBC: brew install unixodbc
• A backend driver — PostgreSQL Unicode is recommended (brew install psqlodbc)

Install the ODBC driver

1. Download libbeem_odbc.dylib

2. Copy to a system library path:

   Bash

   sudo cp libbeem_odbc.dylib /usr/local/lib/

3. Register with unixODBC:

   Bash

   cat <<EOF | sudo odbcinst -i -d -r
   [BEEM ODBC Driver]
   Driver = /usr/local/lib/libbeem_odbc.dylib
   EOF

4. If using ODBC Manager (GUI), also add to /Library/ODBC/odbcinst.ini:

   ini

   [ODBC Drivers]
   BEEM ODBC Driver = Installed
   
   [BEEM ODBC Driver]
   Description = BEEM ODBC Driver with SSH tunnel support
   Driver = /usr/local/lib/libbeem_odbc.dylib

Create a DSN

On macOS, DSNs are configured by editing ~/.odbc.ini (user) or /opt/homebrew/etc/odbc.ini (system):

[BEEM_Production]
Driver = BEEM ODBC Driver
MODE = Direct
DATABASE = analytics
SERVER = your-beem-warehouse-endpoint
PORT = 5439
BACKEND_DRIVER = PostgreSQL Unicode
UID = admin
PWD = your_password
SSH_HOST = bastion.example.com
SSH_USER = deploy
SSH_AUTH = key
SSH_KEY_FILE = /Users/you/.ssh/id_ed25519

Test the connection

isql BEEM_Production -v

Enable logging

export BEEM_ODBC_LOG=~/beem_odbc.log
export BEEM_ODBC_LOG_LEVEL=debug