Frequently Asked Questions about Data Gateway

What operating systems does Data Gateway support?

You can deploy Data Gateway on Linux and Windows platforms. For a full list of supported operating systems, see Download page for Oracle Analytics Cloud.

What is the Data Gateway architecture?

See Overview to Connecting to On-premises Data Sources.

Where do I install Data Gateway?

You install Data Gateway in a subnet that gives visibility to both Oracle Analytics Cloud and the target data sources. Your network needs to allow outbound traffic from the node where Data Gateway is installed to the public internet on port 443 so that Data Gateway can communicate with Oracle Analytics Cloud. In addition, the network needs to allow outbound traffic from the Data Gateway agent to the data source. For example, you might test the network by opening a browser on the node where Data Gateway is installed and connect to Oracle Analytics Cloud. You might also test the connection from the same node to the data source using a generic JDBC tool.

Can I deploy multiple Data Gateway agents?

Yes. You can configure multiple Data Gateway agents to service the same Oracle Analytics Cloud service instance. However, all of these agents must be capable of servicing all remote queries. In other words, you cannot configure one agent to service queries for one data source only, and another agent to service queries for a different data source. In addition, in server deployments you can have multiple Data Gateway agents on each node (physical or virtual). For high availability, Oracle recommends at least two Data Gateway agents (that is, on two virual machines) per Oracle Analytics Cloud instance.

How do I configure high availability for Data Gateway?

On the Oracle Analytics Cloud side, high availability is provided natively. On the Data Gateway side, you set up high availability by deploying two Data Gateways for each Oracle Analytics Cloud instance.

Why is Data Gateway traffic egress only?

Data Gateway regularly communicates with Oracle Analytics Cloud to see whether Oracle Analytics Cloud has queries that need processing, known as long-polling. Data Gateway makes a long-running Transport Layer Security-encrypted HTTP request to Oracle Analytics Cloud and waits until Oracle Analytics Cloud has a query to process. If there're no queries from Oracle Analytics Cloud after two minutes, Data Gateway terminates and re-issues the request in order to avoid termination by the network as an idle or stale connection.

How does Data Gateway manage SSL certificates?

The HTTPS communication between Data Gateway and Oracle Analytics Cloud leverages the SSL certificate of your Oracle Analytics Cloud service instance. The same certificate encrypts your browser connections to Oracle Analytics Cloud.

How do I size Data Gateway?

Ask your sales account team for guidance on sizing Data Gateway.

Where is Data Gateway running? Do I install it on a virtual machine (VM)?

At the Oracle Analytics Cloud end, Oracle Analytics Cloud manages the Data Gateway queue, therefore there's nothing additional to install.
At the data source end, the Data Gateway agent typically runs on a server or Virtual Machine next to the data source. You can also run Data Gateway from a laptop or a compute instance in the cloud, as long as Data Gateway can connect to the data source.

How is Data Gateway network traffic secured?

When you install and set up Data Gateway, you generate a public key. This public key is used in conjunction with the private key for Oracle Analytics Cloud to encrypt all communication between Oracle Analytics Cloud and Data Gateway. Data Gateway's security features prevent "replay attacks" and "man-in-the-middle" attacks. The Transport Layer Security 1.2 encryption deployed by the HTTPS connection provides a further layer of encryption.

Can Data Gateway limit queries that affect performance or security?

Data Gateway doesn't limit the query row size. The query row size limit is determined by the number of Oracle Compute Units (OCPUs) that your Oracle Analytics Cloud service has.

What is the timeout setting for Data Gateway?

Data Gateway uses the same query timeout as Oracle Analytics Cloud. See Limits Querying Data (Data Visualization Workbooks, Classic Analyses and Dashboards).