Setup Guide

Follow these steps to connect Oracle to your CData Connect account:

  1. Open the Connections page of the CData Connect dashboard.

  2. Click + Add Connection in the upper-right corner.

  3. Type Oracle into the search field, then click the data source name.

  4. On the Basic Settings tab of the new connection, enter a connection name or keep the default name.

  5. Enter the Connection String. Copy one of the high, medium, or low connection strings available for your Oracle Autonomous Database, located in the Database Connection menu of the Oracle Autonomous Database. The string should be in the format shown. You can also connect to an Oracle self-hosted database.

  6. Enter the User and Password for the Oracle Autonomous Database.

  7. Click Choose File to upload the Oracle Wallet SSO file, cwallet.sso, found in the Oracle Wallet zip file. To download the Oracle Wallet zip file, go to the Database Connection menu in the Oracle Autonomous Database. This file is optional for an Oracle self-hosted database.

  8. At the top of the CData Connect Add Oracle Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.