Create Connections to Oracle Autonomous Data Warehouse Cloud

You can create connections to Oracle Autonomous Data Warehouse Cloud and use those connections to source data in projects.

  1. Before you create connections to Oracle Autonomous Data Warehouse Cloud, you must have the client credentials zip file containing the trusted certificates that enable Data Visualization to connect to Oracle Autonomous Data Warehouse Cloud.
    1. Obtain the Client Credentials file from Oracle Autonomous Data Warehouse Cloud Console.

      See Download Client Credentials (Wallets) in Using Oracle Autonomous Data Warehouse Cloud.

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

    2. Unzip the Client Credentials wallet file (for example, wallet_ADWC1.zip) to get the cwallet.sso file.
  2. To create a connection to Oracle Autonomous Data Warehouse Cloud:
    1. On the Home page, click Create then click Connection to display the Create Connection dialog.
    2. Click Oracle Autonomous Data Warehouse to display the fields for the connection.
    3. Enter the Connection Name, Description, Host, and Port.
    4. In the Client Credentials field, click Select to browse for the cwallet.sso file.
    5. Enter the Username, Password, and Service Name.
    6. Click Save to create the connection.
      You can now create data sets from the connection.