The latest releases of Oracle Analytics Cloud (OAC) now include the new Remote Data Gateway (RDG) for accessing databases that are not otherwise accessible by OAC.
This post is a step-by-step guide to installing gateway agents and creating Data Visualization connections using RDG.
For tips on using RDG connections with the Oracle Developer Client Tool, visit Deploying Remote Data Gateway in Oracle Analytics Cloud for Metadata Repositories.
Published on July 9, 2019
For this post, deploying RDG requires the following:
Ensure your data source is supported by following the instructions in Supported Data Sources.
Navigate to https://www.oracle.com/technetwork/middleware/oac/downloads/index.html, accept the license agreement, and choose the desired platform(s). This post used all three platforms (MAC, Linux, and Windows)
Note: If you are using a Linux instance that does not have a browser, you may download the Linux installer to your client machine and then upload it to your Linux instance. To upload to a Linux compute instance, SCP the installer using the following:
scp -i < private key path > <path to installer file> opc@< IP address or host name >:/tmp
The steps for all platforms are in Install Data Gateway.
Installing RDG on Windows
Installing RDG on MAC
Installing RDG on Linux
There is not a standalone installer. Extract the contents of the downloaded ZIP file to a desired directory.
Unpack the ZIP file contents to the /Application folder.
Installing Remote Data Gateway on Linux requires a graphical user interface. If necessary, refer to http://www.ateam-oracle.com/preparing-linux-for-oracle-remote-data-gateway for pointers. This post assumes that X11 is configured on a Linux instance and an X11 Server is installed on the client machine. This post uses MAC-OS and the XQuartz X11 Server.
Use Finder to open the Applications>Utilities folder and double-click XQuartz. An xterm window opens on the MAC.
Now this terminal session or another remote terminal session can be used to SSH into the Linux instance to run an X11 application.
Use the SSH utility with the -X option to set up an X11 tunnel session on the Linux instance. Connect as the opc user. This requires the IP address / host name of the instance and the private key. The SSH syntax is:
ssh -X -i < private key path > opc@< IP address or host name >
These steps assume the installer was downloaded or uploaded to the /tmp directory.
chmod 777 datagateway-linux64-105.3.bin
It may take up to a minute before the installer screen appears.
Return to the SSH session and type the status command. Make a note of the HTTP Port and the URL for use in the next section.
Log into OAC. From the home page, navigate to the DV Console:
Click the Hamburger icon.
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.
Start RDG i.e. datagateway.exe from the installation directory.
Starting the RDG Configuration Utility requires browser access to the RDG host and port noted above. If the client running the browser is in the same network as the RDG server this should not be an issue.
To test if access is available, use a browser and the following URL:
http://<Your RDG host name/IP>:<Your RDG HTTP port>/obiee/javads?status
If successful, an XML response is returned.
If you need to open the HTTP port, refer to http://www.ateam-oracle.com/opening-ports-in-linux-7-firewalls-for-oracle-analytics-cloud-access-to-databases-and-remote-data-connector for guidance.
Use the URL noted in the installation section above to start the RDG Configuration Utility.
http://<Your RDG host name/IP>:<Your RDG HTTP port>/obiee/config.jsp
Log into 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.
Leave the configuration screen as is and switch over to OAC,
Go to the OAC Remote Data Connectivity page in OAC.
Return to the configuration utility.
Repeat the above steps to create additional agents on other platforms. Additional agents prevent a single point of failure. Deploying multiple agents may also improve performance.
With the agent(s) configured and running, creating a new DV data connection validates that RDG is configured correctly.
You can now create DV Data Sets and projects using the remote data source.
This post described installing and configuring Remote Data Gateway agents and creating Data Visualization data connections using remote data sources.
For other posts relating to analytics and data integration visit http://www.ateam-oracle.com/dayne-carley