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
oracle@oracle:~$ 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 oracle@oracle:~$ 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 oracle@oracle:~$ cat /etc/environment JAVA_HOME="/usr/lib/jvm/java-8-oracle" PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" oracle@oracle:~$ source /etc/environment oracle@oracle:~$ 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 .. oracle@oracle:~/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