1. User’s Guide for Oracle Analytics Desktop
  2. Connect to Data Sources
  3. Connect to Oracle Autonomous Data Warehouse

Connect to Oracle Autonomous Data Warehouse

You can create a connection to Oracle Autonomous Data Warehouse and use the connection to access data.

You can connect to Oracle Autonomous Data Warehouse using security certificates downloaded from Oracle Autonomous Data Warehouse to a wallet (known as mTLS, or Mutual Transport Layer Security), or without a wallet (known as TLS, or Transport Layer Security). See About TLS Authentication. The credentials wallet file secures communication between Oracle Analytics and Oracle Autonomous Data Warehouse. The wallet file (for example, wallet_ADWC1.zip) that you upload must contain SSL trusted certificates, to enable SSL on your Oracle Database Cloud connections.

Tutorial icon Tutorial

  1. Before you create connections to Oracle Autonomous Data Warehouse, you must obtain the client credentials zip file containing the trusted certificates that enable Oracle Analytics to connect to Oracle Autonomous Data Warehouse.

    See Download Client Credentials (Wallets) in Using Oracle Autonomous Database Serverless.

    The credentials wallet file secures communication between Oracle Analytics and Oracle Autonomous Data Warehouse. The wallet file (for example, wallet_ADWC1.zip) that you upload must contain SSL certificates, to enable SSL on your Oracle Database Cloud connections.

  2. On the Home page, click Create then click Connection.
  3. Click Oracle Autonomous Data Warehouse.
  4. Enter a user-friendly Connection Name and Description.
  5. For Encryption Type:
    • To connect without a credentials wallet file, select TLS as the Encryption Type, enter a Connection String, then enter a Username and Password of a user in Oracle Autonomous Data Warehouse.
    • To connect using a credentials wallet file, select Mutual TLS as the Encryption Type, then click Select and browse for and select the Client Credentials wallet file that you downloaded from Oracle Autonomous Data Warehouse (for example, wallet_ADWC1.zip), then enter a Service Name. The Client Credentials field displays the cwallet.sso file.
  6. Click Save.
You can now create datasets from the connection.