You can configure connectors to import visitor information from Oracle Eloqua marketing software into Personalization.

Creating an Eloqua connector

To configure a new Eloqua connector:

• Sign in to the Personalization interface, and then click the Configure tab.
• Click the Connectors link.
• In the Select a connector type list, click Eloqua as the connector type that you want to configure.
• Click Add connector. 
  Personalization displays the Eloqua connector configuration settings in JSON format.
• In the Eloqua connector configuration section, enter values in the following fields for the new connector:
  • Initial section
    • name: A descriptive name for your connector based on the type of information it will import (for example, Eloqua email information connector)
    • host: IP address of the Eloqua endpoint
    • accessKey: The Eloqua access key
    • secretKey: The Eloqua secret key
    • accountID: The Personalization account ID
    • customerId: Supplied by Acquia
  • awsConfig section
    • region: Supplied by Acquia
    • dynamoDBTablePrefix: Supplied by Acquia
    • dynamoDBEndpoint: Supplied by Acquia
  • eloquaConfig section:
    • siteName: The company name that the Eloqua user belongs to
    • username: The user’s Eloqua username
    • password: The user’s Eloqua password
    • startPullDate: The first date data can be imported from Eloqua 
      If Personalization doesn’t have a date set already, the connector uses this date as a starting point. If a new activity is added to the mappings, it will use the startPullDate for the initial import.
    • bucketRegion: Supplied by Acquia
    • bucketName: Supplied by Acquia
    • personFieldMapping: Sends specific customer data to Eloqua — Learn more
    • eventFieldMapping: Sends specific activity data to Eloqua — Learn more
• Click Save configuration.

Adding mappings to your connector

You can configure an Eloqua connector to import data by adding mappings. The mapping type determines the mapping configurations. You can configure the Eloqua connector to import data by adding mappings to it. A text file displayed on the connector’s configuration page defines all mappings.

Fields associated with an activity can be mapped to fields in the Person, Touch, or Event tables. For example, you can map the Eloqua activity EmailClickthrough, and it reflects in Personalization as the event Eloqua_EmailClickthrough. You would then map a field associated with the activity, such as CampaignID to event_udf5 in the Event table.

In the following examples, eloquaFieldStatement matches an Eloqua-supplied field, and the mapTo applies to a field in Personalization.

Activity mappings

In Eloqua, a lead (a visitor Eloqua is tracking) performs activities which are captured by Eloqua, such as opening an email or signing up for a mailing list. The Eloqua connector allows you to map the activities to events in Personalization, along with corresponding attributes (such as the associated CampaignID).

In Personalization, activities are prefixed with Eloqua_{activityname}, where {activityname} is the name of an activity tracked in Eloqua. You must manually create these activities in Personalization as events. For more information, see Creating and managing events.

As an example, activity mapping in the connector configuration file to map the Subscribe activity and several associated fields into Personalization event fields can display like the following:

"eventFieldMapping":{
   "Subscribe": {
       "eventName": "Subscribe",
       "attributesMappings": {
           "CampaignId" : "event_udf5",
           "ExternalId" : "event_udf6",
           "AssetId" : "event_udf7"
       }
   }
  }

For a full list of mappable activities, see Oracle’s documentation regarding activity fields.

Contact mappings

Adding contact mappings to your Eloqua connector enables you to import data related to visitors’ contact information and create segments from that information. When you have mapped a lead to a field, it can be imported into Personalization and the added data can be used in segments.

As an example, adding contact mapping in the connector configuration file to map the C_Industry1 field from Eloqua can display like the following:

"personFieldMapping":{
"C_Industry1": {
"isIdentity": false,
"eloquaFieldStatement": "{{Contact.Field(C_Industry1)}}",
"mapTo": "person_udf5"
},
        }

For a full list of mappable contact fields, see Oracle’s documentation regarding contact fields.

Creating segments with Eloqua activity and lead information

After creating and enabling your connector, the next step is to use the imported Eloqua activity and lead data to create segments.

Managing your connectors

To view and manage your available connectors:

• Sign in to the Personalization interface, and then click the Admin tab.
• Click the Manage configuration data link.
• Click the Connectors link.

Personalization displays a list of the available connectors for your environment. The Connectors page has options for the following available actions, including enabling/disabling, deleting, or editing connectors:

Enabling or disabling a connector

For your connectors to start importing Eloqua information into Personalization, they must be enabled.

To enable a connector, set the switch to On for that connector. To disable the connector, set the switch to Off.

Deleting a connector

To permanently remove a connector or its mapping information, complete the appropriate steps depending on your needs:

• Connector: Find the connector in the list of displayed connectors, and then click Delete.
• Activity mapping for a connector: Complete the following steps:
  • Find the connector in the list of displayed connectors, and then click Configure.
  • In the Configuration settings (JSON) field, remove the entire eventFieldMapping section.
  • Click Save Configuration.
• Contact mapping for a connector: Complete the following steps:
  • Find the connector in the list of displayed connectors, and then click Configure.
  • In the Configuration settings (JSON) field, remove the entire personFieldMapping section.
  • Click Save Configuration.

Configuring the Eloqua connector

"eventFieldMapping":{
   "Subscribe": {
       "eventName": "Subscribe",
       "attributesMappings": {
           "CampaignId" : "event_udf5",
           "ExternalId" : "event_udf6",
           "AssetId" : "event_udf7"
       }
   }
  }

"personFieldMapping":{
"C_Industry1": {
"isIdentity": false,
"eloquaFieldStatement": "{{Contact.Field(C_Industry1)}}",
"mapTo": "person_udf5"
},
        }