Oracle Cloud Infrastructure Documentation

Connecting to an Autonomous Data Warehouse

This topic gives an overview of connecting a client to an Autonomous Data Warehouse and describes how to obtain the credentials and information you need to create a connection.

About Connecting to Autonomous Data Warehouse

Applications and tools connect to Autonomous Data Warehouse by using Oracle Net Services (also known as SQL*Net). SQL*Net supports a variety of connection types to the Autonomous Data Warehouse, including Oracle Call Interface (OCI), ODBC drivers, JDBC OC, and JDBC Thin Driver.

To support connections of any type, you'll need to download the client security credentials and network configuration settings required to access your database. You'll also need to supply the applicable TNS names or connection strings for a connection, depending on the client application or tool, type of connection, and service level. You can view or copy the TNS names and connection strings in the DB Connection dialog for your Autonomous Data Warehouse. For detailed information about the TNS names, see Predefined Database Service Names for Autonomous Data Warehouse.

About Downloading Client Credentials

The client credentials .zip that you download contains the following files:

  • cwallet.sso - Oracle auto-login wallet
  • ewallet.p12 - PKCS #12 wallet file associated with the auto-login wallet
  • sqlnet.ora - SQL*Net profile configuration file that includes the wallet location and TNSNAMES naming method
  • tnsnames.ora - SQL*Net configuration file that contains network service names mapped to connect descriptors for the local naming method
  • Java Key Store (JKS) files - Key store files for use with JDBC Thin Connections

Wallet files, along with the database user ID and password, provide access to data in your Autonomous Data Warehouse. Store wallet files in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), transmit the wallet password separately and securely.

Before You Begin

The Autonomous Data Warehouse is preconfigured to support Oracle Net Services (a TNS listener is installed and configured to use secure TCPS and client credentials.) The client computer must be prepared to use Oracle Net Services to connect to Autonomous Data Warehouse. Preparing your client includes downloading the client credentials. See Preparing for Oracle Call Interface (OCI), ODBC, and JDBC OCI Connections and Preparing for JDBC Thin Connections for steps you might have to perform before performing the following procedure.

Using the Oracle Cloud Infrastructure Console

To access the client credentials and connection information for your Autonomous Data Warehouse

  1. Open the navigation menu. Under Database, click Autonomous Data Warehouse.
  2. Choose your Compartment.
  3. In the list of Autonomous Data Warehouses, click on the display name of the database you are interested in.
  4. Click DB Connection.
  5. To obtain the client credentials, click Download.

    You will be prompted to provide a password to encrypt the keys inside the wallet. The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character.

    Save the client credentials zip file to a secure location. See About Downloading Client Credentials for information about the files included in the download.

  6. Take note of or copy the TNS names or connection strings you need for your connection. See About Connecting to Autonomous Data Warehouse for information about making connections.

Using the API

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Use the GenerateAutonomousDataWarehouseWallet API operation to download the client credentials for your Autonomous Data Warehouse.

What's Next

For information and instructions on making secure connections to your database, see Connecting to Autonomous Data Warehouse.