DataDirect Connectors REST API (OData) for IBM DB2

IBM_DB2
  • Produce OData (standard REST API) from DB2 for connectivity from cloud, mobile and BI apps
  • Expose and create OData entry points to IBM DB2 across Mainframe, iSeries, UNIX, Windows
  • User can connect desktop or mobile analytics tools and applications over web services
Table of Contents:

    Features

    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
    Secure

    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.

    Throttling

    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

    Database Support

    • DB2 V8.x for Linux, UNIX, Windows and higher
    • DB2 V8.1 for z/OS and higher
    • DB2 UDB V8.1 for z/OS
    • DB2 i 6.1 and higher
    • DB2 for i 5/OS V5R4 and higher

    Interface Support

    • OData 4.0 and 2.0 (read/write)
    • Certified and tested with Salesforce Connect, Tableau and PowerBI

    Platform Support

    • Web, Mobile or OData enabled client applications or frameworks

    Documentation

    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 https://en.wikipedia.org/wiki/CVSS.


    Related Resources

    ibm_db2_odata

    IN THE SPOTLIGHT

    OData Community: OData for IBM DB2 on z/OS, iSeries, and LUW

    Understand the power of OData. This blog demonstrates how to securely produce OData from a DB2 instance behind the corporate firewall.

    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

    bg-air-dci-revamp
    IBM DB2 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