Interface-Hero-Background

Microsoft SQL Server JDBC Driver

Microsoft Azure SQL Database logo

Select your platform

Table of Contents:

    Overview

     Progress DataDirect’s JDBC Driver for SQL Server offers a high-performing, secure and reliable connectivity solution for JDBC applications to access SQL Server data. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as SAS, Yellowfin, SAP, Sisense, Denodo, Cognos, Jaspersoft, Tableau, Tibco, OBIEE, and more.

       
    • 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

    Features

    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.

    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)

    Support for Advanced Azure features

    Our SQL Server ODBC driver supports authentication via Azure Active Directory (AD). Azure AD authentication is an alternative to SQL Server Authentication for Azure SQL Database that allows you to centrally manage identities of database users 

    Support for Always On Feature for Availability Groups

    Introduced in SQL Server 2012, Always On Availability Groups is a replica-database environment that provides a high-level of data availability, protection, and recovery.

    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.

    High-performing Type 5 JDBC Driver

    Type 5 JDBC drivers offer the same client-side, single-tier, 100% Java architecture of Type 4 JDBC drivers, but address the limitations of many of the Type 4 JDBC drivers. Unlike a type 4 JDBC driver, our type 5 JDBC driver maximizes data throughput while using minimal amount of CPU and memory resources. You can learn more over here

    Codeless Bulk Load / Export

    Progress DataDirect JDBC drivers support bulk load through JDBC batch inserts or the DDBulkLoad object. This means existing applications, such as Apache Sqoop, can get bulk insert performance without any code changes or external tools such as bcp for SQL Server or SQL*Loader for Oracle. Refer to this blog for more details.

    Technical Specifications

    Progress DataDirect Connect for JDBC SQL Server Driver
    Version 6.0.0

    Database Support

    • Microsoft SQL Server
      • Microsoft SQL Server 2017 and higher
      • Microsoft SQL Server 2016 and higher
      • Microsoft SQL Server 2014 and higher
      • Microsoft SQL Server 2012 and higher
      • Microsoft SQL Server 2008 and higher
      • Microsoft SQL Server 2005 and higher
    • Microsoft Azure Synapse Analytics
      • Microsoft Windows Azure SQL Database Version 12.0 and higher
      • Microsoft Windows Azure SQL Database Version 11.0 and higher
      • Microsoft Azure Synapse Analytics version 12 and higher
    • Microsoft Analytics Platform System
      • Microsoft Analytics Platform System, version 10 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.

    Documentation

    Progress DataDirect for JDBC for SQL Server Driver
    Version 6.0.0

    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