Back

This article describes how to set up the Oracle Eloqua connector service in your Universal 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.
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
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.