Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Integration Parameters for Eloqua 

Image RemovedImage Added

Image Added


Contact and

Custom Object Data

Parameters

Value

Description

DestinationContactThe Eloqua object to export data (contact list or custom object)

Custom Object DataThe Eloqua object to export data (contact list or custom object)
Identifier Field Name

- Contact's email address [c_emailaddress]
- Contact's external ID [c_externalid]
- Contact's ID [c_id]

The field name is used to identify the contact entity.

If you chose a Contact's email address, you must have the  c_emailaddress field in your query with the Contact's external ID as c_externalid field, and the Contact's ID is a c_id field.


One of the field names from your custom object data query.

For example, if your query is:

Code Block
SELECT col_a, col_b, col_b FROM your_table;

then the value should be one col_a, col_b, or col_b.

The field name is used to identify the custom object row. 
Add prefix to identifier
Check if you want to modify indentifer value by add prefix value to indentifer column. Only support for identify column that have data type in string type

Prefixstring valueprefix value will be added to identify column value 
List/Object name to importCustom object names can be case insensitive.

The contact list name or object name for the exported data.

The custom object name that we need to export data into.



Update Rule- Always update
- Update if the new value is not blank
- Update if the existing value is blank
- Use the rule defined at the field level
The rule used when doing updates on existing data. For more information about this parameter, see the Oracle Eloqua.
Skip invalid records
If you checked when Eloqua synced data and you receive a data rows error, the export job is still a success. Otherwise, the job failed.
Map custom object to contact
If you checked, the job tries to map a custom object to a contact.
Perform case sensitive search when mapping custom object to contact
Perform a case-sensitive search when mapping a custom object to a contact.
CDO source fieldColumn name of the field Input the column name of the field to be mapped, as used in the export schema. Required when Map custom object to contact is enabled.
Contact map fieldColumn name of the field Input the contact field for mapping. Required when Map custom object to contact is enabled.

...

Code Block
_export:
  td:
    database: eloqua_db

+eloqua_custom_object_export_task:
  td>: export_contact.sql
  database: ${td.database}
  result_connection: new_created_eloqua_auth
  result_settings:
    type: eloqua
    target: contact
    identifier_field_name: C_EmailAddress

    list_name: td_shared_list2
    update_rule: always
    skipInvalidRecords: true

...