DataDirect Connectors  REST API (OData) for Oracle Database

  • Provision OData REST endpoints from any version of Oracle across 8i,9i,10g,11g,12c
  • Integrate cloud and mobile applications such as Salesforce Connect in real-time
  • Get interoperable data access using an ISO/IEC approved OASIS standard
Table of Contents:


    Lightweight Data Gateway

    Access back-office data behind the firewall securely using our patented on-premises connector that can be optionally deployed in the DMZ or behind the corporate firewall. Get trusted hybrid data access without requiring major network/firewall configurations such as setting up a VPN or SSH tunneling.

    Horizontal Scaling

    Hybrid Data Pipeline can be deployed in cloud and enterprise environments across multiple nodes behind a load balancer. Incoming requests can be evenly distributed across cluster nodes.

    Universal Connectivity

    Get real-time connectivity to the latest SaaS, SQL, Big Data and NoSQL data sources such as Salesforce, Apache Hive, Amazon Redshift, Oracle, SQL Server, IBM DB2, Eloqua, Google Analytics and more.

    SeeHide supported data sources

    All customer-sensitive data elements (including remote credential or database pairings stored) are protected by encryption, both at rest (AES-256) and in transit. Our encryption algorithms can be made FIPS-140 compliant using the FIPS Compliance mode (leverages Bouncy Castle as the security provider). Read our security paper.

    Integrate with Existing Authentication Systems

    Hybrid Data Pipeline supports external authentication through a configurable Java Plug-in. Enterprises can authenticate users against any of their in-house authentication systems that may be using LDAP system, Windows (Kerberos), SAML/ADFS authentication or any other authentication service. You can even group multiple external authentication users to map to one Hybrid Data Pipeline user to get access to data sources.


    Limits API allows administrators to set limits on how many rows can be returned for ODBC, JDBC, and OData requests. An error is returned if an application fetches rows beyond the specified limit.

    Support for OData 4 and OData 2

    You can deploy OData 4 or OData 2 or both the endpoints over any data source. Progress DataDirect is a member of the OData Technical Committee and we stay on top of the OData specification updates.

    Technical Specifications

    Progress DataDirect Hybrid Data Pipeline

    Version Support

    • Oracle 12c R1 (12.1) and higher
    • Oracle 11g R1 (11.1) and higher
    • Oracle 10g R1 (10.1) and higher
    • Oracle 9i R2 (9.2) and higher
    • Oracle8i R3 (8.1.7) and higher

    Interface Support

    • OData 4.0 and 2.0 (read/write)
    • Certified and tested with Salesforce Lightning Connect, Oracle Service Cloud

    Platform Support

    • Web, Mobile or OData enabled client applications or frameworks


    Progress Hybrid Data Pipeline 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

    Related Resources



    Integrate Oracle Systems with Salesforce using OData

    Are you struggling with integrating data in Oracle systems like Siebel and JD Edwards with Salesforce? All you need is Salesforce Connect and an OData connectivity solution. Real-time integration, not data duplication.

    Read Whitepaper



    Quickly Integrate Oracle Data with Salesforce Connect

    Salesforce Connect adds high-octane fuel to your integration strategy. Join us for an extensive webinar where we show you a faster, easier way to integrate Oracle and Salesforce with Salesforce Connect.

    Watch webinar

    Surfacing Metadata - OData vs GraphQL vs ORDS


    REST API Industry Debate: OData vs ORDS vs GraphQL

    This article compares standard APIs and services to query Oracle data over the internet for analytics, integration and data management.

    Read the Blog

    Expose OData

    Cloud Solutions

    Learn how we produce OData instantly

    Hybrid Connectivity Services will let you deploy OData (Standard REST) API for your data source through clicks-not-code. Learn more about how DataDirect’s Hybrid Connectivity Services can help you democratize your data in an age where data is siloed across many SaaS and On-Premises sources.

    Explore Hybrid Connectivity Services

    Oracle Database Connectors are Part of Progress Data Connectivity & Integration Solutions

    DataDirect Connectors

    Connect any data source to any application


    Contact Us

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