Skip to main content

Oracle

Overview

The Oracle connector lets you connect to an Oracle Database instance.

This connector also includes an Oracle Eloqua Audiences destination (currently in development). It can validate credentials against the Eloqua REST API, but loading/syncing audiences is not yet supported.

Capabilities

  • Source: Not available in this connector doc.
  • Destination (Reverse ETL): In development. The connector can validate configuration during setup, but loading data is not yet supported.

Setup

  • Network access from the platform to your Oracle Database host (VPC/VPN/allowlist as applicable).
  • Oracle Database connection details (host, port, service name or SID, username, password).

Oracle Eloqua Audiences (destination)

This connector also includes an Oracle Eloqua Audiences destination. At this time, only credential validation is supported; loading/syncing audiences is still in development.

To set it up, you’ll need:

  • An Oracle Eloqua REST API base URL that starts with https:// (or http://), for example https://secure.pXX.eloqua.com (trailing / is OK).
  • An Eloqua username and password with permission to access the REST API.

Authentication

Oracle Database typically authenticates using a database username and password.

If you are configuring Oracle Eloqua Audiences, authentication uses HTTP Basic Auth against the Eloqua REST API:

  • Base URL: Your Eloqua instance URL (must start with https:// or http://; trailing / is ignored)
  • Username: Eloqua username
  • Password: Eloqua password

Configuration

Provide the following connection details:

FieldTypeRequiredDescription
HoststringYesOracle Database hostname or IP address.
PortnumberYesListener port (commonly 1521).
Service name / SIDstringYesThe database service name (recommended) or SID, depending on your environment.
UsernamestringYesDatabase user to connect as.
PasswordstringYesPassword for the database user.

For Oracle Eloqua Audiences (destination), provide:

FieldTypeRequiredDescription
Base URLstringYesYour Eloqua instance base URL. Must start with https:// (or http://) and should not include a trailing /. Example: https://secure.pXX.eloqua.com.
UsernamestringYesEloqua username for Basic Auth.
PasswordstringYesEloqua password for Basic Auth.

Streams

This destination is still in development and does not yet support loading records, so there are no supported streams at this time.

Hashing and normalization

This connector does not currently expose field-level hashing options.

Data contract

Because Oracle Database destination loading is still in development, the data contract (how records are mapped to tables/columns, upsert behavior, and supported data types) is not yet available.