X

Best Practices from Oracle Development's A‑Team

Using an Advanced JDBC Driver with Private Autonomous Databases

Last Validation: October 23, 2020 with OAC 5.8

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

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.

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.

Copy the Driver if Necessary

For Linux, copy the file to the RDG host:

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

e.g. scp /Users/dcarley/Documents/Oracle/ojdbc8.jar RDG-HOST:/home/opc

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 >

e.g. export RDG_HOME=/home/opc/Oracle/Middleware/Silent57

For Windows:

From a CMD session type:

SET RDG_HOME=< RDG Install Directory >

e.g. SET RDG_HOME=C:\ORACLE\RDG57

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\JDBC19c\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

 

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