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.
December 17, 2018. The method to download the client credentials changed slightly.
Obtaining the ADW Credentials
Downloading Service Credentials from ADW
Downloading Java JDK
Overview of Oracle JDBC Drivers
Using the Oracle Call Interface
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.
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.
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.
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.
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
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.
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 other posts relating to analytics and data integration visit http://www.ateam-oracle.com/dayne-carley