Skip to main content

Oracle Autonomous Data Warehouse (ADW) Connector

Oracle Autonomous Data Warehouse (ADW) is connected through the standard Oracle connector using the Oracle MTLS authentication mechanism. ADW instances require a secure, mutual TLS (mTLS) connection that authenticates both the client and the server. Instead of a plain host/port/username/password, an mTLS connection uses the client credentials wallet that you download from your ADW instance.

This guide walks you through downloading the wallet from Oracle Cloud Infrastructure (OCI), finding the connection details, and configuring the connector on the Abacus.AI platform.

info

To connect a self-managed Oracle database (host, port, service name with username/password), see the Oracle Connector guide instead. ADW connections specifically use the Oracle MTLS option described below.

How mTLS Works​

Autonomous Data Warehouse supports Mutual TLS (mTLS) connections by default (typically on port 1522). To complete server-side authentication, the client must present credentials that are downloaded from the ADW instance as a single wallet zip file. This wallet contains the SSO wallet, keystore, truststore, and network configuration files (tnsnames.ora, sqlnet.ora, etc.) needed to establish the secure connection.

To connect ADW to Abacus.AI, you provide:

  • The wallet zip file (client credentials).
  • The wallet password that protects the wallet.
  • The DSN (a TNS connect-descriptor alias from the wallet's tnsnames.ora).
  • The database username and password for the ADW schema you want to read.

Step 1: Download the Client Credentials Wallet​

  1. Sign in to the Oracle Cloud Infrastructure (OCI) Console.
  2. Open the navigation menu and go to Oracle Database → Autonomous Data Warehouse, then select your ADW instance.
  3. On the instance details page, click Database connection.
  4. Under Wallet type, choose Instance Wallet (a wallet scoped to the single database) and click Download wallet.
  5. Enter a wallet password when prompted, and confirm it. Save this password — you will enter it as the Wallet Password in Abacus.AI.
  6. Click Download to save the wallet zip file (for example, Wallet_MYADW.zip) to your computer.
tip

The wallet zip should be small (the platform accepts wallet files under 100 KB). The default Instance Wallet downloaded from OCI is well within this limit. Do not unzip or repackage the file — upload it exactly as downloaded.

Step 2: Find the DSN (Connect-Descriptor Alias)​

The DSN is the connection service alias defined inside the wallet's tnsnames.ora file.

  1. Unzip the downloaded wallet to a temporary location (this is only to inspect it — you still upload the original zip).
  2. Open tnsnames.ora. You will see several service aliases for your database, usually with consistency-level suffixes, for example:
    • myadw_high
    • myadw_medium
    • myadw_low
  3. Pick the alias that matches the workload/consistency level you want and use it as the DSN (for example, myadw_high).
note

The _high, _medium, and _low services control the level of parallelism and concurrency for queries on the Autonomous Data Warehouse. For most data-ingestion use cases, _high or _medium is appropriate.

Step 3: Configure the Connector in Abacus.AI​

  1. Navigate to the Abacus.AI Connected Services Dashboard.
  2. Click Add New Connector at the top right of the page.
  3. Select the Oracle connector from the list of available connectors.
  4. For Authentication Mechanism, select ORACLE_MTLS. The form refreshes to show the mTLS fields.
  5. Fill in the required fields:
    • Database Username: The username for the ADW schema you want to access.
    • Database Password: The password for that username.
    • DSN: The connect-descriptor alias from tnsnames.ora (e.g., myadw_high).
    • Wallet Zip: Upload the wallet zip file you downloaded from OCI in Step 1.
    • Wallet Password: The password you set when downloading the wallet.

Step 4: Save and Verify​

  1. Click the Save button to store the configuration.
  2. Click the Verify button to test the connection. If verification fails, review the error message and confirm that:
    • The wallet zip is the unmodified file downloaded from OCI and is under 100 KB.
    • The wallet password and DSN match the values in the wallet.
    • The username and password are valid for the ADW schema.

Step 5: Manage Your Connector​

Once verified, you can rename, edit, or delete the Oracle ADW connector from the Connected Services Dashboard.

Troubleshooting​

  • "Wallet zip file is empty": The uploaded file did not contain wallet contents. Re-download the Instance Wallet from OCI and upload the original zip without modifying it.
  • "Wallet zip file must be less than 100 KB": Use the Instance Wallet rather than a Regional Wallet, and upload the file as downloaded.
  • DSN / authentication errors: Confirm the DSN exactly matches an alias in the wallet's tnsnames.ora, and that the wallet password is correct.
  • Network/connectivity errors: ADW mTLS connections use port 1522. Ensure your ADW instance allows connections from the Abacus.AI egress IPs. Contact Abacus.AI support for the most up-to-date IP addresses to add to your instance's access control list.