Connect to On-premise Data Sources Using Data Gateway

You can use Data Gateway to connect to remote on-premise data sources from Oracle Analytics Cloud.

Connect to On-Premise Data With Data Gateway

There're two types of Data Gateway deployment:

  • Server - Install Data Gateway using the Oracle Universal Installer onto a Linux platform.
  • Personal - Install Data Gateway by copying the Data Gateway binaries onto a Windows or MacOS machine.

Data Gateway works in the same way for server and personal deployments, but there are differences in how you maintain and upgrade them.

Data Gateway Architecture

This diagram shows a typical architecture for a deployment of Data Gateway with Oracle Analytics Cloud. You install Data Gateway on a machine in the network where the data source is hosted and configure the Data Gateway agent for communication with your Oracle Analytics Cloud instance.
Description of dg_archit-png.png follows
Description of the illustration dg_archit-png.png

Data Gateway Functionality

Data Gateway agents poll Oracle Analytics Cloud for queries to run against your remote data sources. The results of these queries are returned to Oracle Analytics Cloud. For secure communication, Data Gateway traffic is signed with an encryption key and each packet is additionally encrypted by Transport Layer Security (TLS)/Secure Sockets Layer (SSL). You can use data from remote data sources in data flows. However, you can't save data to datasets using a remote connections.

Supported Operating Systems for Data Gateway

For a list of supported operating systems, see Download page for Oracle Analytics Cloud.

Supported Data Sources for Data Gateway

Look for databases with "Data Gateway" listed under "Connectivity options" in the "Use in Datasets" column or in the "Use in Data Models" column in Supported Data Sources.

Deploying Multiple Data Gateway Agents

You can deploy multiple Data Gateway agents so that there's no single point of failure. Deploying multiple Data Gateway agents might also improve performance if an agent is short of resources. When you register an agent using the Data Gateway Agent Configuration dialog, note the following:

  • You should configure each agent in the same way.
  • Each agent is capable of serving all remote queries. You can't target specific queries at specific agents.
  • If you leave the Allowed Hosts field blank, the agent tries to reach a data source on any host based on the connection information it retrieves from a connection in Oracle Analytics Cloud. If you specify hosts in the Allowed Hosts field, the agent can only address those hosts specified.

Using Legacy Remote Data Connector

Data Gateway replaces the Remote Data Connector utility that was used in earlier releases. Oracle recommends using Data Gateway for remote connections. See Install the Legacy Remote Data Connector.