DataDirect Connectors  Powerful SQL Server ODBC driver

Microsoft_SQL_server
  • Bulk data movement increases performance without changing any code
  • Use one ODBC driver for all versions of SQL that works across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX
  • Get high availability via failover and workload balancing using our certified ODBC Driver for SQL Server
Table of Contents:

    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 upto 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 and Connect64 for ODBC SQL Server Wire Protocol Driver
    Version 7.1.6 
    (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 SQL Server 2000 and higher
    • Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 5.3 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 and higher
    • Debian Linux x86, version 7.0 and higher
    • Oracle Linux x86, version 4.0 and higher
    • Red Hat Enterprise Linux x86, version 4.0 and higher
    • SUSE Linux Enterprise Server Linux x86, version 10 and higher
    • Ubuntu Linux x86, version 14.04 and higher

    Linux on System Z (64-bit only)

    • CentOS Linux x64, version 4.0 and higher
    • Oracle Linux x64, version 4.0 and higher
    • Red Hat Enterprise Linux x64, version 4.0 and higher
    • SUSE Linux Enterprise Server Linux x64, version 10 and higher

    Solaris (32- and 64-bit)

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

    Windows (32- and 64-bit)

    • Windows (x86), version 7 and higher
    • Windows Server (x86), version 2003 and higher
    • Windows Vista (x86)
    • Windows XP Professional (x86), SP2 or higher

    Driver/Client Software Requirements

    • No Requirements

    Documentation


    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.


    Tutorials

    SQL Server ODBC Driver for Linux

    Tutorial

    SQL Server ODBC driver on Linux : Quick Start Guide

    This tutorial walks you through on how you can connect to SQL Server database from Linux machine using a Progress DataDirect SQL Server Wire protocol ODBC driver. We drafted a step-by-step guide to:
    1. install our SQL Server ODBC Driver on a Linux machine
    2. Configuring the driver
    3. Testing the connection

    Read the Tutorial


    SQL Server ODBC Driver to Oracle Gateway

    Guide

    Use DataDirect SQL Server ODBC Driver to Connect to Oracle

    In this installation guide, we show the configuration of the Database Gateway for ODBC on a Sun Solaris system using SQL Server ODBC driver to connect to Microsoft SQL Server 2008. 

    Download the Guide





    SQL Server and IBM Cognos ODBC Connectivity

    Testimonial

    IBM Recommends our SQL Server ODBC driver on Linux / Unix

    IBM recommends Progress® DataDirect® SQL Server ODBC Driver to connect IBM Cognos BI Server with SQL Server. The following tutorial will help you get connected from a Unix / Linux based system. With some minor changes, similar steps should let you connect to any system including Windows, Solaris, AIX or HP-UX.

    Download the Tutorial

    Videos

    Quick Video for installing DataDirect ODBC Driver on Windows

    If you have are working on windows, these videos can help you install our ODBC driver on your windows machines. These steps are valid for our SQL Server ODBC Driver as well.



    Quick Video for installing DataDirect ODBC Driver on Unix / Linux

    If you are working on a Unix / Linux system, these videos can help you install our ODBC driver on your machines whether it is Unix, Linux, AIX, Solaris or HP-UX. These steps can be used to install our SQL Server ODBC driver as well.




    Related Resources

    SQL Server Solutions

    Solution Page

    Learn What DataDirect can do for your SQL Server Shops

    Progress DataDirect is the trusted name in data connectivity for Microsoft SQL Server Ecosystems. Learn how to securely bind your sql server to SaaS, Relational, NoSQL and Big Data Sources using our certified ODBC, JDBC and ADO.NET Drivers and the OData API.

    SQL Server Solutions


    SQL Server ODBC Driver Case Study - Toyota

    Case Study

    Toyota Saved $100,000 using ODBC drivers for SQL Server, Oracle and DB2

    When Toyota Motor Sales introduced Progress DataDirect for ODBC to their intricate data architecture, they saved $100,000 in 24 hours. Learn more in this case study about how they were able to use our SQL Server ODBC Driver and other drivers to provide out-of-the-box connectivity to all major databases

    Toyota Case Study


    bg-air-dci-revamp
    Microsoft SQL Servers Connectors are Part of Progress Data Connectivity & Integration Solutions
    icon-info-b

    DataDirect Connectors

    Connect any data source to any application

    icon-contact-us-b

    Contact Us

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