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.

Tutorial icon Tutorial

  1. To enable secure communication between Oracle Analytics and Oracle Autonomous Data Warehouse, you must upload trusted SSL certificates from Oracle Autonomous Data Warehouse to Oracle Analytics.

    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 Autonomous Data Warehouse connections.

  2. To create a connection to Oracle Autonomous Data Warehouse:
    1. On the Home page, click Create then click Connection.
    2. Click Oracle Autonomous Data Warehouse to display the fields for the connection.
    3. Enter the connection details.
    4. For Client Credentials field, click Select to browse for the Client Credentials wallet file (for example, wallet_ADWC1.zip).

      The Client Credentials field displays the cwallet.sso file.

    5. Enter your Oracle Autonomous Data Warehouse Username and Password, and select a Service Name from the list.
    6. Save the details.
      You can now create datasets from the connection.