Linux Installation

Prerequisites

• unixODBC: sudo apt install unixodbc (Debian/Ubuntu) or sudo dnf install unixODBC (Fedora/RHEL)
• A backend ODBC driver — Amazon Redshift ODBC Driver (x64) or PostgreSQL ODBC (sudo apt install odbc-postgresql)

Install the ODBC driver

1. Download libbeem_odbc.so

2. Copy to a system library path:

   Bash

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

3. Register with unixODBC:

   Bash

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

4. Verify:

   Bash

   odbcinst -q -d
   # Should list: [BEEM ODBC Driver]

Create a DSN

Edit /etc/odbc.ini (system-wide) or ~/.odbc.ini (user):

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

Test the connection

isql BEEM_Production -v

Enable logging

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