Configuring Oracle Data Gateway (RDG) to create a connection to On Premise Database from OAC-DV

In this blog, I will be covering the detailed steps to configure Oracle Data Gateway to create a connection between OAC DV and On-Premise Database.

Oracle Analytics Cloud is a PaaS service which is hosted on Oracle's 2nd Gen Cloud called Oracle Cloud Infrastructure (OCI), which can connect 50+ data sources directly using inbuilt connectors example: ADW, ATP, Amazon Redshift, Google Cloud, Oracle Applications, etc. however in order to connect OAC to any on-prem database we need to create a proxy tunnel so that OAC can communicate to on-premise database, that is done via Oracle Remote Data Gateway.  

So let's start:

Prerequisites/Tools Required:

• Oracle Analytics Cloud instance 105.3.*
• Remote Datagateway installable file (based on your OS)

Step 1: Download the latest version of Oracle Data Gateway using the below link:
https://www.oracle.com/middleware/technologies/oac-downloads.html

Step 2: Unzip the folder and click on datagateway.exe file as shown below:

Oracle Data Gateway Agent Interface:

In the URL section, give the OAC instance URL in the below format:

https://< instance >-<tenancy>.analytics.ocp.oraclecoud.com

example https://oacdemo-XXXX.analytics.ocp.oraclecloud.com

Now in the next field click on the Generate Key button, once the key is generated click on Copy to Clipboard to copy the key.

Now go to the OAC URL and Navigate to DV Console as shown below:

 Now scroll down and select Remote Data Connectivity:

Click on Add button to add a new RDG connection as shown below:

Now paste the key which was copied earlier and click on Ok, it will automatically populate the remaining fields from the key.

Now enable the connection:

Now go back to the Remote Data Gateway interface and enable the connection and click on Test button, you will get a message 'Successfully Authenticated' on the bottom of the interface as shown below:

Save the connection, now let's test the connectivity by creating a new connection in OAC DV.
Go to OAC DV and create a new connection (in my case Oracle Database) and select the checkbox to enable Remote Data Connection along with the database details as shown below:

Connection is successfully created now:

Feel free to drop a message in the comment box if you need further assistance.

Stay tuned for more blogs :) 

-- Aman Jain
https://www.linkedin.com/in/amnjn/