SR
MK
AB
PD
Analytics teams rely on IntlloBI
3,248,195 queries processed today
+24.5% Revenue Growth
🔒 app.intllobi.com/dashboards/revenue
IntilloBI analytics dashboard

Natively connects to 40+ databases, warehouses & query engines

PostgreSQL PostgreSQL MySQL MySQL MariaDB MariaDB SQL Server SQL Server Oracle Oracle Snowflake Snowflake BigQuery BigQuery Redshift Redshift Databricks Databricks Azure Azure Trino Trino ClickHouse ClickHouse Presto Presto Apache Hive Apache Hive Apache Spark Apache Spark AWS Athena AWS Athena DuckDB DuckDB Apache Druid Apache Druid MongoDB MongoDB Elasticsearch Elasticsearch Google Cloud Google Cloud CockroachDB CockroachDB Apache Doris Apache Doris SQLite SQLite
⚡ Platform Toolkit

Everything your analytics team needs

IntlloBI combines powerful exploration tools, secure database connection adapters, and native pipeline transformation clouds.

📊

Reporting & Dashboards

Drag and drop charts, configure parameters, and share dashboard folders across analytics workspaces with sub-second queries.

💻

SQL Lab Sandbox

Fully featured editor with schema autocomplete, query histories, formatting checks, and direct dataset publishing capabilities.

🔗

Database Connections

Link Snowflake, ClickHouse, Azure Synapse, and PostgreSQL natively. All credentials are encrypted inside an AES-256 vault.

⚙️

ADF to Fabric Sync

Incremental synchronization of database structures (Synapse Warehouse tables mapped to Lakehouse tables, and files to Lakehouse files).

☁️

Transformation Cloud

Establish calculated dimensions and virtual fields directly in the semantic metadata layer, keeping reporting columns aligned.

🤖

IntelloAI Assistant

A RAG-powered chatbot that reads dataset structures to construct SQL codes and auto-generate ECharts visualizations inside chat views.

🔌 Integrations

Plug into all your data

From transactional databases to cloud warehouses and query engines — connect natively and securely in minutes.

PostgreSQL PostgreSQL
MySQL MySQL
Snowflake Snowflake
BigQuery BigQuery
Redshift Redshift
Databricks Databricks
ClickHouse ClickHouse
Trino Trino
Oracle Oracle
SQL Server SQL Server
MongoDB MongoDB
Azure Azure
📋 Frequently Asked Questions

Common queries about the platform

Get answers to standard implementation procedures, database permissions guidelines, and pipeline orchestration processes.

What databases does IntlloBI support?

We connect natively to over 50 databases via SQLAlchemy drivers, including Snowflake, ClickHouse, PostgreSQL, Databricks, BigQuery, and SQL Server. Zero ETL pipeline sync needed.

How secure is the database credentials vault?

Database passwords and credentials keys are encrypted at rest with bank-grade AES-256 encryption. We also support VPC Peering, IP white-listing, and secure SSH database tunneling.

Does the orchestrator support custom Microsoft Fabric rules?

Yes. The ADF Fabric Sync orchestrator checks source configurations: warehouse data sources (such as Azure Synapse) are incrementally synchronised to Lakehouse Tables, while unstructured file containers are linked to Lakehouse Files without schemas alteration.

Initializing Workspace Sandbox...

Verifying database connections...

📊 Reporting & Dashboards

● Live Sandbox
Active Daily Users
14,853
↑ 12%
Sales Volume (MTD)
$148,290
↑ 18%
Query Latency
12ms
Optimal
User Acquisition & Engagement Trend
Schema Catalog
🗂️ transactions_ledger
🗂️ active_subscribers
SELECT billing_month, sum(amount_usd) AS revenue FROM transactions_ledger GROUP BY 1 ORDER BY 1 DESC;
Database: postgres_olap
Click "Run Query" to retrieve data from postgresql catalog.
Virtual Semantic Dimensions
metric_nameformula_expressiontype
gross_marginSUM(rev - cost)/SUM(rev)PERCENT
customer_ltvavg_rev_user / churn_rateCURRENCY
YAML dbt Model configuration
models:
  - name: transactions_ledger
    columns:
      - name: transaction_id
        tests:
          - unique
          - not_null
              
Microsoft Fabric Pipelines Mapping (ADF Migration Rule 3)
Pipeline Definition adf_sales_migration.json → fabric_pl_comm_sales_migration.json
● Synapse DW Warehouse destination mapped to Lakehouse Table sales_data (Rule 3)
Pipeline Definition adf_customer_sync.json → fabric_pl_comm_customer_sync.json
● Storage Container destination mapped to Lakehouse File customer_logs (Rule 3)
Connection Creation Guidance (Rule 7) To create the connection in Fabric matching the ADF source, configure a Microsoft Fabric Lakehouse/Warehouse database connection using the same server address, authentication credentials, and database schemas as defined in the ADF database properties. No modifications are needed on the Fabric database configurations.
ADF → Fabric Incremental Migration
[System Idle] Ready to trigger pipeline migrations.
Syncing Pipelines... 0%
PostgreSQL
● Active (OK)
Snowflake
● Active (OK)
ClickHouse
● Active (OK)
Azure Synapse
● Active (OK)
IntelloAI Copilot: Ask me to write database SQL queries, compile schemas, or compare analytics metrics.
Active Workspace Catalog Log
  • 👤 Sarah K. committed modifications to pl_comm_sales_migration • 5m ago
  • 👤 David M. executed query on Snowflake catalog table • 25m ago
  • 👤 admin@intllobi.com logged into Sandbox Demo mode • Just now