Connect to Oracle Autonomous Transaction Processing

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

Before you start, ask your database administrator to configure Oracle Autonomous Transaction Processing to allow access from Oracle Analytics Cloud. The configuration steps that administrators follow are different for public and private types of connection:

• For public connections, see Enable Access to Oracle Autonomous Data Warehouse Prerequisites.
• For private connections, see How do I connect to a private Oracle Autonomous Data Warehouse in a customer VCN?.

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 Transaction Processing (for example, wallet_ATP1.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 Transaction Processing.
7. If you want data modelers to be able to use these connection details. click System connection. See Database Connection Options.
8. Under Authentication, specify how you'd like to authenticate the connection:
   • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
   • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
9. Click Save.
10. 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.