X

Best Practices from Oracle Development's A‑Team

Completing the Deployment of Remote Data Gateway for Oracle Analytics Cloud

Validated on February 14, 2020 for OAC 5.5 and RDG 5.5

Introduction

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

 Validations

  • February 14, 2020 for OAC 5.5 and RDG 5.5

  • October 15, 2019 for OAC 5.4 and RDG 5.4

Versions

  • Oracle Analytics Cloud version 105.3.x, 105.4x, 105.x

  • MacBook Pro OS 10.13.6 

  • Windows Server R12 Compute Instance

  • Linux 7.2 / 7.7 Compute Instance

  • Oracle 12c Database

Topics

  • Before you Begin

  • Enabling the Remote Data Gateway in OAC

  • Configuring the Remote Data Gateway Agents

  • Validating OAC Remote Data Access

 Before You Begin

Reviewing Supported Operating Systems

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

Prerequisites

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

 Enabling the Remote Data Gateway in OAC

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 the Remote Data Gateway Agents

Configuring a Remote Data Gateway Agent requires navigating between the OAC Remote Data Connectivity console and the Remote Data Gateway Agent console.

Starting the RDG Configuration Utility

MAC

Start the RDG i.e. Oracle Analytics Data Gateway.app from the Applications folder.

Windows

Connect with RDP if necessary. Start RDG i.e. datagateway.exe from the installation directory.

Linux

Starting the RDG Configuration Utility requires browser access to the RDG host and port. 

Start the SSH Local Port Forwarding

ssh RDG-HOST

Test if Access is Available

Use a browser and the following URL:

http://localhost:<Your RDG HTTP port>/obiee/javads?status

If successful, an XML response is returned.

Start the configuration

http://localhost:<Your RDG HTTP port>/obiee/config.jsp

Obtaining the OAC URL

From the OAC instance. Copy the URL up to the end of the host name

e.g. < instance >-<tenancy>.analytics.ocp.oraclecoud.com

Creating an RDG Agent 1 of 2

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 configuration screen as is and switch over to OAC,

Registering the Data Gateway Agent in OAC

Go to the OAC Remote Data Connectivity page in OAC.

  • Click Add.

  • Optionally enter a Name or one is created for you. Paste the key generated from the Agent definition screen into the Public Key. Note that the ID and Host are populated from the key contents. Click OK.

  • The agent is registered.

Creating an RDG Agent 2 of 2

Return to the configuration utility.

  1. Click Test. A Successfully authenticated message appears.

  2. Click Save. A Successfully Submitted message appears

  3. Click Enable.

​​​ Validating OAC Remote Data Access

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.

 Summary

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

 

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