Preparing to Connect to the Autonomous Data Warehouse Cloud

Introduction

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

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

Topics

Obtaining the ADWC Credentials

Downloading Service Credentials from ADWC

Downloading Java JDK

Overview of Oracle JDBC Drivers

Using the Oracle Call Interface

Obtaining the ADWC Credentials

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

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

Downloading Service Credentials from ADWC

The Client Credentials contain an oracle wallet, keystore files, and network configuration files. For additional details, refer to Download the Credentials Zip File 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

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 http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

For Windows clients download the Windows-64 basic, JDBC and SQL*Plus files at a minimum. Note: Some client applications require the 12.1.x version.

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

Summary

This post provided the steps required before client connections can be made to ADWC. 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 Cloud

Create an ADWC Service

Download the Credentials Zip File

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