Send audiences to Oracle Eloqua

Note

This topic contains information about configuring a destination that sends query results to Oracle Eloqua using orchestrations. To configure a destination that sends audiences to Oracle Eloqua using campaigns see this topic .

Oracle Eloqua is an automation platform for email and SMS marketing. Use the Oracle Eloqua REST API to manage audiences in Oracle Eloqua.

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. The first audience that is sent from Amperity to Oracle Eloqua should be to a new or empty 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.

Get details

Review the following details before configuring credentials for Oracle Eloqua and before configuring Amperity to send audiences to Oracle Eloqua.

Detail 1.

Credential settings

Username

Required

Required. A username with access to Oracle Eloqua. This username must be allowed to write data to the remote folder to which Amperity will send data.

Password

Required

The password associated with the Oracle Eloqua username.

Company name

Required

The name of your company, as used within your Oracle Eloqua account.

Detail 2.

Shared list configuration

Provide the name of the shared list (or lists) to be managed by Amperity.

Use C_EmailAddress as the primary key for the shared list.

An email address that is mapped to the primary key 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.

Use filename templates to configure Amperity to support managing more than one shared list. For example a timestamp at the end

Early_Purchasers_{{format:'MM-dd-yyyy'}}.csv

will create a new shared list each time an audience is sent from Amperity. The shared list will always be titled “Early Purchasers”, but will have a unique datestamp.

A campaign that is configured only for campaign name and group name

{{ campaign_name }} - {{ group_name }}

will update the same shared list each time the audience is sent from Amperity.

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.

Configure credentials

Configure credentials for Oracle Eloqua before adding a destination.

An individual with access to Oracle Eloqua should use SnapPass to securely share “username”, “password”, and “company name” details with the individual who will configure Amperity.

To configure credentials for Oracle Eloqua

Step 1.

From the Settings page, select the Credentials tab, and then click the Add credential button.

Step 2.

In the Credentials settings dialog box, do the following:

From the Plugin dropdown, select Oracle Eloqua.

Assign the credential a name and description that ensures other users of Amperity can recognize when to use this destination.

Step 3.

The settings that are available for a credential are determined by the credential type. For the “eloqua” credential type, configure settings, and then click Save.

Username

Required

Required. A username with access to Oracle Eloqua. This username must be allowed to write data to the remote folder to which Amperity will send data.

Password

Required

The password associated with the Oracle Eloqua username.

Company name

Required

The name of your company, as used within your Oracle Eloqua account.

Add destination

Use a sandbox to configure a destination for Oracle Eloqua. Before promoting your changes, send a test audience, and then verify the the results in Oracle Eloqua. After the end-to-end workflow has been verified, push the destination from the sandbox to production.

To add a destination for Oracle Eloqua

Step 1.

Open the Destinations page, and then click the Add destination button.

Add

To configure a destination for Oracle Eloqua, do one of the following:

  1. Click the row in which Oracle Eloqua is located. Destinations are listed alphabetically and you can scroll up and down the list.

  2. Search for Oracle Eloqua. Start typing “oracle”. The list will filter to show only matching destinations. Select “Oracle Eloqua”.

Step 2.

Select the credential for Oracle Eloqua from the Credential drop-down, and then click Continue.

Tip

Click the “Test connection” link on the “Configure destination” page to verify that Amperity can connect to Oracle Eloqua.

Step 3.

In the “Destination settings” dialog box, assign the destination a name and description that ensures other users of Amperity can recognize when to use this destination.

Configure business user access

By default a destination is available to all users who have permission to view personally identifiable information (PII).

Enable the Admin only checkbox to restrict access to only users assigned to the Datagrid Operator and Datagrid Administrator policies.

Enable the PII setting checkbox to allow users with limited access to PII access to this destination.

Restricted PII access is enabled when the Restrict PII access policy option that prevents users who are assigned to that option from viewing data that is marked as PII anywhere in Amperity and from sending that data to any downstream workflow.

Step 4.

Configure the following settings, and then click “Save”.

Shared list name (Required at orchestration)

The name of the shared list to be managed by Amperity.

Use filename templates to configure Amperity to support managing more than one shared list. For example:

  1. A timestamp at the end of a filename template—Early_Purchasers_{{format:’MM-dd-yyyy’}}.csv—will create a new shared list each time an audience is sent from Amperity. The shared list will always be titled “Early Purchasers”, but will have a unique datestamp.

  2. A campaign that is configured only for campaign name and group name—{{ campaign_name }} - {{ group_name }}—will update the same shared list each time the audience is sent from Amperity.

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

Audience primary key

Required

The primary key for the audience. Set to “C_EmailAddress”.

Step 5.

After this destination is configured, users may configure Amperity to:

  • Use orchestrations to send query results

  • Use orchestrations and campaigns to send audiences

  • Use orchestrations and campaigns to send offline events

to Oracle Eloqua.