Before You Begin
This tutorial shows you how to connect SQL Developer to a database in Oracle Autonomous Data Warehouse Cloud (Autonomous DW Cloud), and then create tables. This tutorial takes approximately 10 minutes to complete.
Oracle Autonomous Data Warehouse Cloud Tutorial Series
This is the second in a series of tutorials for the Oracle Autonomous Data Warehouse Cloud. Perform the tutorials sequentially.
- Provisioning Autonomous Data Warehouse Cloud
- Connecting SQL Developer and Creating Tables
- Loading Your Data
- Running a Query on Sample Data
- Using Oracle Machine Learning with Autonomous Data Warehouse Cloud (set of additional tutorials)
Oracle SQL Developer can connect to Oracle Autonomous Data Warehouse Cloud using a security credentials zip file that you created in the previous tutorial, or a credentials zip file provided by your Autonomous DW Cloud administrator.
In this tutorial, you define a SQL Developer connection to a database in Autonomous DW Cloud. You then use SQL Developer to create tables in the database.
What Do You Need?
- Access to an instance of Autonomous Data Warehouse Cloud (see Using Autonomous Data Warehouse Cloud)
- Completion of previous tutorial, Getting
Started with Oracle Autonomous Data Warehouse Cloud,
in which the user
adwc_useris created and a client credentials wallet zip file is downloaded
- The password for the data
adwc_userthat was created in the previous tutorial
- Oracle SQL Developer (see Oracle
Technology Network download site). We recommend that you
download version 17.4 or later, since this version contains
enhancements for key Autonomous DW Cloud features; however,
earlier versions of SQL Developer will work with Autonomous DW
If you are a Windows user on 64-bit platform, download the 'Windows 64-bit with JDK 8 included' distribution as it includes both Java 8 and the Java Cryptography Extension (JCE) files necessary to run SQL Developer and connect to your Autonomous DW Cloud.
If you are a non-Windows user, Download and Install the appropriate Java 8 JDK for your Operating System. Download and Extract the Java Cryptography Encryption Archive to the directory as indicated in the README.txt.
- A client credentials zip file and its keystore password, that you defined in the previous tutorial or obtained from your Autonomous DW Cloud administrator. This file contains security credentials to connect SQL Developer to your Autonomous DW Cloud database.
Define a SQL Developer Connection
First, define a SQL Developer connection as the user
to a database in your Autonomous DW Cloud.
- Open SQL Developer on your local computer. In the
Connections panel, right-click Connections
and select New
Do not right-click Database Schema Service Connections. That menu selection is for connecting to a different Oracle cloud service, the Oracle Database Schema Service.
- The New/Select Database Connection dialog appears. Enter the following information:
- Connection Name - Enter the name for this cloud connection.
- Username - Enter the database username . Use the
adwc_userdatabase account that you created in the previous tutorial.
- Password - Enter the password that you specified when
adwc_userin the previous tutorial. The previous tutorial suggested
WelcomeADWC1!as the password.
- Connection Type - Select Cloud PDB.
- Configuration File - Click Browse, and select the path to your local copy of the Client Credentials zip file, downloaded from the Autonomous DW Cloud service console by you, or given to you by your Autonomous DW Cloud administrator.
- Keystore Password - Enter the password that was generated when you or your Autonomous DW Cloud administrator downloaded the Client Credentials zip file from the Autonomous DW Cloud service console.
- Service -In the drop-down menu, service selections are
prepended with database names. Select the low, medium or
high menu item for your database. These service levels map
to the LOW, MEDIUM, and HIGH consumer groups, which provide
different levels of performance and concurrency.
Note: Earlier versions of SQL Developer may not support this feature.
Status: Success displays at the bottom left of the New/Select Database Connection dialog.
An entry for the new connection appears under Connections.
Create SH Tables in your Autonomous DW Cloud Database
After you have connected SQL Developer to your Autonomous DW
Cloud database, use a SQL Developer worksheet to define
TABLE statements to create the SH tables (sales
history tables from an Oracle sample schema) in
adwc_user schema. In the next tutorial, you
will load data into these tables from an object store.
- Copy and paste this
code snippet to a SQL Developer worksheet. Run the
script to create the
SHtables and click Commit.
- In the next tutorial, "Loading
Your Data", you will load data into these
SHtables from an object store.
Want to Learn More?
- Autonomous Data Warehouse Cloud website