Oracle Eloqua connector reference

Important

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Oracle Eloqua from the Previews page. See Manage Azure Databricks previews.

The managed Oracle Eloqua connector in Lakeflow Connect supports 29 source tables in the default schema. This reference lists the supported source tables, connector options, and destination table schemas.

Supported source tables

The Oracle Eloqua connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
`contact`	`id`	Contacts in your Oracle Eloqua instance, including email address, name, address, subscription status, and contact field values.	Incremental	`updatedAt`
`account`	`id`	Accounts (companies) in your Oracle Eloqua instance, including address, customer relationship management (CRM) mappings, and account field values.	Incremental	`updatedAt`
`campaign`	`id`	Campaigns, including type, status, budget, schedule, and canvas elements.	Incremental	`updatedAt`
`email`	`id`	Email assets, including subject, sender details, HTML content, and hyperlinks.	Incremental	`updatedAt`
`form`	`id`	Form assets, including HTML, form elements, and processing steps.	Incremental	`updatedAt`
`form_submission`	`form_id`, `id`	Submissions to each form, including the submitting contact and submitted field values.	Incremental	`submittedAt`
`segment`	`id`	Contact segments, including their filter elements and contact counts.	Incremental	`updatedAt`
`contact_list`	`id`	Shared contact lists, including their scope and contact counts.	Incremental	`updatedAt`
`option_list`	`id`	Option lists (picklists) and their display names and values.	Full refresh only
`event_registration`	`id`	Events, including their registration fields and sessions.	Incremental	`updatedAt`
`user_info`	`id`	Oracle Eloqua users, including login name, security groups, and permissions.	Incremental	`updatedAt`
`visitor`	`visitorId`	Website visitor profiles, including visit history and location inferred from IP address.	Incremental	`V_LastVisitDateAndTime`
`event_registration_registrant`	`event_registration_id`, `id`	Registrants for each event, including the linked contact and registration field values.	Full refresh only
`custom_object`	`custom_object_id`, `id`	Records of every custom object, including the linked contact or account and field values.	Full refresh only
`landing_page`	`id`	Landing pages, including content, forms, hyperlinks, and expiry settings.	Incremental	`updatedAt`
`email_group`	`id`	Email groups, including their emails and subscription lists.	Incremental	`updatedAt`
`program`	`id`	Programs, including their canvas elements and default entity.	Incremental	`updatedAt`
`activity_email_send`	`ExternalId`	Email send activities, including the contact, campaign, email asset, deployment, and subject line.	Incremental	`ActivityDate`
`activity_email_open`	`ExternalId`	Email open activities, including the contact, visitor, campaign, email asset, and IP address.	Incremental	`ActivityDate`
`activity_email_clickthrough`	`ExternalId`	Email clickthrough activities, including the contact, visitor, campaign, email asset, and clicked link.	Incremental	`ActivityDate`
`activity_subscribe`	`ExternalId`	Email subscribe activities, including the contact, campaign, asset, and email address.	Incremental	`ActivityDate`
`activity_unsubscribe`	`ExternalId`	Email unsubscribe activities, including the contact, campaign, asset, and email address.	Incremental	`ActivityDate`
`activity_bounceback`	`ExternalId`	Email bounceback activities, including the contact, campaign, email asset, and Simple Mail Transfer Protocol (SMTP) error details.	Incremental	`ActivityDate`
`activity_form_submit`	`ExternalId`	Form submit activities, including the contact, visitor, campaign, form, and raw submitted data.	Incremental	`ActivityDate`
`activity_page_view`	`ExternalId`	Page view activities, including the visitor, campaign, page URL, referrer, and web visit.	Incremental	`ActivityDate`
`activity_web_visit`	`ExternalId`	Web visit activities, including the visitor, duration, first page viewed, and number of pages.	Incremental	`ActivityDate`
`activity_external_activity`	`ExternalId`	External activities recorded in Oracle Eloqua by other systems, including the contact, campaign, and external asset details.	Incremental	`ActivityDate`
`contact_list_contact`	`contact_list_id`, `contact_id`	Members of each shared contact list.	Full refresh only
`contact_segment`	`segment_id`, `contact_id`	Members of each contact segment.	Full refresh only

Source APIs

The connector reads from both the Oracle Eloqua REST API and the Oracle Eloqua Bulk API 2.0.

REST API: All tables except the activity_* tables, contact_list_contact, and contact_segment.
Bulk API: The activity_* tables, contact_list_contact, and contact_segment. The connector creates an export for each activity time window, contact list, or segment, waits for the export to finish, and then reads the results. contact_list_contact and contact_segment find their lists and segments through the REST API.

Bulk API contact exports require the Manage Data Export action permission. See Prerequisites. For Oracle Eloqua Bulk API limits that affect these tables, see Activity tables and Contact list and segment membership tables.

Connector options

See Examples for usage.

Option	Type	Scope	Required	Applies to	Description
`start_datetime`	String (`yyyy-MM-ddTHH:mm:ssZ`)	Pipeline	No	All incremental tables	Earliest date and time from which to ingest data. For `form_submission` and the `activity_*` tables, defaults to 760 days before the first sync. For other incremental tables, defaults to `2015-01-01T00:00:00Z`. Applies only to the first sync of each table. Later syncs resume from the stored cursor. Must be in the past, and at least one hour in the past for `activity_bounceback`.
`activity_window_step`	String (ISO 8601 duration, for example `P7D`)	Table	No	`activity_*` tables	Length of the time window that each Bulk API activity export covers. Defaults to `P30D` (30 days). Oracle Eloqua returns at most 5,000,000 records per export, so if a table produces more than about 160,000 records per day, set a shorter window such as `P7D` or `P1D`.

Destination table schemas

`contact`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`name`	`STRING`
`emailAddress`	`STRING`
`firstName`	`STRING`
`lastName`	`STRING`
`accountName`	`STRING`
`title`	`STRING`
`businessPhone`	`STRING`
`mobilePhone`	`STRING`
`address1`	`STRING`
`address2`	`STRING`
`address3`	`STRING`
`city`	`STRING`
`province`	`STRING`
`postalCode`	`STRING`
`country`	`STRING`
`salesPerson`	`STRING`
`isSubscribed`	`STRING`
`isBounceback`	`STRING`
`subscriptionDate`	`STRING`
`unsubscriptionDate`	`STRING`
`bouncebackDate`	`STRING`
`currentStatus`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`fieldValues`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, value STRING>>`
`accountId`	`STRING`
`description`	`STRING`
`emailFormatPreference`	`STRING`
`fax`	`STRING`
`permissions`	`STRING`

`account`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`fieldValues`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, value STRING>>`
`address1`	`STRING`
`address2`	`STRING`
`address3`	`STRING`
`businessPhone`	`STRING`
`city`	`STRING`
`country`	`STRING`
`crmSystemMappings`	`VARIANT`
`currentStatus`	`STRING`
`permissions`	`STRING`
`postalCode`	`STRING`
`province`	`STRING`

Note

This table does not support slowly changing dimension (SCD) type 2 because it has VARIANT columns.

`campaign`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`campaignType`	`STRING`
`campaignCategory`	`STRING`
`currentStatus`	`STRING`
`isEmailMarketingCampaign`	`STRING`
`isIncludedInROI`	`STRING`
`isMemberAllowedReEntry`	`STRING`
`isReadOnly`	`STRING`
`isSyncedWithCRM`	`STRING`
`memberCount`	`STRING`
`actualCost`	`STRING`
`budgetedCost`	`STRING`
`crmId`	`STRING`
`folderId`	`STRING`
`product`	`STRING`
`region`	`STRING`
`runAsUserId`	`STRING`
`scheduledFor`	`STRING`
`sourceTemplateId`	`STRING`
`startAt`	`STRING`
`endAt`	`STRING`
`firstActivation`	`STRING`
`badgeId`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`elements`	`VARIANT`
`adCampaignId`	`STRING`
`campaignClassification`	`STRING`
`clrEndDate`	`STRING`
`createdByName`	`STRING`
`crmIds`	`VARIANT`
`fieldValues`	`VARIANT`
`isBypassHistoryDisabled`	`STRING`
`isExitHistoryDisabled`	`STRING`
`isUpdatingCrmId`	`STRING`
`permissions`	`ARRAY<STRING>`
`referenceProduct`	`STRING`
`updatedByName`	`STRING`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`email`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`name`	`STRING`
`subject`	`STRING`
`currentStatus`	`STRING`
`archived`	`STRING`
`bounceBackEmail`	`STRING`
`isContentProtected`	`STRING`
`isPlainTextEditable`	`STRING`
`isPrivate`	`STRING`
`isTracked`	`STRING`
`plainText`	`STRING`
`renderMode`	`STRING`
`replyToEmail`	`STRING`
`replyToName`	`STRING`
`sendPlainTextOnly`	`STRING`
`senderEmail`	`STRING`
`senderName`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`htmlContent`	`VARIANT`
`hyperlinks`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, href STRING>>`
`forms`	`VARIANT`
`attachments`	`VARIANT`
`brandId`	`STRING`
`contentSections`	`VARIANT`
`contentServiceInstances`	`VARIANT`
`createdByName`	`STRING`
`description`	`STRING`
`dynamicContents`	`VARIANT`
`emailFooterId`	`STRING`
`emailGroupId`	`STRING`
`emailHeaderId`	`STRING`
`encodingId`	`STRING`
`fieldMerges`	`VARIANT`
`files`	`VARIANT`
`folderId`	`STRING`
`images`	`VARIANT`
`layout`	`STRING`
`permissions`	`ARRAY<STRING>`
`previewText`	`STRING`
`scheduledFor`	`STRING`
`sourceTemplateId`	`STRING`
`style`	`STRING`
`thumbnailUrl`	`STRING`
`updatedByName`	`STRING`
`virtualMTAId`	`STRING`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`form`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`name`	`STRING`
`htmlName`	`STRING`
`description`	`STRING`
`currentStatus`	`STRING`
`folderId`	`STRING`
`formJson`	`STRING`
`isFormSpamProtectionEnabled`	`STRING`
`isHidden`	`STRING`
`isResponsive`	`STRING`
`processingType`	`STRING`
`size`	`STRUCT<type STRING, width STRING, height STRING>`
`style`	`STRING`
`submitFailedLandingPageId`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`elements`	`VARIANT`
`archived`	`STRING`
`createdByName`	`STRING`
`customCSS`	`STRING`
`defaultKeyFieldMapping`	`VARIANT`
`externalIntegrationUrl`	`STRING`
`html`	`STRING`
`permissions`	`ARRAY<STRING>`
`processingSteps`	`VARIANT`
`scheduledFor`	`STRING`
`sourceTemplateId`	`STRING`
`updatedByName`	`STRING`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`form_submission`

Primary key: form_id, id Sync mode: Incremental Cursor field: submittedAt

Field	Data type
`form_id`	`STRING`
`id`	`STRING`
`submittedAt`	`STRING`
`submittedByContactId`	`STRING`
`currentStatus`	`STRING`
`type`	`STRING`
`fieldValues`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, value STRING>>`
`correlationId`	`STRING`
`processedAt`	`STRING`
`processingStepErrors`	`VARIANT`
`rowId`	`STRING`
`validationErrors`	`VARIANT`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`segment`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`type`	`STRING`
`id`	`STRING`
`currentStatus`	`STRING`
`name`	`STRING`
`description`	`STRING`
`permissions`	`ARRAY<STRING>`
`folderId`	`STRING`
`sourceTemplateId`	`STRING`
`createdBy`	`STRING`
`createdByName`	`STRING`
`createdAt`	`STRING`
`updatedBy`	`STRING`
`updatedByName`	`STRING`
`updatedAt`	`STRING`
`scheduledFor`	`STRING`
`count`	`STRING`
`lastCalculatedAt`	`STRING`
`isStale`	`STRING`
`dependencyName`	`STRING`
`elements`	`ARRAY<STRUCT<type STRING, id STRING, currentStatus STRING, name STRING, description STRING, permissions ARRAY<STRING>, folderId STRING, sourceTemplateId STRING, createdBy STRING, createdByName STRING, createdAt STRING, updatedBy STRING, updatedByName STRING, updatedAt STRING, scheduledFor STRING, isIncluded STRING, count STRING, lastCalculatedAt STRING, filter STRING>>`

`contact_list`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`folderId`	`STRING`
`count`	`STRING`
`dataLookupId`	`STRING`
`scope`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`currentStatus`	`STRING`
`membershipAdditions`	`ARRAY<STRING>`
`membershipDeletions`	`ARRAY<STRING>`
`permissions`	`STRING`

`option_list`

Primary key: id Sync mode: Full refresh only

Field	Data type
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`elements`	`ARRAY<STRUCT<type STRING, displayName STRING, value STRING>>`
`currentStatus`	`STRING`
`permissions`	`STRING`

`event_registration`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`folderId`	`STRING`
`currentStatus`	`STRING`
`createdBy`	`STRING`
`updatedBy`	`STRING`
`createdAt`	`STRING`
`updatedAt`	`STRING`
`fields`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, internalName STRING, dataType STRING, displayType STRING, defaultValue STRING, depth STRING, createdByName STRING, updatedByName STRING, checkedValue STRING, uncheckedValue STRING>>`
`sessions`	`ARRAY<STRUCT<type STRING, id STRING, name STRING>>`
`createdByName`	`STRING`
`emailAddressFieldId`	`STRING`
`eventGroupByFieldId`	`STRING`
`permissions`	`ARRAY<STRING>`
`scheduledFor`	`STRING`
`sessionFieldValues`	`VARIANT`
`sessionFields`	`VARIANT`
`sourceTemplateId`	`STRING`
`uniqueCodeFieldId`	`STRING`
`updatedByName`	`STRING`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`user_info`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`type`	`STRING`
`id`	`STRING`
`currentStatus`	`STRING`
`name`	`STRING`
`description`	`STRING`
`permissions`	`ARRAY<STRING>`
`folderId`	`STRING`
`sourceTemplateId`	`STRING`
`createdBy`	`STRING`
`createdByName`	`STRING`
`createdAt`	`STRING`
`updatedBy`	`STRING`
`updatedByName`	`STRING`
`updatedAt`	`STRING`
`scheduledFor`	`STRING`
`loginName`	`STRING`
`emailAddress`	`STRING`
`federationId`	`STRING`
`firstName`	`STRING`
`lastName`	`STRING`
`preferences`	`STRUCT<type STRING, timezoneId STRING>`
`typePermissions`	`VARIANT`
`capabilities`	`ARRAY<STRING>`
`betaAccess`	`ARRAY<STRING>`
`defaultContactViewId`	`STRING`
`defaultAccountViewId`	`STRING`
`securityGroups`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, description STRING, acronym STRING, createdAt STRING, createdBy STRING, createdByName STRING, updatedAt STRING, updatedBy STRING, updatedByName STRING, isReadOnly STRING, isEffective STRING, depth STRING>>`
`interfacePermissions`	`VARIANT`
`productPermissions`	`ARRAY<STRUCT<type STRING, productCode STRING>>`
`isUsingBrightenTemplate`	`STRING`
`shortcuts`	`ARRAY<STRING>`
`isDeleted`	`STRING`
`isDisabled`	`STRING`
`jobTitle`	`STRING`
`companyDisplayName`	`STRING`
`companyUrl`	`STRING`
`phone`	`STRING`
`crmUsername`	`STRING`
`crmUserNames`	`STRUCT<type STRING, SFDCUserName STRING, MSDUserName STRING, SODUserName STRING>`
`passwordExpires`	`STRING`
`sendWelcomeEmail`	`STRING`
`cellPhone`	`STRING`
`address1`	`STRING`
`address2`	`STRING`
`replyToAddress`	`STRING`
`department`	`STRING`
`fax`	`STRING`
`personalUrl`	`STRING`
`personalMessage`	`STRING`
`ssoOnly`	`STRING`
`digitalSignatureId`	`STRING`
`personalPhotoId`	`STRING`
`city`	`STRING`
`state`	`STRING`
`country`	`STRING`
`zipCode`	`STRING`
`senderEmailAddress`	`STRING`
`senderDisplayName`	`STRING`
`isAssetManager`	`STRING`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`visitor`

Primary key: visitorId Sync mode: Incremental Cursor field: V_LastVisitDateAndTime

Field	Data type
`visitorId`	`STRING`
`externalId`	`STRING`
`contactId`	`STRING`
`currentStatus`	`STRING`
`type`	`STRING`
`V_IPAddress`	`STRING`
`V_Total_Visits`	`STRING`
`V_FirstVisitDateAndTime`	`STRING`
`V_LastVisitDateAndTime`	`STRING`
`createdAt`	`STRING`
`V_Name`	`STRING`
`V_HostName`	`STRING`
`V_Browser_Type`	`STRING`
`V_ISPFromIP`	`STRING`
`V_CityFromIP`	`STRING`
`V_ProvinceFromIP`	`STRING`
`V_CountryFromIP`	`STRING`
`V_ZipCodeFromIP`	`STRING`
`V_LatitudeFromIP`	`STRING`
`V_LongitudeFromIP`	`STRING`
`V_TimeZoneOffsetMin`	`STRING`
`V_CompanyNameFromIP1`	`STRING`
`V_CompanyDNSName`	`STRING`
`V_Total_Pages`	`STRING`
`V_Total_Time`	`STRING`
`V_Current_Total_Pages`	`STRING`
`V_Current_Visit_Length`	`STRING`
`V_FirstPageInVisit`	`STRING`
`V_LastPageInVisit`	`STRING`
`id`	`STRING`

`event_registration_registrant`

Primary key: event_registration_id, id Sync mode: Full refresh only

Field	Data type
`event_registration_id`	`STRING`
`type`	`STRING`
`id`	`STRING`
`currentStatus`	`STRING`
`name`	`STRING`
`description`	`STRING`
`permissions`	`ARRAY<STRING>`
`folderId`	`STRING`
`sourceTemplateId`	`STRING`
`createdBy`	`STRING`
`createdByName`	`STRING`
`createdAt`	`STRING`
`updatedBy`	`STRING`
`updatedByName`	`STRING`
`updatedAt`	`STRING`
`scheduledFor`	`STRING`
`contactId`	`STRING`
`accountId`	`STRING`
`uniqueCode`	`STRING`
`customObjectRecordStatus`	`STRING`
`isMapped`	`STRING`
`fieldValues`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, value STRING>>`

`custom_object`

Primary key: custom_object_id, id Sync mode: Full refresh only

Field	Data type
`custom_object_id`	`STRING`
`type`	`STRING`
`id`	`STRING`
`currentStatus`	`STRING`
`name`	`STRING`
`description`	`STRING`
`permissions`	`ARRAY<STRING>`
`folderId`	`STRING`
`sourceTemplateId`	`STRING`
`createdBy`	`STRING`
`createdByName`	`STRING`
`createdAt`	`STRING`
`updatedBy`	`STRING`
`updatedByName`	`STRING`
`updatedAt`	`STRING`
`scheduledFor`	`STRING`
`contactId`	`STRING`
`accountId`	`STRING`
`uniqueCode`	`STRING`
`customObjectRecordStatus`	`STRING`
`isMapped`	`STRING`
`fieldValues`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, value STRING>>`

`landing_page`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`description`	`STRING`
`folderId`	`STRING`
`sourceTemplateId`	`STRING`
`micrositeId`	`STRING`
`relativePath`	`STRING`
`deployedAt`	`STRING`
`refreshedAt`	`STRING`
`isHidden`	`STRING`
`isContentProtected`	`STRING`
`isExpiryEnabled`	`STRING`
`expiresAt`	`STRING`
`expiryRedirectUrl`	`STRING`
`createdBy`	`STRING`
`createdByName`	`STRING`
`createdAt`	`STRING`
`updatedBy`	`STRING`
`updatedByName`	`STRING`
`updatedAt`	`STRING`
`permissions`	`ARRAY<STRING>`
`autoCloseWaitFor`	`STRING`
`autoRedirectUrl`	`STRING`
`autoRedirectWaitFor`	`STRING`
`contentSections`	`VARIANT`
`contentServiceInstances`	`VARIANT`
`currentStatus`	`STRING`
`displayTimeZoneId`	`STRING`
`dynamicContents`	`VARIANT`
`excludeFromAuthentication`	`STRING`
`files`	`VARIANT`
`forms`	`VARIANT`
`htmlContent`	`VARIANT`
`hyperlinks`	`ARRAY<STRUCT<type STRING, id STRING, name STRING, href STRING>>`
`images`	`VARIANT`
`layout`	`STRING`
`scheduledFor`	`STRING`
`style`	`STRING`
`thumbnailUrl`	`STRING`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`email_group`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`description`	`STRING`
`displayName`	`STRING`
`folderId`	`STRING`
`emailIds`	`ARRAY<STRING>`
`subscriptionListId`	`STRING`
`unSubscriptionListId`	`STRING`
`emailHeaderId`	`STRING`
`emailFooterId`	`STRING`
`isVisibleInPublicSubscriptionList`	`STRING`
`createdBy`	`STRING`
`createdAt`	`STRING`
`updatedBy`	`STRING`
`updatedAt`	`STRING`
`permissions`	`ARRAY<STRING>`
`currentStatus`	`STRING`
`isVisibleInOutlookPlugin`	`STRING`
`subscriptionLandingPageId`	`STRING`
`subscriptionListDataLookupId`	`STRING`
`unSubscriptionListDataLookupId`	`STRING`
`unsubscriptionLandingPageId`	`STRING`

`program`

Primary key: id Sync mode: Incremental Cursor field: updatedAt

Field	Data type
`id`	`STRING`
`type`	`STRING`
`name`	`STRING`
`description`	`STRING`
`currentStatus`	`STRING`
`folderId`	`STRING`
`sourceTemplateId`	`STRING`
`isReadOnly`	`STRING`
`isExitHistoryDisabled`	`STRING`
`isBypassHistoryDisabled`	`STRING`
`isMemberAllowedDuplicates`	`STRING`
`runAsUserId`	`STRING`
`defaultEntityType`	`STRING`
`defaultEntityId`	`STRING`
`scheduledFor`	`STRING`
`createdBy`	`STRING`
`createdByName`	`STRING`
`createdAt`	`STRING`
`updatedBy`	`STRING`
`updatedByName`	`STRING`
`updatedAt`	`STRING`
`permissions`	`ARRAY<STRING>`
`elements`	`VARIANT`

Note

This table does not support SCD type 2 because it has VARIANT columns.

`activity_email_send`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`AssetId`	`STRING`
`AssetName`	`STRING`
`AssetType`	`STRING`
`EmailAddress`	`STRING`
`CampaignResponseDate`	`STRING`
`EmailRecipientId`	`STRING`
`MemberStatus`	`STRING`
`EmailDeploymentID`	`STRING`
`EmailSendType`	`STRING`
`EmailWebLink`	`STRING`
`SubjectLine`	`STRING`

`activity_email_open`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`AssetId`	`STRING`
`AssetName`	`STRING`
`AssetType`	`STRING`
`EmailAddress`	`STRING`
`CampaignResponseDate`	`STRING`
`EmailRecipientId`	`STRING`
`MemberStatus`	`STRING`
`VisitorExternalId`	`STRING`
`VisitorId`	`STRING`
`EmailDeploymentID`	`STRING`
`IpAddress`	`STRING`
`EmailSendType`	`STRING`
`EmailWebLink`	`STRING`
`SubjectLine`	`STRING`

`activity_email_clickthrough`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`AssetId`	`STRING`
`AssetName`	`STRING`
`AssetType`	`STRING`
`EmailAddress`	`STRING`
`CampaignResponseDate`	`STRING`
`EmailRecipientId`	`STRING`
`MemberStatus`	`STRING`
`VisitorExternalId`	`STRING`
`VisitorId`	`STRING`
`EmailDeploymentID`	`STRING`
`IpAddress`	`STRING`
`EmailSendType`	`STRING`
`EmailWebLink`	`STRING`
`SubjectLine`	`STRING`
`EmailClickedThruLink`	`STRING`
`EmailClickthroughSavedId`	`STRING`

`activity_subscribe`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`AssetId`	`STRING`
`AssetName`	`STRING`
`AssetType`	`STRING`
`EmailAddress`	`STRING`
`EmailRecipientId`	`STRING`

`activity_unsubscribe`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`AssetId`	`STRING`
`AssetName`	`STRING`
`AssetType`	`STRING`
`EmailAddress`	`STRING`
`EmailRecipientId`	`STRING`

`activity_bounceback`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`AssetId`	`STRING`
`AssetName`	`STRING`
`AssetType`	`STRING`
`EmailAddress`	`STRING`
`EmailRecipientId`	`STRING`
`EmailDeploymentID`	`STRING`
`SmtpErrorCode`	`STRING`
`SmtpMessage`	`STRING`
`SmtpStatusCode`	`STRING`

`activity_form_submit`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`AssetId`	`STRING`
`AssetName`	`STRING`
`AssetType`	`STRING`
`CampaignResponseDate`	`STRING`
`MemberStatus`	`STRING`
`VisitorExternalId`	`STRING`
`VisitorId`	`STRING`
`FormSubmitSavedId`	`STRING`
`RawData`	`STRING`

`activity_page_view`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`CampaignResponseDate`	`STRING`
`MemberStatus`	`STRING`
`VisitorExternalId`	`STRING`
`VisitorId`	`STRING`
`IpAddress`	`STRING`
`LinkedToContactDate`	`STRING`
`ReferrerUrl`	`STRING`
`IsWebTrackingOptedIn`	`STRING`
`PageViewSavedId`	`STRING`
`Url`	`STRING`
`WebVisitId`	`STRING`

`activity_web_visit`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`VisitorExternalId`	`STRING`
`VisitorId`	`STRING`
`IpAddress`	`STRING`
`LinkedToContactDate`	`STRING`
`ReferrerUrl`	`STRING`
`Duration`	`STRING`
`FirstPageViewUrl`	`STRING`
`NumberOfPages`	`STRING`
`WebVisitSavedId`	`STRING`

`activity_external_activity`

Primary key: ExternalId Sync mode: Incremental Cursor field: ActivityDate

Field	Data type
`ActivityDate`	`STRING`
`ActivityType`	`STRING`
`ContactId`	`STRING`
`ExternalId`	`STRING`
`Id`	`STRING`
`CampaignId`	`STRING`
`CampaignName`	`STRING`
`ExternalCampaignId`	`STRING`
`EmailAddress`	`STRING`
`CampaignResponseDate`	`STRING`
`MemberStatus`	`STRING`
`ExternalActivityType`	`STRING`
`ExternalAssetName`	`STRING`
`ExternalAssetType`	`STRING`

`contact_list_contact`

Primary key: contact_list_id, contact_id Sync mode: Full refresh only

Field	Data type
`contact_list_id`	`STRING`
`contact_id`	`STRING`

`contact_segment`

Primary key: segment_id, contact_id Sync mode: Full refresh only

Field	Data type
`segment_id`	`STRING`
`contact_id`	`STRING`

Feedback

Was this page helpful?

Last updated on 2026-10-30

Oracle Eloqua connector reference

Supported source tables

Source APIs

Connector options

Destination table schemas

contact

account

campaign

email

form

form_submission

segment

contact_list

option_list

event_registration

user_info

visitor

event_registration_registrant

custom_object

landing_page

email_group

program

activity_email_send

activity_email_open

activity_email_clickthrough

activity_subscribe

activity_unsubscribe

activity_bounceback

activity_form_submit

activity_page_view

activity_web_visit

activity_external_activity

contact_list_contact

contact_segment

Feedback

Additional resources

`contact`

`account`

`campaign`

`email`

`form`

`form_submission`

`segment`

`contact_list`

`option_list`

`event_registration`

`user_info`

`visitor`

`event_registration_registrant`

`custom_object`

`landing_page`

`email_group`

`program`

`activity_email_send`

`activity_email_open`

`activity_email_clickthrough`

`activity_subscribe`

`activity_unsubscribe`

`activity_bounceback`

`activity_form_submit`

`activity_page_view`

`activity_web_visit`

`activity_external_activity`

`contact_list_contact`

`contact_segment`