Onelake Drivers
Access OneLake Data With Simba
Enable your application to connect to Microsoft OneLake with the Simba ODBC driver, built for platforms that need to redistribute.
Bring Microsoft OneLake to Your Applications
Bring Microsoft OneLake to Your App With Simba Connectivity
Microsoft OneLake brings all your Fabric data together. If you want to connect it to third-party tools or include it in your own platform, you need a driver with redistribution rights. Simba gives you that option with reliable ODBC connectivity.
Use OneLake Data in BI, ETL, and Embedded Platforms
Simba lets you connect Microsoft OneLake to:
- BI tools like Power BI, Tableau, Logi Symphony, and Excel
- ETL pipelines and data integration tools
- Embedded analytics and custom-built apps
Query Delta and Parquet tables directly through OneLake’s ADLS Gen2 interface. No data copying. No reformatting.
Fast Queries, Secure Access, and Full Integration
Simba OneLake drivers support:
- Pushdown queries for faster results
- Automatic schema and metadata discovery
- Secure connections with OAuth 2.0 and SSL
- Compatibility with any tool using ODBC
Why Choose Simba?
Simba is trusted by Microsoft, Google, and Snowflake. Our drivers are reliable, easy to integrate, and built for software vendors who need to include OneLake access in their products.
The Problems Simba Solves for OneLake Access
Redistribution Isn’t Allowed by Microsoft
Microsoft’s native tools let you access OneLake but don’t allow redistribution. That blocks ISVs and platform builders from embedding access in their apps. Simba drivers solve this with a fully licensed, redistributable ODBC connector.
Building Your Own Driver Takes Too Long
Engineering your own driver for OneLake means handling security, schemas, query logic, and updates. That’s time your team can’t spare. Simba gives you a production-ready driver with pushdown support, schema mapping, and enterprise protocols.
No Easy Way to Support BI and ETL Tools
Without a standard driver, users struggle to connect OneLake to BI tools or ETL systems. That means brittle workarounds and poor UX. Simba supports ODBC, so OneLake works with Excel, Power BI, Tableau, and integration platforms instantly.
What You Gain With Simba’s OneLake ODBC Driver
Faster Queries Through Pushdown Optimization
Simba improves performance by pushing filters, joins, and aggregations directly to Microsoft OneLake. This reduces data transfer, speeds upload times, and delivers fast, reliable query performance in Power BI, Tableau, and other ODBC-compatible tools.
Automatic Schema and Metadata Discovery
Simba drivers make Microsoft OneLake data instantly usable by automatically mapping complex Delta and Parquet structures into SQL-ready tables. No manual schema design is needed. You get fast, metadata-aware connectivity for ODBC workflows.
Easy To Embed in Any Platform or Product
Simba drivers are built for software vendors and OEMs who need to embed Microsoft OneLake connectivity. With standards-based protocols, secure authentication, and proven stability, integration is fast and reliable across ODBC systems.
Empower Your Tools and Customers With OneLake Data
The Simba OneLake Driver gives your users secure, standards-based access to enterprise data stored in Microsoft OneLake for reporting, analytics, and integration.
-
Customer Records
-
Financial Data
-
Sales Transactions
-
Product Catalogs
-
Marketing Metrics
-
Budgeting and Forecasting
-
HR Information
-
Inventory Logs
-
Web Analytics
-
Supplier Details
-
Manufacturing KPIs
-
Project Tracking
-
Support Tickets
-
Operational Metrics
-
Risk Assessments
-
Forecasting Models
-
Compliance Reports
-
Audit Trails
-
Shipping and Fulfillment
-
External Reference Data
Features
SQL Access via ODBC: Query OneLake from Qlik, Tableau, Logi Symphony, Python, and more SQL-based applications through ODBC interface.
ODBC 3.8 Compliant: Provides 32- and 64-bit ODBC 3.8 compliant connectivity for Windows platforms.
Delta Lake Format Support: Native support for OneLake’s Delta Parquet format with V-Order optimization for improved performance.
Microsoft Entra ID Authentication: Integrates with enterprise identity providers and supports service principal authentication for automated scenarios.
Query Pushdown Optimization: Executes filters, joins, and aggregations at the OneLake level for maximum performance, reducing network traffic by up to 90%.
Secure Transport: TLS 1.2+ encryption with FIPS-ready encryption modules to protect data in flight.
High-Throughput Streaming: Efficiently streams large result sets with intelligent pagination to handle big data workloads.
Enterprise Licensing Options: Offers departmental, enterprise, and OEM licensing for commercial distribution—unlike Microsoft’s personal-use-only drivers.
Connection Pooling: Intelligent connection management and reuse supporting 40-60% more concurrent users.
SQL Access via ODBC: Query OneLake from Qlik, Tableau, Logi Symphony, Python, and more SQL-based applications through ODBC interface.
ODBC 3.8 Compliant: Provides 32- and 64-bit ODBC 3.8 compliant connectivity for Windows platforms.
Delta Lake Format Support: Native support for OneLake’s Delta Parquet format with V-Order optimization for improved performance.
Microsoft Entra ID Authentication: Integrates with enterprise identity providers and supports service principal authentication for automated scenarios.
Query Pushdown Optimization: Executes filters, joins, and aggregations at the OneLake level for maximum performance, reducing network traffic by up to 90%.
Secure Transport: TLS 1.2+ encryption with FIPS-ready encryption modules to protect data in flight.
High-Throughput Streaming: Efficiently streams large result sets with intelligent pagination to handle big data workloads.
Enterprise Licensing Options: Offers departmental, enterprise, and OEM licensing for commercial distribution—unlike Microsoft’s personal-use-only drivers.
Connection Pooling: Intelligent connection management and reuse supporting 40-60% more concurrent users.
Specifications
OneLake Compatibility: Fully compatible with Microsoft Fabric lakehouses and SQL Analytics Endpoints.
Delta Format Support: Native Delta Parquet with V-Order optimization support.
32- and 64-Bit Application Support: Works seamlessly with both 32-bit and 64-bit applications.
ODBC Compliance: Adheres to the ODBC 3.8 specifications for standardized database connectivity.
ANSI SQL Support: ANSI SQL-92 standard with T-SQL extensions.
Unicode Support: Full Unicode support for international character sets.
Authentication Methods: Microsoft Entra ID (Azure AD) with service principal support.
Encryption Standards: TLS 1.2+ with FIPS-validated cryptography options.
Supported OneLake File Formats: Delta Parquet (primary), with read capability for CSV, JSON, standard Parquet, AVRO stored in OneLake.
OneLake Compatibility: Fully compatible with Microsoft Fabric lakehouses and SQL Analytics Endpoints.
Delta Format Support: Native Delta Parquet with V-Order optimization support.
32- and 64-Bit Application Support: Works seamlessly with both 32-bit and 64-bit applications.
ODBC Compliance: Adheres to the ODBC 3.8 specifications for standardized database connectivity.
ANSI SQL Support: ANSI SQL-92 standard with T-SQL extensions.
Unicode Support: Full Unicode support for international character sets.
Authentication Methods: Microsoft Entra ID (Azure AD) with service principal support.
Encryption Standards: TLS 1.2+ with FIPS-validated cryptography options.
Supported OneLake File Formats: Delta Parquet (primary), with read capability for CSV, JSON, standard Parquet, AVRO stored in OneLake.