Skip to content

Latest commit

 

History

History
143 lines (76 loc) · 4.62 KB

LabGuide200.md

File metadata and controls

143 lines (76 loc) · 4.62 KB
Raw

Updated: December 10, 2018

Introduction

This lab guide will walk you through the process of creating Autonomous Data Warehouse cloud service. We will then connect it to SQL Developer and will import a table from local machine.

To log issues, click here to go to the github oracle repository issue submission form.

Objectives

  • Create an Autonomous Data Warehouse Cloud Service.
  • Connect ADWC to SQL Developer and create a credential.
  • Import a table from local machine.

Required Artifacts

  • An oracle cloud account with Autonomous Data Warehouse Cloud Service.
  • SQL Developer.

STEP 1: Create Autonomous Data Warehouse Cloud Service (ADWC).

  • Login into your cloud account. Click on Menu and click on Autonomous Data Warehouse.

  • Click on Create Autonomous Data Warehouse.

  • On Details screen, select the Compartment, enter Display Name and Database Name. Keep the CPU Core Count and Storage as 1. Finally enter the Password and Confirm Password.

    • Note : Make sure your password doesn't have "@". It might create a problem later.

  • Select a License Type and click on Create Autonomous Data Warehouse.

  • Once your ADWC instance is avaiable, click on the ADWC instance that you have just created. Then Click on DB Connection. Download Client Credentials Wallet by clicking on Download.

  • Enter the Password and click on Download.

    Note: Remember this password. This can be different than the password you have entered while creating ADWC instance.

  • For quick access, create a directory DemoADWC and copy paste this zip wallet file there.

STEP 2: Connect ADWC with SQL Developer and create a credential.

  • Connect ADWC with SQL Developer.

    • Open SQL Developer.

    • Click on Connections

    • Set the following parameters:

      Connection Name : Enter any Connection Name

      Username : admin

      Password : Password that was entered during ADWC instance creation.

      Connection Type : Cloud PDB

      Configuration File : Click on Browse and select the wallet that you have downloaded in Step 1

      Keystore Password : Password entered while downloading wallet

      Service : Service name starts with your ADWC Database Name followed by high/medium/low. Select high service for this demo.

    • Click on Test. If it shows Status as Success, your ADWC is connected to SQL Developer.

    • Go to Oracle Compute instance. Click on Menu, Identity, Users.

    • Click on [email protected] user.

    • Click on Auth Tokens.

    • Click on Generate Token

    • Give a Description and click on Generate Token

      Note: Make sure to save the token in a text file for future reference.

    • Go back to SQLDeveloper and copy paste the following script:

      Change the following parameters before copy pasting the script:

      Script:

      BEGIN
      DBMS_CLOUD.CREATE_CREDENTIAL( credential_name => 'DEF_CRED_NAME', username => '[email protected]', password => 'Generated Token' ); END;

STEP 3: Create a table in ADWC.

  • Download following file. Channels

  • Right click on Tables and click on Import Data.

  • Leave the Source as Local File. Open the file just downloaded.

  • Click on next and give Table Name as channels. Click on next, next and finish.

  • A pop up appears to show data is imported. Click on OK.