datadirect-connectors-head-banner

Powerful JDBC Driver for Microsoft Azure Synapse Analytics (formerly Microsoft Azure SQL Data Warehouse) 

SQL_azure

Includes:

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

Table of Contents:

    Overview

    • 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)

    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.

    Documentation

    Progress DataDirect for JDBC for SQL Server Driver
    Version 6.0.0


    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.


    Related Resources

    Webinar

    Making the Leap: Best Practices for Connecting to Your Cloud Data Warehouse

    Companies are relying more and more on cloud-based data warehousing as a solution to some of the critical needs of today’s digital business world. See how Progress DataDirect Connectors for Cloud Data Warehouses can help you access and analyze the data from cloud data warehouses at the speed of business.

     

     

    Watch Webinar

    Paper

    Accelerate Your Cloud Data Warehouse Productivity

    Enterprises are increasingly migrating to cloud data warehouses but the value of these cloud data warehouses is ultimately limited by how quickly you can access the data within them. See how Progress DataDirect connectors for cloud data warehouses solve that challenge and provide you with secure data access at the speed of business.

    Download Paper

    Customer Success Stories

    Success Story

    Unisys

    Unisys Global Media embeds DataDirect Technologies’ wire protocol ODBC driver for Oracle within Hermes, its news content manager. As a result, Unisys customers have fast-to-the-wire access to Oracle databases and seamless integration between Unisys' editorial solutions and their existing databases and software packages.

    Learn More

    Connect any application to any data source anywhere

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