Velaxe
InsightLake — Analytics Warehouse & BI for the Velaxe Suite | Velaxe

InsightLake

Enable BI pass‑through (JDBC/ODBC read)

Grant read‑only credentials so external BI tools can query curated datasets.

14 min Intermediate Data Engineer, Analyst Updated Oct 1, 2025
View App All Guides

Overview

Grant read‑only credentials so external BI tools can query curated datasets.

Prerequisites

None.

Permissions required

connections:write

Steps (3)

Estimated: 14 min
  1. 1

    Create read user

    Data Engineer 5 min Back to top

    Settings → Access → **New Read‑Only User**; restrict to curated schemas.

    Tips

    —

    Validation

    —

    Success criteria

    —

  2. 2

    Get connection string

    Analyst 5 min Back to top

    Copy JDBC/ODBC URL and driver info; test from your BI tool.

    Tips

    —

    Validation

    —

    Success criteria

    —

  3. 3

    Validate governance

    Security 4 min Back to top

    Confirm RLS/masking policies apply through pass‑through.

    Tips

    —

    Validation

    —

    Success criteria

    • BI tool queries respect row filters and masked columns.

About this guide

InsightLake centralizes analytics for your Velaxe workspace. Connect built-in streams from Agent Desk, LiveConnect, PulseGate, VoiceLink, FlowForge, Chronicle, ActionDesk, PayStream, SecureStore, AppBazaar, ProductCatalog, and Chat Core—plus curated external sources like GA4, Stripe, and Shopify.

Data is modeled into conformed dimensions and fact tables for predictable analysis. Publish templated dashboards in one click, build custom boards with a drag-and-drop builder or SQL, and schedule alerts and exports. Governance features include row-level security, column masking for PII, audit logs, and retention controls.

InsightLake is designed for speed and reliability with streaming ingestion, materialized views, and SLAs for load times and export delivery.