Eloqua Overview

Oracle Eloqua equips marketers with best-in-class lead and campaign management tools that help marketers engage the right audience at the right time in the buyer’s journey while providing real-time reporting and insights.

Featureslink

Setup guidelink

Follow our step-by-step Eloqua setup guide to connect Eloqua with your destination using Fivetran connectors.

Schema informationlink

This schema applies to all Eloqua connections.

Sync overviewlink

Fivetran uses both the REST API and Bulk API to sync your data from Eloqua.

We use the REST API to sync the following tables:

• ACCOUNT
• CAMPAIGN
• CONTACT
• CONTACT_FILTER
• CONTACT_FILTER_SEGMENT_ELEMENT
• CONTACT_LIST
• CONTACT_LIST_SEGMENT_ELEMENT
• EMAIL
• EMAIL_FORM
• EMAIL_HYPERLINK
• FORM
• FORM_SUBMISSION
• SEGMENT
• USER_INFO
• VISITOR

We use the Bulk API to sync the following:

• Custom objects.

• CONTACT_ACTIVITY table. For more information, see Eloqua’s exporting activities documentation.

• CONTACT_SEGEMENT table.

• CONTACT_LIST_CONTACT table.

  NOTE: The CONTACT_SEGEMENT and CONTACT_LIST_CONTACT tables are part of our Contact list endpoints and Contact segment endpoints support. If you want to sync these tables, contact our support team.

For more information, see Eloqua’s export data documentation.

Sync notelink

We can’t use the time criteria in our activities requests because the Eloqua Bulk API only allows date values for the createdAt parameter.

Therefore, we sync the CONTACT_ACTIVITY table once a day. For example, we can query the CONTACT_ACTIVITY table using startDate > 30-04-2020 to endDate < 10-05-2020. However, we can’t use time-based queries, such as startDate > 30-04-2020 01:00:00 to endDate < 30-04-2020 23:59:59.