Send audiences to Oracle Eloqua¶
Oracle Eloqua is a marketing automation platform that helps your brand design and manage cross-channel marketing campaigns.
Send audiences from Amperity to manage shared lists . Shared lists are static lists of contacts that can be used across Oracle Eloqua. Each shared list should contain a list of contacts with a clearly defined relationship to the campaign or program that is managed from Oracle Eloqua.
Amperity will add and remove audience members from a shared list, and then update any contact attributes that are associated with members of that shared list.
Note
The first audience that is sent from Amperity to Oracle Eloqua should be to a new or empty shared list.
Important
This destination uses the Bulk Loader API to send shared lists to Oracle Eloqua.
Review the Bulk API Best Practices to help ensure that Amperity will be successful when importing your shared lists to Oracle Eloqua.
This topic describes the steps that are required to send audiences to Oracle Eloqua from Amperity:
Get details¶
Oracle Eloqua requires the following configuration details:
![]() |
Login information for Oracle Eloqua. This includes:
|
![]() |
The name of the shared list to be managed by Amperity. Use filename templates and/or data templates to configure Amperity to support managing more than one shared list. For example:
Caution You may add custom attributes to the shared list as long as each custom attribute is mapped to the database name that was assigned to the custom contact field by Oracle Eloqua. This approach requires adding an empty shared list to Oracle Eloqua, and then adding any custom contact fields to that shared list. This will generate the database name, which is typically (but not always) prefixed with C_. Use a query to build the results your brand wants to send to Oracle Eloqua. Be sure to map each field in the query results to the database name in Oracle Eloqua. A campaign must use the Edit Attributes dialog box to configure the attributes to be sent, along with ensuring the correct database type mapping from Oracle Eloqua is applied to each field. |
![]() |
The primary key for the shared list: C_EmailAddress. An email address (mapped to the database type C_EmailAddress) is the only requirement for sending audiences to Oracle Eloqua for use as a shared list. Additional attributes may be sent. Some must be mapped to the default attributes ; custom attributes may be defined. |
Add destination¶
Configure Amperity to send audiences directly to Oracle Eloqua.
To add a destination
Add data template¶
A data template defines how columns in Amperity data structures are sent to downstream workflows. A data template is part of the configuration for sending query and segment results from Amperity to an external location.
To add a data template
![]() |
From the Destinations tab, open the menu for a destination that is configured for Oracle Eloqua, and then select Add data template. This opens the Add Data Template dialog box. ![]() Enter the name of the data template and a description. For example: “Oracle Eloqua” and “Send audiences to Oracle Eloqua.”. |
![]() |
Verify business user access to queries and orchestrations and access to segments and campaigns. A business user may also have restricted access to PII, which prevents them from viewing and sending customer profile data. ![]() If business user access was not configured as part of the destination, you may configure access from the data template. |
![]() |
Verify all configuration settings. ![]() Note When the shared list name and primary key are not configured as part of the destination, you must configure them as part of the data template before making this destination available to campaigns. |
![]() |
Review all settings, and then click Save. ![]() After you have saved the data template, and depending on how you configured it, business users can send query results and/or send campaigns to Oracle Eloqua. |