X

Best Practices from Oracle Development's A‑Team

Installing Oracle Analytics Cloud Remote Data Gateway

Last validated October 17, 2019 with OAC 5.4 and RDG 5.4

Introduction

This post is a step-by-step guide describing the common installation tasks for Oracle Analytics Cloud (OAC) Remote Data Gateway (RDG) 

The official documentation is  Connect to On-premises Data Sources and Known Issues.

This post is used by the scenarios noted in the companion blog Deploying Remote Data Gateway in Oracle Analytics Cloud for Data Visualization

Updates

Published on October 15, 2019

Versions

  • Oracle Analytics Cloud version 105.3.x, 105.4x

  • MacBook Pro OS 10.13.6 

  • Windows Server R12 Compute Instance

  • Linux 7.2 Compute Instance

Topics

  • Before You Begin

  • Installing Remote Data Gateway

 Before You Begin

Reviewing Supported Operating Systems

  • Ensure your operating system is supported by viewing the list at OAC Downloads.

Common Prerequisites

Installing RDG requires the following common items:

  • All Platforms

    • Credentials and Privileges to install software on the RDG host.

    • Database connection information and credentials for validating the installation.

  • For Linux and Windows Servers

    • The IP address or host name where RDG is to be installed.

  • For Linux

    • A Graphical User Interface or alternatives such as VNC and X11

  • For Windows

    • The Microsoft Remote Desktop (RDP) utility if accessing remote Windows servers.

 Installing Remote Data Gateway

The steps for all platforms are documented in Install Data Gateway.

Topics

  • Installing RDG on Windows

  • Installing RDG on MAC

  • Installing RDG on Linux

  • Installing Additional RDG Agents on Linux

Installing RDG on Windows

Connect to the RDG host via RDP if necessary.

There is not a standalone installer. Extract the contents of the downloaded ZIP file to a desired directory.

Installing RDG on MAC-OS

Unpack the ZIP file contents to the /Application folder.

Installing RDG on Linux

Installing Remote Data Gateway on Linux requires a GUI. If the host does not have one, consider installing the X11 system. Pointers can be found in Preparing Linux for Oracle Remote Data Gateway.

If using X11

Start the X11 server on your client machine e.g. XQuartz on Mac or XMing on Windows

Connect to the RDG host e.g. using SSH

Examples:

ssh -i < private key path > <user>@< IP address or host name >

If using X11:

ssh -X -i < private key path > <user>@< IP address or host name >

Unzipping the RDG Download

These steps assume the installer was downloaded or uploaded to the /tmp directory.

mv /tmp/<name of installer>.zip> ~

cd ~

unzip <name of installer>.zip

Making the RDG Installer Executable

If necessary,

chmod 777 <name of bin file>.bin

Running the Installer

./<name of bin file>.bin

Waiting for and Using the Installer GUI

Accept the defaults for the Installation Inventory Setup and click OK.

If a Welcome dialog is displayed, click Next.

At the Installation Location dialog, choose an unused location and click NextNote: The installer creates the directory if it does not exist.

At the Select Remote Data Version dialog, select Remote Data Gateway and click Next.

At the Agent Configuration Credentials dialog, specify a username and password to use for logging into the Data Gateway Agent Configuration page and click Next.

At the Installation Summary dialog, click Install.

After the Installation Progress screen completes, click Next.

At the Installation Complete dialog, click Start Jetty and then click Finish.

Validating the Linux Installation and Obtaining the Port and the URL

Return to the SSH session and type the status command. Make a note of the HTTP Port and the URL for use in configuring RDG

/home/opc/Oracle/Middleware/<Install Directory>/domain/bin/status.sh

Installing Additional RDG Agents on Linux

If additional agents are desired on the same Linux host, rerun the installer and choose a different installation location. This spawns another agent process using a different HTTP port.

 Summary

This post described the common installation tasks for Oracle Analytics Cloud (OAC) Remote Data Gateway (RDG).

RDG is now ready for the scenario-specific pre-configuration steps described in the various scenario-specific posts.

For other posts relating to analytics and data integration visit http://www.ateam-oracle.com/dayne-carley

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha