Oracle Eloqua Connector Setup Guide

Requirements

• Oracle Eloqua account
• Company name for your Oracle Eloqua account
• Username for your Oracle Eloqua account
• Password for your Oracle Eloqua account
• If the allow list is enabled for Oracle Eloqua, add the AudienceStream server IP addresses to the Oracle Eloqua allow list.

If the IP addresses are not added to the allow list at Oracle Eloqua or the Oracle Eloqua allow list is not disabled, the Import Definition action will fail with a DD: ELOQUA UNABLE TO RETRIEVE VENDOR ENDPOINT error.

Supported actions

Action Name	AudienceStream	EventStream
Update Contact via Bulk API	✓	✗
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	✓	✗

Batch Limits

This connector uses batched requests to support high-volume data transfers to the vendor. For more information, see Batched Actions. Requests are queued until one of the following thresholds is met or the profile is published:

• Max number of requests: 100,000
• Max time since oldest request: 60 minutes
• Max size of requests: 32 MB

Configure settings

Navigate to the Connector Marketplace and add a new connector. For general instructions on how to add a connector, see the About Connectors article.

After adding the connector, configure the following required settings:

• Company
• Username
• Password

Configure New Import Definition

The import definition creates a structure for your uploaded data. In the definition, you configure the fields you will be uploading to Tealium. You can also configure data syncs to a contact list or an email list.

After you create the import definition, Tealium will automatically synchronize the data when you import it.

Parameter	Description
Import Definition Name	Required. The name of your contact import definition.
Contact Fields	Required. Select contact fields to use during upload.
Identifier Field Name	Required. Select the field to check the imported data against existing records within Oracle Eloqua. It should match one of the Contact Fields and contain unique data for each record.
Optional - Update Rule	Select the action to update values in the Oracle Eloqua database from values imported with this import definition: always: Always update the value. ifNewIsNotNull: Update the value if the new value is not blank. ifExistingIsNull: Update the value if the existing value is blank. useFieldRule: Use the field level-defined rule.
Optional - Sync to Contact List	Select a contact list to sync this contact to.
Optional - Sync to Contact List Action	Select the sync action of the contact list for this import definition: add or remove.
Optional - Sync to Email Group	Select an email group to sync this contact to.
Optional - Sync to Email Group Action	Select the sync action of the email group for this import definition: subscribed or unsubscribed.

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 - Update Contact via Bulk API

The Bulk API queues requests until one of the following thresholds is met or the profile is published:

• Max number of requests: 100,000
• Max time since oldest request: 60 minutes
• Max size of requests: 32 MB

For more information, see Oracle Eloqua Bulk API.

Parameters

Parameter	Description
Contact Import Definition	Required. Select the import definition for this batch upload.
Contact Data	Map attributes to the import definition fields.

Action - Add Contact to Shared List

Only the first 1,000 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.

If “API Contact ID” is not specified, an extra API call will be made to search the Target Contact according to Contact Fields specified in the Contact Lookup parameter.

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, the Contact Fields will be used to search for the Target Contact. Date attributes are converted to the following format: yyyy-MM-dd HH:mm:ss

Action - Remove Contact from Shared List

If “API Contact ID” is not specified, an extra API call will be made to search the Target Contact according to Contact Fields specified in the Contact Lookup parameter.

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, the Contact Fields will be used to search for the Target Contact. Date attributes are converted to the following format: yyyy-MM-dd HH:mm:ss

Action - Insert or Update Contact

If “API Contact ID” is not specified, an extra API call will be made to search the Target Contact according to Contact Fields specified in the Contact Lookup parameter.

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. 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

If “API Contact ID” is not specified, an extra API call will be made to search the Target Contact according to Contact Fields specified in the Contact Lookup parameter.

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. 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

If “API Contact ID” is not specified, an extra API call will be made to search the Target Contact according to Contact Fields specified in the Contact Lookup parameter.

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, the Contact Fields will be used to search for the Target Contact. Date attributes are converted to the following format: yyyy-MM-dd HH:mm:ss

Action - Unsubscribe Contact from Email Group

If “API Contact ID” is not specified, an extra API call will be made to search the Target Contact according to Contact Fields specified in the Contact Lookup parameter.

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, the Contact Fields will be used to search for the Target Contact. 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.