Enable your application to connect to Microsoft OneLake with the Simba ODBC driver, built for platforms that need to redistribute.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
