Skip to main content

​
Oracle Autonomous Database Setup

Follow these steps to configure OAuth credentials for BonData.

​
Step 1: Enable ORDS (Oracle REST Data Services)

  1. Log in to Oracle Cloud Console
  2. Navigate to your Autonomous Database
  3. Go to Database Actions → REST
  4. Enable ORDS if not already enabled

​
Step 2: Create an OAuth Client

  1. In Database Actions, go to REST → Security → OAuth Clients
  2. Click Create OAuth Client
  3. Enter a name (e.g., BonData Integration)
  4. Set Grant Type to Client Credentials
  5. Note the Client ID and Client Secret

​
Step 3: Get Your ORDS URL

Your ORDS URL is in the format: 
https://{ADB_OCID}.adb.{REGION}.oraclecloudapps.com/ords/{SCHEMA}
Find this in Database Actions under REST → Overview.

​
Step 4: Enter Credentials

Enter your Client ID, Client Secret, and ORDS URL in BonData.

​
Required Fields

FieldDescription
Client IDOAuth Client ID from ORDS Security settings
Client SecretOAuth Client Secret from ORDS Security settings
Authorization URLYour ORDS base URL from Database Actions