Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

arali
‎02-19-2026 04:00 PM

Microsoft ODBC Driver for Microsoft Fabric Data Engineering (Preview)

ODBC (Open Database Connectivity) is a widely adopted standard that enables client applications to connect to and work with data from databases and big data platforms.

The Microsoft ODBC Driver for Microsoft Fabric Data Engineering (Preview) – an enterprise-grade connector that brings powerful, secure, reliable and flexible Spark SQL connectivity to your .NET, Python, and other ODBC-compatible applications and BI tools, all through Microsoft Fabric’s Livy APIs.

Why this matters

As organizations increasingly rely on Apache Spark for scalable data engineering and analytics, seamless integration with enterprise platforms is critical. The new Microsoft ODBC Driver for Microsoft Fabric Data Engineering empowers developers, data engineers, and administrators to connect, query, and manage Spark workloads in Microsoft Fabric with the reliability and simplicity of the ODBC standard.

Screenshot_of_ODBC_Data_Source_Administrator_window_showing_System_Data_SourcesScreenshot_of_ODBC_Data_Source_Administrator_window_showing_System_Data_Sources

Figure 1- The animated GIF demonstrates how to get started using ODBC driver

Since this driver has been specifically designed and developed for Fabric Data Engineering, it has deep integration with lakehouse for data access in OneLake, allows using an environment item during execution of your jobs as well as allows different Spark configurations based on your unique needs.

Key Features

  • ODBC 3.x Compliant: Full implementation of ODBC 3.x specification
  • Microsoft Entra ID Authentication: Multiple authentication flows including Azure CLI, interactive, client credentials, certificate-based, and access token authentication
  • Spark SQL Query Support: Direct execution of Spark SQL statements
  • Comprehensive Data Type Support: Support for all Spark SQL data types including complex types (ARRAY, MAP, STRUCT)
  • Session Reuse: Built-in session management for improved performance
  • Large Table Support: Optimized handling of large result sets with configurable page sizes
  • Async Prefetch: Background data loading for improved performance
  • Proxy Support: HTTP proxy configuration for enterprise environments
  • Multi-Schema Lakehouse Support: Connect to specific schema within a Lakehouse
The Microsoft ODBC Driver for Microsoft Fabric Data Engineering is designed to accelerate your Spark-powered data engineering projects with enterprise-grade security, reliability, and performance.

Next steps

We invite you to try it out, share your feedback, and unlock new possibilities for analytics and integration in Microsoft Fabric.

To download and learn more about the Microsoft ODBC Driver for Microsoft Fabric Data Engineering, please refer to official documentation: Microsoft ODBC Driver for Microsoft Fabric Data Engineering.

0