Connect to On-premises Data Sources Using Data Gateway
You use Data Gateway to connect to remote on-premises 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.
Sizing Data Gateway
Ask your sales account team for guidance on sizing 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 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. | |
Status | Review the status of remote connection database requests between an agent and the remote database. | |
Logs | Display logging information for recent Data Gateway traffic, and enable and disable log polling. | |
Query | Execute SQL queries to test the connection between the Data Gateway agent and the remote database. |
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 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 "Remote Data Connectivity" listed under Connectivity Options for Datasets, Semantic Modeler, or Model Administration Tool in List of Supported Data Sources in Oracle Analytics Cloud.
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.