Preparing to Connect to the Autonomous Data Warehouse

Introduction

This post details generic common steps required before connections can be made to ADW.

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

Updates

Updated December 17, 2018. The method to download the client credentials changed slightly.

Topics

Obtaining the ADW Credentials

Downloading Service Credentials from ADW

Downloading Java JDK

Overview of Oracle JDBC Drivers

Using the Oracle Call Interface

Obtaining the ADW Credentials

Obtain the ADW username and password associated with the ADW account. They are used to access the Instance Services Console.

Obtain the database administrative username (default is admin) and password associated with the ADW instance. These were specified when the instance was created. Refer to Create an ADW Service for details. Alternatively, obtain a database user (schema) and password created in the instance.

Downloading Service Credentials from ADW

The Client Credentials consists of a wallet, keystore files, and network configuration files. For additional details, refer to Download the Credentials Zip File for details.

Recent patches have changed the GUI a little. Refer to Downloading Client Credentials (Wallet) for details.

Unzip the downloaded zip file to a secure location that is accessible by your database client(s). Unzip the contents taking care to retain the zip file. Ensure the permissions on the zip file and the unzipped folder allow access by database clients. Note: Some client applications require the actual zip file. You may need to re-zip the contents if the zip file is no longer available.

Downloading Java JDK

The latest version of the Java Development Kit (JDK) may be downloaded from OTN. For example, the latest JDK8 version is at http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Oracle recommends using the latest version as it contains important security updates and bug patches.

Note: Early versions of JDK8 may not work correctly. This post has used versions JDK8u101 and higher.

Downloading Java JCE

Connections to ADWC require Java Cryptography Extension (JCE) unlimited strength policy files.

Later releases of JAVA JDK 8 (151+) have the JCE Unlimited Strength Jurisdiction Policy Files installed. Starting with JDK 8u161, the required unlimited strength files are the default. Oracle recommends using JDK 8u161 or higher to take advantage of the default settings

The latest version of the JCE Unlimited Strength Jurisdiction Policy Files may be downloaded from OTN. For example, the latest JCE 8 version is at http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html

For versions prior to JDK 8u151, unzip the JCE download and refer to the README.txt for installation instructions.

Overview of Oracle JDBC Drivers

JDBC drivers come in two flavors: Thin and Oracle Call Interface (OCI).

For driver feature differences, see Overview of Oracle JDBC Drivers https://docs.oracle.com/database/121/JJDBC/overvw.htm#JJDBC28025

Using the Oracle Call Interface

The Oracle Call Interface (oci) is the comprehensive, high performance, native C language interface to Oracle Database for custom or packaged applications.

The JDBC oci driver is an alternative to the JDBC thin driver.

Oracle Instant Client libraries provide the necessary network connectivity, as well as basic and high end data features, to make full use of Oracle Databases. It underlies the Oracle APIs of popular languages and environments including Node.js, Python and PHP, as well as providing access for OCI, OCCI, JDBC, ODBC and Pro*C applications.

The Oracle Instant Client is available on OTN from at Oracle Instant Client Downloads

Download the appropriate basic and tools zip files at a minimum.

For use in Cloud instances, download the Linux-64 versions.

Summary

This post provided the steps required before client connections can be made to ADW. It demonstrated how to download the client credentials and provided links for software downloads if needed.

For more OAC, BICS and BI best practices, tips, tricks, and guidance that the A-Team members gain from real-world experiences working with customers and partners, visit Oracle A-Team Chronicles for BICS, and Oracle A-Team Chronicles for OAC

References

Autonomous Data Warehouse

Create an ADW Service

Download the Credentials Zip File

Downloading Client Credentials (Wallet)

JAVA JDK 8 Downloads

JAVA JCE 8 Downloads

JDBC Driver Features

Oracle Instant Client Downloads

Oracle A-Team Chronicles for BICS

Oracle A-Team Chronicles for OAC

 

Add Your Comment