Oracle

Setup Guide

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

Open the Connections page of the CData Connect Cloud dashboard.
Click + Add Connection in the upper-right corner.
Type Oracle into the search field, then click the data source name.
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
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.
Enter the User and Password for the Oracle Autonomous Database.
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.
At the top of the CData Connect Cloud Add Oracle Connection page, click Save & Test.
- If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.
- If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.