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

Last Validation: January 20, 2021 for OAC 5.9

Introduction

This post details the steps required to use an advanced JDBC driver in Remote Data Gateway (RDG) to support private Autonomous Database (ADB) data connections in an Oracle Analytics Cloud (OAC) RPD. ADB refers to both Autonomous Data Warehouse and Autonomous Transaction Processing databases.

It supplements the post on Connecting an Oracle Analytics Cloud RPD to Private Autonomous Databases

For additional details on ADW, visit the Autonomous Data Warehouse page. For additional details on OAC, visit the Analytics Cloud page.

Refer here for details on creating DV connections to private autonomous databases.

Validations

January 20, 2021 for OAC 5.9

October 23, 2020 with OAC 5.8

September 3, 2020 with OAC 105.7

Topics

Before You Begin

Configuring the advanced JDBC driver in RDG

 Before You Begin

This post assumes you are following Connecting an Oracle Analytics Cloud RPD to Private Autonomous Databases  and have reached the section titled Additional RDG JDBC Considerations.

 Configuring the advanced JDBC driver in RDG

This section describes how to replace the default RDG driver with an Oracle JDBC driver 18c and higher.

For Linux SSH uses, this post assumes a configured SSH config file and uses an entry named RDG-HOST. Refer to here for additional information.

Determine the RDG Driver Name

For Linux:

ls < your RDG folder >/domain/tmp/obiee/WEB-INF/lib/ojdbc*.jar

For Windows in a command window:

dir < your RDG folder >\war\datagateway\WEB-INF\lib\ojdbc*.jar

Make a note if the driver is named ojdbc.jar or ojdbc8.jar

Determine the RDG Driver Version

Issue these commands:

For Linux:

 cd < your RDG folder >/domain/tmp/obiee/WEB-INF/lib
 < your RDG folder >/oracle_common/jdk/bin/java -jar < your ojdbc file >

For Windows in a command window:

cd < your RDG folder >\war\datagateway\WEB-INF\lib
 < your RDG folder >\jdk\jre\bin\java -jar ojdbc8.jar

The result for is similar to this:

Oracle 19.3.0.0.0 JDBC 4.2 compiled with javac 1.8.0_201 on Thu_Apr_04_20:28:01_
PDT_2019
#Default Connection Properties Resource
#Thu Jan 21 21:53:08 UTC 2021

***** JCE UNLIMITED STRENGTH IS INSTALLED ****

If the version is 18.3 or higher, no further action is necessary.

Download the 18c or 19c JDBC driver

Navigate to the JDBC download page at OTN. Open an 18c or higher driver package and download the ojdbc8.jar file. The examples use c:\oracle on windows for the download location.

Copy the Driver if Necessary

For Linux, copy the file to the RDG host:

scp < Path to the downloaded JAR File > < Host >:< Desired Directory >

Connect to the RDG Host and Set RDG Home

Connect to the RDG host

For Linux: ssh RDG-HOST

Set the RDG Home

For Linux: 

export RDG_HOME=< RDG Install Directory >

For Windows:

From a CMD session type:

set RDG_HOME=< RDG Install Directory >

Stop the RDG Agent

For Linux: 

$RDG_HOME/domain/bin/stopJetty.sh

For Windows:

Close the RDG application if necessary. From the Task Manager stop the datagateway.exe background processes if any are running.

Backup the Existing Driver Files

For Linux: 

mkdir ~/libsave

mv $RDG_HOME/domain/tmp/obiee/WEB-INF/lib/ojdbc* ~/libsave

For Windows:

mkdir c:\oracle\libsave

move %RDG_HOME%\war\datagateway\WEB-INF\lib\ojdbc* c:\oracle\libsave

Place the Advanced JDBC Driver 

Copy the driver file to the RDG library

For Linux: 

cp /home/opc/ojdbc8.jar $RDG_HOME/domain/tmp/obiee/WEB-INF/lib

For Windows:

copy c:\oracle\ojdbc8.jar %RDG_HOME%\war\datagateway\WEB-INF\lib

Start the RDG Agent and Check the Status

For Linux: 

$RDG_HOME/domain/bin/startJetty.sh

$RDG_HOME/domain/bin/status.sh

For Windows:

%RDG_HOME%\datagateway.exe

 Summary

This post detailed the steps required to use an advanced JDBC driver in Remote Data Gateway (RDG) to support private Autonomous Database (ADB) data connections in an Oracle Analytics Cloud (OAC) RPD.

Now you may continue following  Connecting an Oracle Analytics Cloud RPD to Private Autonomous Databases to complete the RPD process.

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