Quick Start

Set up your environment and use the REST API to communicate with Oracle Data Transforms by performing the following tasks.

Prerequisites

Prerequisite More Information
Ensure your Data Transforms deployment is running and accessible.

Autonomous AI Database: https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/access-adp-odt.html

Marketplace: https://docs.oracle.com/en/database/data-integration/data-transforms/using/access-oracle-data-transforms.html

Know your Data Transforms host URL

URL for Data Transforms hosted on Autonomous AI Database:

  1. From the Oracle Cloud Infrastructure left navigation menu click Oracle AI Database, select Autonomous AI Database, select the instance from the list, and navigate to the Details page.
  2. Select the Tool configuration tab.
  3. Under Data Transforms, copy the URL from the Public access URL text box. For example, https://example.adb.us-phoenix-1.oraclecloudapps.com/odi

URL for Data Transforms launched from Marketplace:

  1. From the Oracle Cloud Infrastructure left navigation menu click Compute, select Instances, select the instance from the list, and navigate to the Networking page.
  2. Use the IPv4 address with the port 9999 as the base URL. For example, https://<ip_address>:9999/
Know your Tenant OCID and database OCID.

https://docs.oracle.com/en-us/iaas/Content/GSG/Tasks/contactingsupport_topic-Locating_Oracle_Cloud_Infrastructure_IDs.htm

For Marketplace deployments you need the base 64 encoding of your Data Transforms username:password For example, user123:pass456 becomes dXNlcjEyMzpwYXNzNDU2