Note: Private Access Channel is now available in Oracle Analytics and is recommended by Oracle for new connections to private data sources. For more information on the feature and the data sources it supports refer to:
Connect to Private Data Sources Through a Private Access Channel
Supported Data Sources
A-Team Chronicles Private Access Channel Series
This post is a step-by-step guide to completing the configuration and validation of Remote Data Gateway.
This post is used by the scenarios noted in the companion blog Deploying Remote Data Gateway in Oracle Analytics Cloud for Data Visualization
January 20, 2021 for OAC 5.9
October 12, 2020 for OAC 5.8
July 22, 2020 for OAC 5.7
May 20, 2020 for OAC 5.6
February 14, 2020 for OAC 5.5 and RDG 5.5
October 15, 2019 for OAC 5.4 and RDG 5.4
Before you Begin
Enabling the Remote Data Gateway in OAC
Configuring the Remote Data Gateway Agents
Validating OAC Remote Data Access
Configuring and Validating RDG requires the following common items:
Credentials and Privileges to install software on the RDG host.
The IP address or host name where RDG is to be installed.
An SSH client with a configuration file containing the RDG host and a bastion host if the RDG host is in a private subnet. A local port forwarding directive for the RDG HTTP port should exist in the file. Refer here for the steps to create the configuration file. Note: All SSH commands below use the configuration file.
The DB subnet must have a security list or Network Security Group rule allowing ingress via the DB Listening Port e.g. 1521, 1522
Log into OAC. From the home page, navigate to the DV Console:
Click the Hamburger icon.
Click Console.
Click Remote Data Connectivity
Click Enable Data Gateway
Configuring a Remote Data Gateway Agent requires navigating between the OAC Remote Data Connectivity console and the Remote Data Gateway Agent console.
Start the RDG i.e. Oracle Analytics Data Gateway.app from the Applications folder.
Connect with RDP if necessary. Start RDG i.e. datagateway.exe from the installation directory.
Starting the RDG Configuration Utility requires browser access to the RDG host and port.
ssh RDG-HOST
http://localhost:<Your RDG HTTP port>/obiee/javads?status
If successful, an XML response is returned.
http://localhost:<Your RDG HTTP port>/obiee/config.jsp
From the OAC instance. Copy the URL up to the end of the host name
e.g. < instance >-<tenancy>.analytics.ocp.oraclecoud.com
Once the various configuration utilities have been started, the GUI is the same for all.
Enter the OAC URL obtained above and click Generate Key
Copy the generated key to the clipboard
Leave the other fields blank unless you want to restrict the hosts that an agent can access or restrict the type of access.
Leave the configuration screen as is and switch over to OAC,
Go to the OAC Remote Data Connectivity page in OAC.
Click Add.
Paste the key generated from the Agent definition screen into the Public Key. Note that the Name, ID and Host are populated from the key contents. Optionally change the Name. Click OK.
The agent is registered.
Return to the configuration utility.
Click Test. A Successfully authenticated message appears.
Click Save. A Successfully Submitted message appears
Click Enable.
With the agent(s) configured and running, creating a new DV data connection validates that RDG is configured correctly.
Login or Go to the OAC home page
Click the Hamburger icon.
Click Data
Click Connections
Enter the required fields.
Check the Use Remote Data Connectivity box.
Click Save
You can now create DV Data Sets and projects using the remote data source.
This post described the common tasks necessary to complete the configuration and validation of Remote Data Gateway.
For other posts relating to analytics and data integration visit http://www.ateam-oracle.com/dayne-carley