ÃÛ¶¹ÊÓƵ

Connect Oracle DB to Experience Platform using the Flow Service API

Read this guide to learn how to connect your Oracle DB account to ÃÛ¶¹ÊÓƵ Experience Platform using the .

Getting started

This guide requires a working understanding of the following components of Experience Platform:

The following sections provide additional information that you will need to know in order to successfully connect to Oracle using the Flow Service API.

Using Experience Platform APIs

For information on how to successfully make calls to Experience Platform APIs, see the guide on getting started with Experience Platform APIs.

Gather required credentials

Read the Oracle DB overview for information on authentication.

Connect Oracle DB to Experience Platform on Azure azure

Read the steps below for information on how to connect your Oracle DB account to Experience Platform on Azure.

Create a base connection for Oracle DB on Experience Platform on Azure azure-base

A base connection links your source to Experience Platform, storing authentication details, connection status, and a unique ID. Use this ID to browse source files and identify specific items to ingest, including their data types and formats.

API format

POST /connections

To create a base connection ID, make a POST request to the /connections endpoint and provide your Oracle DB authentication credentials as part of the request parameters.

Request

The following request creates a base connection for Oracle DB using connection string authentication.

curl -X POST \
  'https://platform.adobe.io/data/foundation/flowservice/connections' \
  -H 'Authorization: Bearer {ACCESS_TOKEN}' \
  -H 'x-api-key: {API_KEY}' \
  -H 'x-gw-ims-org-id: {ORG_ID}' \
  -H 'x-sandbox-name: {SANDBOX_NAME}' \
  -H 'Content-Type: application/json' \
  -d '{
    "name": "Oracle DB base connection",
    "description": "A base connection to connect Oracle DB to Experience Platform on Azure",
    "auth": {
      "specName": "ConnectionString",
      "params": {
        "connectionString": "Host={HOST};Port={PORT};Sid={SID};UserId={USERNAME};Password={PASSWORD}"
      }
    },
    "connectionSpec": {
      "id": "d6b52d86-f0f8-475f-89d4-ce54c8527328",
      "version": "1.0"
    }
  }'

Response

A successful response returns details of the newly created base connection, including its unique identifier (id).

{
    "id": "f088e4f2-2464-480c-88e4-f22464b80c90",
    "etag": "\"43011faa-0000-0200-0000-5ea740cd0000\""
}

Connect Oracle DB to Experience Platform on Amazon Web Services aws

Read the steps below for information on how to connect your Oracle DB account to Experience Platform on AWS.

Create a base connection for Oracle DB on Experience Platform on AWS aws-base

API format

POST /connections

Request

The following request creates a base connection for Oracle DB to connect to Experience Platform on AWS.

curl -X POST \
  'https://platform.adobe.io/data/foundation/flowservice/connections' \
  -H 'Authorization: Bearer {ACCESS_TOKEN}' \
  -H 'x-api-key: {API_KEY}' \
  -H 'x-gw-ims-org-id: {ORG_ID}' \
  -H 'x-sandbox-name: {SANDBOX_NAME}' \
  -H 'Content-Type: application/json' \
  -d '{
      "name": "Oracle DB on Experience Platform AWS",
      "description": "Oracle DB on Experience Platform AWS",
      "auth": {
          "specName": "Basic Authentication",
          "params": {
              "server": "diy.us-dawkins-1.oraclecloud.com",
              "port": "1521",
              "database": "mcmg_profits_diy.oraclecloud.com",
              "username": "Admin",
              "password": "xxxx",
              "schema": "ADMIN",
              "sslMode": "true"
          }
      },
      "connectionSpec": {
          "id": "26d738e0-8963-47ea-aadf-c60de735468a",
          "version": "1.0"
      }
  }'

Response

A successful response returns details of the newly created base connection, including its unique identifier (id) and corresponding. You can use the ID to create source connection and the etag to update your account.

{
    "id": "f847950c-1c12-4568-a550-d5312b16fdb8",
    "etag": "\"0c0099f4-0000-0200-0000-67da91710000\""
}

Create a dataflow for Oracle DB data

Now that you have successfully connected your Oracle DB account, you can now create a dataflow and ingest data from your database into Experience Platform.