1. Using Oracle Fusion Analytics Warehouse
  2. Work with Projects
  3. Add Data Sources to Analyze and Explore Data
  4. Connect to Data
  5. 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.

Tutorial icon Tutorial

  1. To connect using a credentials wallet file, (known as Mutual TLS connection), download the SSL certificates from Oracle Autonomous Data Warehouse.

    See Download Client Credentials (Wallets) in Using Oracle Autonomous Database on Shared Exadata Infrastructure.

    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 connect without using a credentials wallet file (known as TLS connection), skip Step 1 and go straight to the Step 2.

  2. On the Home page, click Create then click Connection.
  3. Click Oracle Autonomous Data Warehouse to display the connection dialog.
  4. Enter a user-friendly Connection Name and Description.
  5. For Encryption Type:
    To connect without a credentials wallet file, select TLS, then skip to the next step.
    To connect using a credentials wallet file, select Mutual TLS, 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). The Client Credentials field displays the cwallet.sso file.
  6. For the TLS connection type (without a wallet), enter a Connection String, the Username and Password of a user in Oracle Autonomous Data Warehouse, and select a Service Name from the list.
  7. If you're connecting to a remote database, click Use Remote Data Connectivity.
    Check with your administrator that you can access the remote database.
  8. If you want data modelers to be able to use these connection details. click System connection. See Database Connection Options.
  9. Save the details.
You can now create datasets from the connection.