Object-to-Contact Data Appender

Oracle Marketing Cloud - Eloqua
Data Appender

📘

Subscription Required

The Object-to-Contact Data Appender app is a premium app and requires a subscription. To see subscription options or to start a trial, visit our AppCloud. If you don't have an AppCloud account, you'll need to create one first...but no worries, this app may require a subscription but you can create an AppCloud account for free!

App Overview

Use Eloqua Custom Objects as robust, multi-value lookup tables right within the Eloqua platform. Simply create a Custom Object to use as your lookup (the Source), set your match rule, and add all of the Eloqua Contact fields you want to append to a matched (the Target) record.

App Installation

To install the Relationship One Object-to-Contact Data Appender app:

  1. Click on the install URL below:

https://login.eloqua.com/Apps/Cloud/Admin/Catalog/Add/e87ae475-f98c-4eaf-b02a-684c597322ed/96-12-02-F8-E6-E0-3C-96-67-C0-3B-9F-0A-FA-B6-30

👍

IP Allowlisting

If you have Eloqua IP allowlisting enabled, please add AppCloud IPs to your allowlist - 44.236.213.84 and 44.238.209.213.

Please note, the installation process must be done by a user with Eloqua Customer Administrator rights.

  1. Log into Eloqua with your Eloqua Credentials, if required.

  2. Click Accept and Install to add the app to your Eloqua instance.

  3. Click Authenticate Me to grant permission for the app to communicate with Eloqua on your behalf.

28062806
  1. Click Accept or switch users to allow Eloqua to access the app.

  2. Click Save to finish the app installation process.

You will now see the Relationship One Object-to-Contact Data Appender app in the App Catalog inside of your Eloqua instance.

The Relationship One Object-to-Contact Data Appender app is now installed in the App Catalog inside of your Eloqua instance which can be found by clicking on Apps under the Settings menu in the Platform Extensions section. You can select the app to view the app description, modify the configuration settings, reinstall, or uninstall it. You can also check its status and dependencies.

App Configuration

Step 1: Add the Cloud Action

Within the Eloqua Campaign or Program Canvas, find the Object-to-Contact Data Appender Cloud Action in the Actions menu area. Double-click on or drag the Object-to-Contact Data Appender Cloud Action onto your canvas workspace.

11301130

Double click on the cloud action and click the configure button. You will need to save your Campaign or Program before moving onto Step 2.

Step 2: Set The Match Criteria

Select the “Custom Object” that will be used as your lookup table, and the “Custom Object Match Field” you will use to match against. Next, select the “Eloqua Contact Match Field” that will be used to match Eloqua Contacts to the custom object field. Optionally, you can enable a case-sensitive match.

16741674

Click the Continue button to save your settings.

Step 3: Complete The Field Mapping

To map the source Custom Object fields to the target Contact fields, drag the desired source field to its target field. Remove a mapping by dragging a mapped target field to the left. Once you have mapped all of the fields that you want to append, click the Continue button to save your settings.

16941694

Please keep in mind, if you change your mapping, the app will need to restart the export process which may cause a delay as records enter the cloud action step. This is only a temporary delay.

Optionally, you can change the default update rule that should be used when updating an Eloqua Contact record with Custom Object data. By default, mapped Contact fields will always be updated, but you may rather only update when the new value is not blank, if the existing Eloqua Contact field value is blank, or update fields based on the fields individual settings.

16861686

The Object-to-Contact Data Appender app is designed to process and update large volumes of records. Key to this feature, for both speed and scale, is using a caching database where your mapped custom object data fields are stored. If you periodically delete Custom Object records, you want to make sure they also get purged from this cache. The "True Up Frequency" lets you indicate how often this purge should occur - daily, weekly, or monthly. If you do not delete Custom Object records, you do not have to set this or may choose a monthly frequency as a best practice.

16921692

Your Cloud Action has now been configured and is ready for use. You can close the app configuration window by clicking the X in the upper right corner or you can click Back to modify your settings.

The Cloud Action will automatically enable when you activate the Campaign or Program. Remember, there may be a slight delay when processing the first records as the cache gets created.