DataDirect Connectors SQL Server ODBC Driver for Quick and Powerful Data Access

Microsoft_SQL_server
Economical

Bulk data movement increases performance without increasing costs

Versatile

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

Reliable

Get high availability via failover and workload balancing using our certified ODBC Driver for SQL Server

Features

connectivity

Broad Coverage

Single or cross realm Kerberos and NTLM authentication are supported across all platforms, even Unix/Linux, AIX, HP-UX and Mainframes
fast

Speed

Easily load large volumes of bulk data without application code or additional tools that slow performance
quality_reliability

Quality

Certified DataDirect ODBC driver quality guarantees Microsoft SQL Server and application compatibility
confident

Confidence

Ensures high availability via application failover and workload balancing without changing application code
codeless_implementation

Migrate Seamlessly

Migrate your application to Unix / Linux, AIX or Solaris while maintaining SQL Server connectivity and Windows authentication integration
codeless_implementation

Codeless Implementation

Optimize performance and compatibility with any application without application changes

Technical Specs

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

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.

Learning & Support

SQL Server ODBC Installation for Windows

Video

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.



SQL Server ODBC Installation for Unix / Linux

Video

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.



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


SQL Server and IBM Cognos ODBC Connectivity

Tutorial

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


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 ODBC, JDBC, OData & ADO.Net

PAPER

Data Access to SQL Server Linked Servers and BI Suite

This paper is a quick guide to help you understand how SQL Server ODBC Driver and other drivers can be used to boost the capabilities of your SQL Server BI Suite. It describes each SQL Server BI Solution - SSAS, SSIS and SSRS - and which SQL Server Driver to use for optimum results. 

Download the Paper

Partnerships

hp
tableau
voltDB

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