Azure Synapse Analytics JDBC Driver

Microsoft Azure Synapse Analytics logo

Select your platform

Table of Contents:


    • Bulk data movement increases performance without increasing costs
    • Significantly reduces the cost and time of deploying and maintaining applications
    • Single JAR for JDBC creates scalability and ease of deployments

    What's Included

    • Microsoft SQL Server
    • Microsoft Analytics Platform System
    • Microsoft Azure Synapse Analytics
    • Big Data Clusters


    SQL Up Leveling/ Full ANSI SQL Support

    SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.

    Secure Active Directory Authentication Support

    Progress DataDirect SQL Server JDBC driver provides Secure way of authentication using Azure Active Directory. User can authenticate with Active Directory authentication using three different ways mentioned below:

    1. Using Azure AD UserID/Password
    2. Using an AccessToken
    3. Authenticating a Service Principal AD user using Service PrincipalID and Service PrincipalSecret

    Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant

    We keep our SSL version up to date. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy.

    Performance Tuning

    Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)

    TSANet Multi-Vendor Support Channel

    We live for your next big customer. Make sure your customers are successful with 24/7 partner support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.

    Day 1 Support for any new versions

    Day One Support for disruptive technologies with frequent release cycles. With this strategy - the first of its kind for any data connectivity provider - Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources.

    Cross-platform Support

    Use one ODBC driver for all versions of SQL that works across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX .

    Advanced Connection Pooling

    Connection pooling allows you to reuse connections rather than creating a new one every time the driver needs to establish a connection to the underlying database. The DataDirect Connect Series for ODBC drivers enable connection pooling without requiring changes to your client application.

    Technical Specifications

    Progress DataDirect Connect for JDBC SQL Server Driver
    Version 6.0.0

    Database Support

    • Microsoft Windows Azure SQL Database Version 12.0 and higher
    • Microsoft Windows Azure SQL Database Version 11.0 and higher
    • Microsoft Azure Synapse Analytics (formerly Microsoft Azure SQL Data Warehouse), version 12 and higher

    Platform Support

    • 32- and 64-bit platforms

    Software Requirements

    • Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.


    Progress DataDirect for JDBC for SQL Server Driver
    Version 6.0.0

    Customer Success Stories


    Success Story

    unisys-min DataDirect® Helps Unisys Customers Increase Efficiency and Reduce Production Costs Read story
    See all Success Stories

    Connect any application to any data source anywhere

    Explore all DataDirect Connectors

    A product specialist will be glad to get in touch with you

    Contact Us