Patent ID: 11899679
Assignee: ORACLE INTERNATIONAL CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G  H | IPC G  H

Claim 5:
6. A method for providing a remote data gateway for use with a data analytics environment, comprising:
providing, at a computer including one or more processors, an analytics environment that provides access to a data warehouse for storage of data, wherein the analytics environment comprises a remote data gateway server that operates to receive, from one or more remote data gateway clients, queries directed to an on-premise database provided at a remote network other than the analytics environment at which the remote data gateway server operates; and
communicating by the analytics environment with a data gateway agent at the remote network that channels database queries received at the analytics environment and directed to the on-premise database, including that:
the remote data gateway server at the analytics environment queues the queries that are received from the remote data gateway clients and are directed to the on-premise database;
the remote data gateway agent provided at the remote network connects periodically, via a load balancer, to the remote data gateway server at the analytics environment to check for queries that are received from the remote data gateway clients and are queued at the remote data gateway server, to process;
the remote data gateway server assigns, to the remote data gateway agent, a pending job from a queue of pending jobs maintained by the remote data gateway server;
the remote data gateway agent provided at the remote network, in response to receiving the job from the remote data gateway server, connects to the on-premise database, and executes received queries as indicated by the job against the on-premise database; and
the remote data gateway agent provided at the remote network returns query results to the analytics environment for use by the remote data gateway clients.