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 |
- 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 |
- 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 |
- 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 |
|
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 |
- 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 |
- 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 |
|
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 |
|
Record Lookup |
|
Record create data to set |
|
Record update data to set |
|