Oracle International Corporation

Sambit Kumar Nanda

Manish Barman

Alan Y Lee

Giri Jagumantri

Sunil Raj

In accordance with an embodiment, described herein is a system and method for providing a REST-based interface and connector for use with a data analytics environment, such as, for example, a business intelligence environment, database, data warehouse, or other type of environment that supports data analytics. A data analytics environment can expose a REST connector that can be configured via a user interface, to provide a connectivity layer that works with a range of REST implementations. A user can create and/or configure one or more connections, to support access to data provided by a variety of databases or data sources. The interface and connector establishes a connection to one or more REST endpoints which can be used to access and manipulate data from a variety of cloud applications and platforms, for example SaaS sources, for analytic workloads.

System and method for rest-based interface for use with data analytics environments

In accordance with an embodiment, described herein are systems and methods for providing a remote data gateway for use with an analytics environment, such as, for example, an Oracle Analytics Cloud environment, or a data warehouse or other type of analytics or computing environment. In accordance with an embodiment, the remote data gateway enables secure access by a data analytics warehouse operating in a cloud environment, to a customer's on-premise data, without migrating their on-premise data to the cloud. An on-premise data client exposes a port, which a data analytics remote data gateway server connects to, authenticates itself, and thereafter calls into the client periodically, via a remote data gateway agent, to check for subsequent requests, for example to provide on-premise data to the cloud environment, or to run data analytics on the on-premise data.

Remote data gateway for use with a data analytics warehouse

In accordance with an embodiment, described herein are systems and methods for providing a remote data gateway that supports peer routing for use with an analytics environment. In accordance with an embodiment, a data analytics remote data gateway server connects to on-premise data clients, via remote data gateway agents. If a remote data gateway server cannot reach a particular data client at its remote data gateway agent, then it can determine which other clients it can get requests from. To address this, the system can use a process of inverse proxy peer-to-peer routing&#x2014;if a client has a request to be processed, but the server has not yet called into that client, then the client can hand off the request to a peer remote data gateway server, and the server can retrieve/process that request from that server operating as a proxy.

Growing community of inventors

San Ramon, CA, United States of America

Sambit Kumar Nanda