ODBC Driver

The native ODBC driver: getting started, connection-string options, type mapping, and BI-tool setup.

Bi Tools

• .NET (System.Data.Odbc)Connect from .NET (Framework or Core) via the in-box System.Data.Odbc provider.
• DBeaverUse DBeaver as an ad-hoc SQL client against Delta Forge through the ODBC driver.
• dbt (via dbt-odbc)Use dbt as a transformation layer against Delta Forge through the generic dbt-odbc adapter.
• LookerConnect Looker to Delta Forge via the in-tree JDBC bridge that delegates to the native ODBC driver. Looker has no ODBC entry point of its own.
• Microsoft ExcelConnect Excel to Delta Forge through the ODBC driver via the Get Data > From ODBC route.
• MicroStrategyConnect MicroStrategy to Delta Forge through a generic ODBC database instance.
• Power BI DesktopConnect Power BI Desktop to Delta Forge through the ODBC driver. Works for both Import and DirectQuery modes.
• Python (pyodbc)Connect from Python via pyodbc, the most common Python ODBC binding.
• Qlik Sense and QlikViewConnect Qlik Sense or QlikView to Delta Forge through the generic ODBC connector.
• R (RODBC and odbc)Connect from R via either RODBC (legacy, simpler) or odbc (modern, recommended).
• Tableau Desktop and Tableau ServerConnect Tableau Desktop or Tableau Server / Cloud to Delta Forge through the ODBC driver via the Other Databases (ODBC) connection.

Connection String

• AuthModeAuthentication mode. The driver authenticates with username + password by default; supplying Token= uses a bearer credential instead.
• ComputeServer and ComputeNode (routing)Override the default compute path. Pin to an explicit URL or a named compute node.
• ConnectionTimeout and CommandTimeoutConnect-phase budget and per-statement query timeout.
• Cross-vendor key aliases and tolerated keysConnection-string keys borrowed from other vendors that the driver accepts, plus keys it silently ignores so a connection string copy-pasted from...
• Database, Schema, ApplicationNameDefault catalog (zone) and schema, plus an audit-log identifier for the application.
• HTTPProxy, ProxyUID, ProxyPWDHTTP/HTTPS proxy and basic-auth credentials for environments that route outbound traffic through a corporate proxy.
• MaxStreamBufferMBPer-connection upper bound on in-flight result-set buffers held by the driver while streaming. Off by default; set when you need to bound driver...
• PwdPassword used with Uid to authenticate. Optional when a credential is stored in the OS keychain.
• ServerControl plane URL the driver authenticates and routes through. Required.
• TokenBearer token presented on every request. Skips the username + password auth round-trip.
• UidUsername, email address, or service-principal client ID used to authenticate with the control plane.

Data Types

• Column-name case (lowercase / snake_case)Delta Forge column names are lowercase / snake_case and case-preserving. The ODBC driver returns them verbatim; do not rely on uppercasing or...
• Type mapping (Delta Forge to ODBC)How Delta Forge column types appear over ODBC and which ODBC C types are best for each.

Getting Started

• Credential storage (no plaintext passwords)Save the password or token in the OS-native secret store so it does not appear in odbc.ini, the registry, or scripts.
• DSN file locationsWhere the operating system stores ODBC data source names so the Delta Forge driver can find them.
• First connection smoke testVerify that a freshly installed Delta Forge ODBC Driver authenticates and returns a result row from the engine.
• Install on LinuxInstall the Delta Forge ODBC Driver on Linux from the deb or rpm package and register it with unixODBC.
• Install on macOSInstall the Delta Forge ODBC Driver on macOS from the .pkg installer and register it with iODBC.
• Install on WindowsInstall the Delta Forge ODBC Driver on Windows from the MSI and register it with the ODBC Data Source Administrator.