Overview - ODBC Driver for Azure Synapse Analytics

Overview

Devart ODBC Driver for Azure Synapse Analytics Server is a high-performance connectivity solution with enterprise-level features for accessing Azure Synapse Analytics (formerly Azure Azure Synapse Analytics Data Warehouse) databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows, macOS, and Linux. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy and secure access to live Azure Synapse Analytics Server data from anywhere.

Direct connection

Our data connector enables various ODBC-aware applications to establish a direct connection to AzureSynapseAnalytics via TCP/IP to eliminate the need for AzureSynapseAnalytics Сlient. Direct connection increases the speed of data transmission between an external application and AzureSynapseAnalytics for real-time analytics. It also streamlines the deployment process, since there is no need to distribute any additional client software with the driver.

Compatibility

ODBC Driver for Azure Synapse Analytics fully supports all data types and allows executing various Azure Synapse Analytics statements to read and modify data in Azure Synapse Analytics.