Analytics & BI

Self-Service BI Connectors

Connect Power BI, Tableau, Looker, and other BI tools to NATIS via JDBC/ODBC or native connectors.

---

NATIS exposes a Hive-compatible JDBC/ODBC interface and native connectors for the most popular BI tools, allowing your existing BI investment to query live lakehouse data with full governance applied.

Connection Details

• Server Hostname — adb-{workspace_id}.azuredatabricks.net (or your on-prem host)
• Port — 443 (HTTPS)
• HTTP Path — /sql/1.0/warehouses/{warehouse_id}
• Authentication — Personal Access Token (PAT) or OAuth 2.0
• JDBC Driver — Simba JDBC driver v2.6.29+ (download from Admin → Downloads)

Power BI Setup

• 1. In Power BI Desktop, click Get Data → More → Azure → Azure Databricks.
• 2. Enter the Server Hostname and HTTP Path from your NATIS SQL Warehouse settings.
• 3. Select Authentication: Token, enter your Personal Access Token.
• 4. Click Connect and browse the Navigator to select tables/views to import.
• 5. For DirectQuery mode, select DirectQuery instead of Import when connecting — this queries live data without importing.

Tableau Setup

For optimal performance with Tableau/Power BI, ensure your target tables are OPTIMIZED and ZORDER'd by the most common filter columns. Materializing pre-aggregated Gold tables reduces query time significantly.

• 1. Download and install the Databricks ODBC Driver from NATIS Admin → Downloads.
• 2. In Tableau Desktop, click Connect → More → Databricks.
• 3. Enter Server Hostname, HTTP Path, and Personal Access Token.
• 4. Click Sign In and select your database and schema.
• 5. Drag tables to the canvas to begin analysis.