Connect to Oracle Autonomous Transaction Processing

You can create a connection to Oracle Autonomous Transaction Processing and use the connection to access data.

  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 Transaction Processing.
  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.
  7. Click Save.
  8. Use the connection to connect to your data. For example, from the Home page, click Create, then click Dataset, then select the connection that you just created.