Connect to Oracle Autonomous Transaction Processing

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

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 Serverless.

   To connect without using a credentials wallet file (known as TLS connection), skip Step 1 and go straight to the Step 2.

   A 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.
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. If you want data modelers to be able to use these connection details. click System connection. See Database Connection Options.
8. Click Save.
9. 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.