Table of Contents:

    Overview

    • Bulk data movement increases performance without increasing costs
    • Decrease maintenance and upgrade costs with one connector for all versions of SQL
    • Get high availability via failover and workload balancing

    What's Included

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

    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.

    Support for Advanced Azure features

    Our SQL Server ODBC driver supports connections to proxy server over HTTP and 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 

    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 and Connect64 for ODBC SQL Server Wire Protocol Driver
    Version 8.0.2
    (32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)

    ODBC Version Support

    • Compatible with ODBC 3.8 applications

    Database Support

    • Microsoft Azure Synapse Analytics
      • Microsoft Azure Synapse Analytics, version 12 and higher
        (Support introduced with driver version 07.16.0369 (B0372, U0245))
    • Microsoft Analytics Platform System
      • Microsoft Analytics Platform System, version 10 and higher
        (Support introduced with driver version 07.16.0369 (B0372, U0245))
    • Microsoft SQL Server Big Data Clusters
      • Microsoft SQL Server 2019 Big Data Clusters and higher
    • Microsoft SQL Server
      • Microsoft SQL Server 2019 and higher
      • 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 SQL Server 2000 and higher
      • Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
    • Microsoft Windows Azure SQL Database
      • Microsoft Windows Azure SQL Database Version 12.0 and higher
      • Microsoft Windows Azure SQL Database Version 11.0 and higher

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 5.3, 6.1, 7.1 and higher

    HP

    • HP-UX IPF, 11i version 2.0 (B.11.23) and higher
    • HP-UX PA-RISC (32-bit only), version 11 and higher

    Linux x86 (32- and 64-bit for AMD and Intel processors. 64-bit for Itanium II.)

    • CentOS Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • Debian Linux x86, version 7.0, 8.0 and higher
    • Oracle Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • Red Hat Enterprise Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • SUSE Linux Enterprise Server Linux x86, version 10, 11, 12, 15 and higher
    • Ubuntu Linux x86, version 14.04, 16.04, 18.04 and higher

    Linux on System Z (64-bit only)

    • CentOS Linux x64, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • Oracle Linux x64, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • Red Hat Enterprise Linux x64, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
    • SUSE Linux Enterprise Server Linux x64, version 10, 11, 12, 15 and higher

    Solaris (32- and 64-bit)

    • Solaris x86 version 10 (Solaris 5.10), 11 and higher
    • Solaris on SPARC, version 8 (Solaris 5.8), 9, 10, 11 and higher

    Windows (32- and 64-bit)

    • Windows (x86), version 7, 8.1, 10 and higher
    • Windows Server (x86), version 2008, 2012, 2016 and higher

    Driver/Client Software Requirements

    • No Requirements

    Customer Success Stories

    SS_Unisys

    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