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
Refer here for details on creating DV connections to private autonomous databases.
September 3, 2020 with OAC 105.7
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.
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 https://www.ateam-oracle.com/preparing-sshtunneling-for-oracle-analytics-cloud-remote-data-gateway-in-a-private-subnet for additional information.
Navigate to the JDBC download page at OTN. Open an 18c or higher driver package and download the ojdbc8.jar -file.
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
For Linux: ssh RDG-HOST
export RDG_HOME=< RDG Install Directory >
e.g. export RDG_HOME=/home/opc/Oracle/Middleware/Silent57
From a CMD session type:
SET RDG_HOME=< RDG Install Directory >
e.g. SET RDG_HOME=C:\ORACLE\RDG57
Close the RDG application if necessary. From the Task Manager stop the datagateway.exe background processes if any are running.
mv $RDG_HOME/domain/tmp/obiee/WEB-INF/lib/ojdbc* ~/libsave
MOVE %RDG_HOME%\war\datagateway\WEB-INF\lib\ojdbc* C:\ORACLE\LIBSAVE
Copy the driver file to the RDG library
cp /home/opc/ojdbc8.jar $RDG_HOME/domain/tmp/obiee/WEB-INF/lib
COPY C:\ORACLE\JDBC19c\ojdbc8.jar %RDG_HOME%\war\datagateway\WEB-INF\lib
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