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 Autonomous Data Warehouse (ADW) administrator to configure ADW to allow access from Oracle Analytics Cloud. The configuration steps that administrators follow are different for public and private types of connection:

To enable secure communication between Oracle Analytics and Oracle Autonomous Transaction Processing, you must upload trusted SSL certificates from Oracle Autonomous Transaction Processing to Oracle Analytics.

See Download Client Credentials (Wallets) in Using Oracle Autonomous Database 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 contain SSL certificates, to enable SSL on your Oracle Autonomous Transaction Processing connections.

  1. On the Home page, click Create then click Connection.
  2. Click Oracle Autonomous Transaction Processing.
  3. Enter the connection details.
  4. For Client Credentials, click Select to browse for the Client Credentials wallet file (for example, wallet_SALESATP.zip).
  5. Enter the Username, and Password, and select a Service Name from the list.
  6. If you want data modelers to be able to use these connection details. click System connection. See Database Connection Options.
  7. Click Save.