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 Transaction Processing, you must obtain the client credentials zip file containing the trusted certificates that enable Oracle Analytics to connect to Oracle Autonomous Transaction Processing.

    See Download Client Credentials (Wallets) in Using Oracle Autonomous Transaction Processing on Shared Exadata Infrastructure.

    The credentials wallet file secures communication between Oracle Analytics and Oracle Autonomous Transaction Processing. The wallet file (for example, wallet_SALESATP.zip) that you upload must contain SSL certificates, to enable SSL on your Oracle Database Cloud connections.

  2. To create a connection to Oracle Autonomous Transaction Processing:
    1. On the Home page, click Create then click Connection.
    2. Click Oracle Autonomous Transaction Processing to display the fields for the connection.
    3. Enter the Connection Name and Description.
    4. In the Client Credentials field, click Select to browse for the Client Credentials wallet file (for example, wallet_SALESATP.zip).

      The Client Credentials field displays the cwallet.sso file.

    5. Enter the Username, and Password, and select a Service Name from the list.
    6. Click Save to create the connection.
      You can now create data sets from the connection.