Connect to On-premise Data Sources Using Data Gateway

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

Installing Data Gateway Agent

You can install Data Gateway on Linux or Windows platforms. See Install or Upgrade Data Gateway.

Get Started with Data Gateway Agent

Data Gateway Agents enable you to use Oracle Analytics Cloud to visualize and model data in remote databases. You deploy Data Gateway in a subnet that gives visibility to both Oracle Analytics Cloud and the remote databases.

When you start a Data Gateway agent, you see the Home page. Click the Navigator to access the other Data Gateway agent pages using the navigator menu.
Description of navigator-menu-data-gateway.png follows
Description of the illustration navigator-menu-data-gateway.png

Navigator Option Description Find Out More
Home Display the Home page, where you can configure the agent, enable or disable the agent, and test the agent's connection.

Configure Data Gateway for Data Visualization

Configure and Register Data Gateway for Reporting

Status Review the status of remote connection database requests between an agent and the remote database.

Diagnosing Connection Issues Using The Status Page

Logs Display logging information for recent Data Gateway traffic, and enable and disable log polling.

Diagnosing Connection Issues Using The Logs Page

Query Execute SQL queries to test the connection between the Data Gateway agent and the remote database.

See Diagnosing Connection Issues Using The Query Page.

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) and 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 connection.

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 Semantic 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 can also improve performance. When you register an agent using the Data Gateway agent Configuration dialog, note the following:

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