Versions Compared

Key

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

...

If your query contains any field name that does not exist in the custom object fields name, then an error is returned, and the job fails. 

Obtain the Custom Data Object Name from Oracle Eloqua Console

...

Numbered Headings
start-numbering-with1
start-numbering-ath5
Login into Oracle Eloqua Console.
     https://login.eloqua.com/
Enter the same company, user name, and password
that
you entered when specifying the CSF authentication keys in Oracle JDeveloper and Oracle Enterprise Manager Fusion Middleware Control.
Navigate to Audience 

An image of the Audience icon.

Select Custom Objects.

Optionally, navigate to Custom Object Record Reporting and select the desired report:
    • Custom Object Data:
      • Use this report to view all the custom object records within the individual custom object.
      • You can print and export the report to Excel , as well as and copy, delete, or move the custom object records.
    • Custom Object and Contact Data:
      • Use this report to view all the custom object records data within the individual custom object with the contact information that they are mapped to. The report can be viewed in a specified time frame. The default is the past month, but you can select a different time range by changing the time range (the Start Date and End Date) or time span (for example, Last week or Last month) and select:

An image of the confirm time change button, represented by a clock.


      • You can print and export the report to Excel.
Make note of the custom object name and the field names. 

...

Define your Query

Your query requires that each type of resource has specific resource type to have specific columns and exact column names (case sensitive) and data types. 

...

If your query contains any field name that does not exist in the custom object fields name, then an error is returned, and the job fails. 


Excerpt Include
PD:Exporting Your Query Data to Your Destination
PD:Exporting Your Query Data to Your Destination
nopaneltrue

...

Integration Parameters for Eloqua 

Image Removed


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 the identifier
Check if you want to modify the indentifer identifier value by adding a prefix value to the identifier column. This option is supported for an identifier column that has a data type of 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 is 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.

Example Query

Your query requires that each type of resource has specific resource type to have specific columns and exact column names (case sensitive) and data types. 

...

If your query contains any field name that does not exist in the custom object fields name, then an error is returned, and the job fails. 


Code Block
languagesql
titlecustom object query
linenumberstrue
SELECT col_a, col_b, col_b 
FROM your_table;

...