Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for Salesforce offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Salesforce data. Our ODBC driver can be easily used with SQL 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 Salesforce Bulk API for large data volumes
    • Implement a client-side data cache for improved performance
    • Engage in multiple, simultaneous sessions

    What's Included

    • Salesforce API
    • FinancialForce
    • Veeva CRM
    • Any Salesforce AppExchange app
    • ServiceMax
    • Salesforce Service Cloud

    Features

    Support for Salesforce Bulk API for Bulk Load

    Uses the Salesforce Bulk API for inserts, updates, and deletes based on the configurable values of the Bulk Load Threshold connection option. This allows users to work with large sets of data, connecting to more data faster. 

    Support for Salesforce Bulk API for Bulk Fetch

    Uses the Salesforce Bulk API while performing selects based on the configurable values of the Bulk Fetch Threshold connection option. This allows users to fetch very large result set faster.

    Built-in Caching

    Implement a client-side data cache on a per-table basis, as opposed to results from specific queries. Caching data on a table level allows the caches to be queried, filtered, and sorted in other queries.

    OAUTH 2.0 Support

    Authenticate users without providing user credentials using secure OAUTH 2.0 protocol, thus eliminating the risk of unauthorized access.

    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.

    Technical Specifications

    All 32-bit versions of this driver are part of the Connect XE for ODBC Series. All 64-bit versions are part of the Connect64 XE for ODBC Series.

    Progress DataDirect for ODBC for Salesforce Driver Version 8.0.0
    (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

    Version Support

    • Salesforce API
    • Any Salesforce AppExchange app
    • FinancialForce
    • Salesforce Service Cloud
    • ServiceMax
    • Veeva CRM

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 5.3, 6.1, 7.1 and higher

    HP

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

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

    • 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

    Solaris (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

    • Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

    Customer Success Stories

    SS_MicroStrategy

    Success Story

    microstrategy-min Keeping the Commitment to Winning Design Analytics Principles 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