Eloqua Connector Setup Guide

[#1]

This article describes how to set up the Oracle Eloqua connector service in your Customer Data Hub account.

In this article:

Table of Contents Placeholder

Requirements

• Eloqua account
• Company name for your Eloqua account
• Username for your Eloqua account
• Password for your Eloqua account

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 required settings:

• Company
• Username
• Password

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.  Only the first 1000 Shared Lists are retrieved from your account. If you cannot find a specific Shared List, use the "Custom Text" option, providing only the numeric ID of the Shared List. Entering the text name may result in errors.
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. 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 the following 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. 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 the following 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, Create, or Update. Contact Fields – if "API Contact ID" is not specified, these fields will be used to search for the Target Contact. 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 the following format: yyyy-MM-dd HH:mm:ss
Create Contact Data	Required if Update Strategy is Create Only, 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, 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. 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 the following 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. 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 the following 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. 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 the following 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 the following 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 the following format: yyyy-MM-dd HH:mm:ss
Target Custom Object	Required. The Custom Object to create or update a record in.
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. Only 50 records (related to the Contact Lookup) are searched. Date attributes are converted to the following 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. 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. Date attributes are converted to Unix timestamp in seconds.