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 describing the common installation tasks for Oracle Analytics Cloud (OAC) Remote Data Gateway (RDG).
For Linux, it details the steps for using the installer with a GUI.
Note: Refer here for a post on installing RDG silently on Linux without a GUI.
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 22, 2020 with RDG 5.8
July 22, 2020 with RDG 5.7
February 13, 2020 with OAC 5.5 and RDG 5.5
October 15, 2019 with OAC 5.4 and RDG 5.4
Before You Begin
Installing Remote Data Gateway
Ensure your operating system is supported by viewing the list at OAC Downloads.
Installing 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.
A Graphical User Interface or alternatives such as VNC and X11 for a standard installation.
Follow the steps in Preparing SSH Tunneling for Oracle Analytics Cloud Remote Data Gateway in a Private Subnet to setup your SSH configuration file for access to the RDG Host. This post assumes the SSH client configuration file has an entry named RDG-Host.
The Microsoft Remote Desktop (RDP) utility if accessing remote Windows servers.
scp <Path to Installer Zip File> RDG-Host:/home/opc or
scp <Path to Installer Zip File> RDG-Host:"c:\users\opc"
Copy or use a shared folder for the installer.
Installing RDG on Windows
Installing RDG on MAC
Installing RDG on Linux
Installing Additional RDG Agents on Linux
There is not a standalone installer. Extract the contents of the downloaded ZIP file to a desired directory.
If using RDP, connect and unzip the installer
If using SSH,
ssh RDG-Host Expand-Archive datagateway-windows-105.5.zip
Unpack the ZIP file contents to the /Application folder.
Remote Data Gateway may be installed on Linux with or without a GUI. This post focuses on the GUI and uses X11. If the host does not have one, consider installing the X11 system. Pointers can be found in Preparing Linux for Oracle Remote Data Gateway.
Start the X11 server on your client machine e.g. XQuartz on Mac or XMing on Windows
ssh RDG-HOST unzip < Path to Installer Zip File >
ssh RDG-HOST chmod 774 <name of bin file>.bin
ssh -Y RDG-HOST ./<name of bin file>.bin
Use the status command and make a note of the HTTP Port and the URL for use in configuring RDG
ssh RDG-Host <Install Directory>/domain/bin/status.sh
Additional RDG installations in different availability domains are recommended for High-Availability (HA) requirements.
"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.
This post described the common installation tasks for Oracle Analytics Cloud (OAC) Remote Data Gateway (RDG).
RDG is now ready for configuration. Refer here for details.
For other posts relating to analytics and data integration visit http://www.ateam-oracle.com/dayne-carley