Eloqua Connector

Oracle Eloqua is marketing automation software that helps businesses optimize their marketing processes, from campaigns to leads to pipeline management. Use the Birst Eloqua Connector to extract data from these Eloqua objects:

Account

Activity

Campaign

Campaign_Element

Campaign_Element_OutputTerminal

Contact

Custom object

Form

Form_FormField

FormData

Landing Page

Implementation and Usage Notes

The Eloqua Connector uses the Eloqua Bulk API to extract Account, Activity, Contact, and custom objects.

For Campaign, Email, Form, FormData and LandingPage objects it uses the REST API.

All objects extracted using the REST API will include deleted records.

Performance degradation may occur when extracting FormData or LandingPage objects.

Campaign_Element and Campaign_Element_OutputTerminal are Campaign sub-objects. Form_FormField is Form sub-object.

Eloqua has 9 activity types that are extracted by the Eloqua Connector into the following objects: Activity_BounceBack, Activity_EmailClickThrough, Activity_EmailOpen, Activity_EmailSend, Activity_FormSubmit, Activity_PageView, Activity_Subscribe, Activity_Unsubscribe, and Activity_WebVisit.

Activity objects are generated by Eloqua and users cannot modify or delete them.

The Eloqua Connector can extract up to 100 fields per object. If an object contains more than 100 fields, use the Add Objects feature and select only the fields you really need. See Adding a Source Based on an Eloqua Object.

Eloqua has two campaign elements, CampaignMoveToCampaignAction and CampaignAddToCampaignAction, that each have their own "campaignId" field. The name of the field conflicts with another "campaignId" field that refers to the parent campaign of the campaign elements. Birst handles campaignId as follows:

CampaignId refers to ID of the parent campaign of each campaign element.

CampaignId_ref is new name of the "campaignId" field of each campaign element.

Default paging is 1000 rows.

For objects created using Add Objects, do not use the "Rows in data source are transactions" option in the Data Source Properties. Use Selection Criteria instead.

Timeouts may occur for extracts that return more than 5,000,000 records. Improve the selection criteria to reduce the number of rows in the result. See the Eloqua documentation. Page size has no relevance to this issue.

For general usage notes see Connect to Cloud Applications Using Application Connectors.

Next Steps

See Extracting Data from Eloqua.