Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for Microsoft Azure SQL Database offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Microsoft Azure SQL Database. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.

    • Use the bulk capabilities when uploading large volume of data involving no application code changes
    • Use secure Active Directory authentication using Azure AD User or using the Access Token
    • Secure sensitive data using column encryption

    Features

    Support for Bulk Upload

    Load large amounts of data to the database faster. When the Enable Bulk Load option is on, the driver uses the database bulk protocol when an application executes an Insert with multiple rows of parameter data.

    Support for Always Encrypted

    Store sensitive data on the server in an encrypted state. The driver transparently decrypts data from encrypted columns and returns them to the application. This reduces exposure of potential vulnerabilities, including server-side security breaches.

    Support for High Availability

    Parallel connections to all failover IP addresses in an Availability Group when the connection is broken, or the listener IP address is unavailable. The first IP address to successfully respond to the request is used for the connection.

    Support for Secure Authentication Mechanism

    Supports secure Azure Active Directory authentication using Azure AD credentials or a generated Access Token

    Security and Compliance

    Protect customer-sensitive data elements (including remote credential or database pairings stored) with encryption, both at rest (AES-256) and in transit (SSL/TLS).

    Cross-platform Support

    Use one ODBC driver for all versions of SQL across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX - to maximize development resources.

    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