Eloqua Connector Setup Guide

Eloqua Connector Setup Guide

by on ‎02-08-2018 05:35 PM - edited a week ago by Community Manager (414 Views)

With the Oracle Eloqua Connector, marketers can plan and execute campaigns while delivering a personalized customer experience for their prospects. Campaigns greatly scale for audiences across channels including email, display search, video, and mobile. This article describes how to set up the Oracle Eloqua Connector service in your Universal Data Hub account.

Table of Contents Placeholder

Requirements

  • Eloqua account
  • Eloqua-provided company name
  • Username
  • Password

Supported Actions

Action Name AudienceStream EventStream
Add Contact to Shared List
Remove Contact from Shared List
Insert or Update Contact
Insert Contact
Update Contact
Subscribe Contact to Email Group
Unsubscribe Contact from Email Group
Insert Custom Object Data for Contact
Insert or Update Custom Object Data for Contact

Configure Settings

Go to the Connector Marketplace and add a new connector. Read the Connector Overview article for general instructions on how to add a Connector.

After adding the connector, configure the following settings:

  • Company: Required
  • Username: Required
  • Password: Required

Action Settings - Parameters and Options

Click Next or go to the Actions tab. This is where you configure connector actions.

This section describes how to set up parameters and options for each action.

Action - Add Contact to Shared List

Parameters

Parameter Description
Target Shared List
  • Required: Target Shared List for the Target Contact
Contact Lookup
  • API Contact ID: Target Contact ID
  • Contact Fields: if "API Contact ID" is not specified, these fields will be used to search for the Target Contact
  • Note: if "API Contact ID" is not specified, an extra API call will be made to search the Target Contact according the fields specified
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'

Action - Remove Contact from Shared List

Parameters

Parameter Description
Target Shared List
  • Required: Target Shared List for the Target Contact
Contact Lookup
  • API Contact ID: Target Contact ID
  • Contact Fields: if "API Contact ID" is not specified, these fields will be used to search for the Target Contact
  • Note: if "API Contact ID" is not specified, an extra API call will be made to search the Target Contact according the fields specified
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'

Action - Insert or Update Contact

Parameters

Parameter Description
Update Strategy
  • Required: Select applicable update strategy.
  • Create Only: Create new contact without lookup.
  • Update Only: Look up an existing contact and update it.
  • Create or Update: Look up an existing contact and if found, update it, otherwise create a new contact.
Contact Lookup
  • Required if Update Strategy is Update Only or Create or Update.
  • Contact Fields: if "API Contact ID" is not specified, these fields will be used to search for the Target Contact
  • Note: if "API Contact ID" is not specified, an extra API call will be made to search the Target Contact according to the fields specified.
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'.
Create Contact Data
  • Required if Update Strategy is Create Only or Create or Update.
  • Map values to create a new contact.
  • Date attributes are converted to unix timestamp in seconds.
Update Contact Data
  • Required if Update Strategy is Update Only or Create or Update.
  • Map values to update an existing contact.
  • Date attributes are converted to unix timestamp in seconds.

Action - Insert Contact

Parameters

Parameter Description
Data To Set
  • Required: map values to contact fields
  • Date attributes are converted to unix timestamp in seconds

Action - Update Contact

Parameters

Parameter Description
Contact Lookup
  • API Contact ID: Target Contact ID
  • Contact Fields: if "API Contact ID" is not specified, these fields will be used to search for the Target Contact
  • Note: if "API Contact ID" is not specified, an extra API call will be made to search the Target Contact according the fields specified
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'
Data To Set
  • Required: map values to contact fields
  • Date attributes are converted to unix timestamp in seconds

Action - Subscribe Contact to Email Group

Parameters

Parameter Description
Target Email Group
  • Required: Target Email Group for the Target Contact
Contact Lookup
  • API Contact ID: Target Contact ID
  • Contact Fields: if "API Contact ID" is not specified, these fields will be used to search for the Target Contact
  • Note: if "API Contact ID" is not specified, an extra API call will be made to search the Target Contact according the fields specified
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'

Action - Unsubscribe Contact from Email Group

Parameters

Parameter Description
Target Email Group
  • Required: Target Email Group for the Target Contact
Contact Lookup
  • API Contact ID: Target Contact ID
  • Contact Fields: if "API Contact ID" is not specified, these fields will be used to search for the Target Contact
  • Note: if "API Contact ID" is not specified, an extra API call will be made to search the Target Contact according the fields specified
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'

Action - Insert Custom Object Data for Contact

Parameters

Parameter Description
Contact Lookup
  • Required, contact is used to map the contact to the Target Custom Object.
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'
Target Custom Object
  • Required
Custom Object Data to Set
  • Required: map values to contact custom object fields
  • Date attributes are converted to unix timestamp in seconds

Action - Insert or Update Custom Object Data for Contact

Parameters

Parameter Description
Contact Lookup
  • Required
  • Contact is used to map the contact to the Target Custom Object
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'
Target Custom Object
Record Lookup
  • Required
  • If a record is found with these fields and values; an update will be performed with the Update Parameters below
  • If no record is found, an insert will be performed with the Insert Parameters below
  • The fields and values must all exist and match for an update to be performed
  • NOTE: Only 50 records (related to the Contact Lookup) are searched
  • Date attributes are converted to format 'yyyy-MM-dd HH:mm:ss'
Record create data to set
  • Required
  • If the record cannot be found, these values will be used for creating the record
  • Note: date attributes are converted to unix timestamp in seconds
Record update data to set
  • Required
  • If the record is found, these values will be used for updating the record
  • Note: date attributes are converted to unix timestamp in seconds