Creating an Oracle Eloqua destination

The first step in setting up an export of data to Oracle Eloqua is to create a destination. This will configure how the Oracle Unity segment will be exported to Eloqua.

You will need to set up a template of field mapping between Oracle Unity and Eloqua data.

To create the Eloqua destination:

  1. Click the Oracle icon Image of the application navigation button. Use it to access the different parts of Oracle Unity. in the bottom-right corner to open the navigation menu.
  2. Select Destinations.
  3. In the top-right corner, click Create destination.

Step 1: Define destination details

The job details section allows you to define the type of destination and how it will display in Oracle Unity.

Enter the information for the destination.

    An image of the destination type Eloqua

  • Type: Use the drop-down list to select Eloqua.
  • Name: Enter a name. The name must be 1 or more characters, up to a maximum of 50. Use only letters (a–z and A–Z), numbers (0–9), underscores (_), hyphens (-), and spaces. The first character cannot be a space.

  • Destination ID: The unique system identifier that is auto-populated from the destination name you enter. You can't change this value after you create the destination.

  • Description: Enter a description. This field is optional, but it is highly recommended to add descriptions for any entity created. This helps all other users get additional context when using and navigating Oracle Unity. The description can have a maximum of 512 characters with no restrictions on characters used. You can use characters from all languages supported in the language settings.

Step 2: Configure authentication settings

Enter the information to allow Oracle Unity to access the required data.

  • Company name: Enter the company name you use to log in to Eloqua.
  • URL: Enter the base URL for your Eloqua instance. Learn more about Determining base URLs topic from the the Eloqua Developer Help Center.
  • Username: Enter the username to access the URL.
  • Password: Enter the password to access the URL.

Once you enter all the details, click Verify connection to ensure that Oracle Unity can access the destination.

An image of the authentication section

If there are connection issues, ensure the base URL entered and login credentials are correct.

Step 3: Field mapping

This section allow you to set up a field mapping template for the campaign or export job that will use the destination. You will need to set up mapping between Oracle Unity data attributes (segmentation personalization attributes) and Eloqua custom object fields.

  • If you use the destination in an export job, you can update the field mapping when configuring the export job.
  • If you use the destination in a campaign, you can only update the field mapping in the configuration of the destination.

Watch this video to learn more about custom objects and how data records are inserted into custom objects: Oracle Eloqua - Creating Field Merges with Custom Data Objects.

Note: When a Oracle Unity campaign sends segment data to Eloqua, there may be customer records in the Oracle Unity segment that don't exist in the Eloqua custom object. In this type of scenario, the missing records will be automatically added to the contacts table in Eloqua.

To add field mappings:

  1. For Eloqua object, select the Eloqua custom object you want to use for mapping. Then, click AddImage of the add button. Use it to create a new attribute for a data object..

    2. An image of the Eloqua object field

  2. For Identifier field, enter the exact name of a unique field (for example, Email) in the custom object that will be used to check the imported data in Eloqua against existing records. In other words, select the field that will be used as the primary key for the custom object.

    3. An image of the Identifier field

  3. For Linked object, you have the option of selecting a parent object. Otherwise, leave the selection as None.
    • If you select a linked object, you will have to map a unique Oracle Unity attribute to a unique field in the Eloqua linked object. Enter the exact name of the Oracle Unity attribute and select the corresponding Eloqua linked object field.

    4. An image of the field mapping fields for linked objects

  4. Under Unity data attribute, enter the exact name of an attribute (segmentation personalization attribute) to map. Under Eloqua custom object field, select a corresponding field to map. The list of Eloqua custom object fields is retrieved dynamically from Eloqua.

    5. An image of the field mapping between Unity attributes and Eloqua object fields

    Note: If you select the Contact custom object, you must map the Oracle Unity Email attribute to the Email address Eloqua custom object field. You must also make sure the Email attribute is included as a Personalization attribute for the segment you want to export. If this attribute is not included, then the segment will not be exported successfully to Eloqua.

  5. Click Add Image of the add button. Use it to create a new attribute for a data object..

    6. An image of the add icon

  6. Add additional field mappings between Oracle Unity and Eloqua. Once you map an Eloqua contact field, it is removed from the list of available items to select and an indicator shows the number of mappings created.

    7. An image showing the number of fields that are mapped.

  7. To delete a field mapping, click Delete An image of the delete button. .
  8. To map an additional custom object, select one from the Eloqua object field and Click AddImage of the add button. Use it to create a new attribute for a data object.. Continue the previous steps for mapping attributes and fields.

    9. Note: You can create mappings for multiple Eloqua custom objects in a single destination, but each campaign or export job can only export to a single Eloqua custom object. To export one segment to multiple custom objects, you will need to create one export job for each custom object.

    An image of the add button

Step 4: Save and publish the new destination

When finished defining the destination, scroll to the top of the page and click Save or Save and close.

Once you create the destination, you will need to publish the changes.

Exporting to an Eloqua campaign or Eloqua custom object

After creating and publishing the Eloqua destination, you can continue following the steps for exporting to an Eloqua campaign or custom object.

Learn more

Creating segments

Creating destinations

Creating campaigns

integrate, integration, eloqua, how to integrate, oracle eloqua, link, link oracle apps, link oracle eloqua