Navigation
- Preparing ADW Client Machine
- Creating Autonomous Data Warehouse Instance
- Creating DB Tables in Autonomous Data Warehouse through SQL Developer
- Load Data into OCI Object storage and import the data into AWD
- Create Analytics Cloud ADW Connection and Create Data Visualization Reports
Goal
we would need SQL Developer to connect to Autonomous Data warehouse , you can use other Clients as well , in this section we will prepare our ubuntu machine to have latest JDK and latest Sql developer running
Latest JDK version
[email protected]:~$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 18.04.1 LTS Release: 18.04 Codename: bionic // Install Latest version of Java 8 [email protected]:~$ sudo add-apt-repository ppa:webupd8team/java [sudo] password for oracle: Oracle Java (JDK) Installer (automatically downloads and installs Oracle JDK8). There are no actual Java files in this PPA. sudo apt-get update sudo apt-get install oracle-java8-installer // Set the JAVA_HOME [email protected]:~$ cat /etc/environment JAVA_HOME="/usr/lib/jvm/java-8-oracle" PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" [email protected]:~$ source /etc/environment [email protected]:~$ java -version java version "1.8.0_191" Java(TM) SE Runtime Environment (build 1.8.0_191-b12) Java HotSpot(TM) 64-Bit Server VM (build 25.191-b12, mixed mode)
Download and run the SQL Developer
Edit the sqldeveloper.conf and add the following line, so that it picks latest JDK that we just installed.
#SetJavaHome ../../jdk SetJavaHome /usr/lib/jvm/java-8-oracle .. [email protected]:~/sqldeveloper$ ./sqldeveloper.sh Oracle SQL Developer ..
Start the SQL Developer , click on Add DB Connection, You should be able to see Cloud Wallet as connection type and an option to Browse for configuration file as shown below
What Next >> Creating Instance of Oracle Autonomous Data Warehouse