Windows Installation

Recommended: MSI Installer

For most users, download and run the BEEM ODBC Installer. It registers the driver, configures the connection, and installs the Power BI connector automatically.

Prerequisites

• Windows 10 or later (64-bit)
• A backend ODBC driver — Amazon Redshift ODBC Driver (x64) or PostgreSQL Unicode

Manual installation

If you need to install the driver manually (e.g. for custom deployments or troubleshooting):

1. Download beem_odbc.dll

2. Copy the DLL to a permanent location:

   PowerShell

   mkdir "C:\ODBC\BEEM" -Force
   copy beem_odbc.dll "C:\ODBC\BEEM\"

3. Register the driver (run as Administrator):

   PowerShell

   odbcconf /a {INSTALLDRIVER "BEEM ODBC Driver|Driver=C:\ODBC\BEEM\beem_odbc.dll|Setup=C:\ODBC\BEEM\beem_odbc.dll||"}

4. Verify the driver appears in ODBC Data Sources (64-bit) > Drivers tab.

Create a DSN

1. Open ODBC Data Sources (64-bit) from the Start menu
2. Click Add under the User DSN or System DSN tab
3. Select BEEM ODBC Driver and click Finish
4. Fill in the configuration dialog:
   • DSN Name: a name for this connection (e.g. BEEM_Production)
   • Server: your BEEM Data Warehouse endpoint
   • Port: 5439 (default)
   • Database: your database name
   • Backend Driver: select your installed backend ODBC driver
   • Connection settings: configured automatically at install time
5. Click Test Connection to verify
6. Click OK to save

Enable logging

Set the BEEM_ODBC_LOG environment variable to a file path:

[System.Environment]::SetEnvironmentVariable("BEEM_ODBC_LOG", "C:\ODBC\BEEM\beem_odbc.log", "User")

By default, the driver logs to C:\ODBC\BEEM\beem_odbc.log or %TEMP%\beem_odbc.log.

Control the log level with BEEM_ODBC_LOG_LEVEL: