REST API (OData) for MapR Hive

Overview

OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData offers full CRUD support with a standard convention for field selection, sorting, filtering, and other SQL functions via HTTP GET, POST, PUT, PATCH and DELETE requests.

Hybrid Data Pipeline allows you to easily expose your MapR Hive data via OData based RESTful API for data access, analytics and integration. Popularly referred to as the “SQL for the Web”, OData provides simple data access from any platform or device without requiring any drivers or client libraries. Seamlessly integrate your MapR Hive with popular applications such as Salesforce, Dynamics 365, Tableau, Power BI, Qlik and more that support OData.

• Leverage desktop or mobile tools and applications on MAPR Hive using OData - the standard for RESTful APIs
• Instantly connect popular OData consumers such as Salesforce, Oracle Service Cloud, or Tableau
• Provides highly secure access with user authentication, support for Hive Kerberos and SSL data encryption

Features

One-Click Docker Image

A docker image of Hybrid Data Pipeline Server has been made available for download to make it extremely simple for you to install and evaluate our offering. Quick Tutorial

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. Product has been architected to seamlessly integrate with both AWS load balancer and Azure load balancer.

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.

Support for Generic JDBC Driver (Beta)

In order to keep up with demand for new data sources, we have introduced the generic JDBC driver. This beta feature allows you to plugin your own JDBC driver into Hybrid Data Pipeline. If you'd like to enable this beta feature for your organization, please contact us.

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.

OAuth 2.0 and Other Authentication Systems

Hybrid Data Pipeline inherently supports OAuth 2.0 and Basic Authentication. It also offers an easy way to support other external authentication mechanisms so that enterprises can verify users against their in-house authentication systems that may be using LDAP system, Windows (Kerberos), SAML/ADFS 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

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