SSIS Components for Oracle Eloqua

Build 24.0.9060

Contact

Create, update, delete, and query Contacts. This table is supported in bulk mode.

Table Specific Information

The EmailAddress column is required for INSERTs and updates.

Columns

Name Type ReadOnly Description
ID [KEY] Long True

The unique identifier of the contact.

Email Address [KEY] String False

The Email Address of the contact.

First Name String False

The First Name of the contact.

Last Name String False

The Last Name of the contact.

Company String False

The Company of the contact.

Email Display Name String False

The Email Display Name of the contact.

Address 1 String False

The Address 1 of the contact.

Address 2 String False

The Address 2 of the contact.

Address 3 String False

The Address 3 of the contact.

City String False

The City of the contact.

State or Province String False

The State or Province of the contact.

Zip or Postal Code String False

The Zip or Postal Code of the contact.

Country String False

The Country of the contact.

Business Phone String False

The Business Phone of the contact.

Mobile Phone String False

The Mobile Phone of the contact.

Fax String False

The Fax of the contact.

Title String False

The Title of the contact.

Salutation String False

The Salutation of the contact.

Salesperson String False

The Salesperson of the contact.

SFDC Contact ID String False

The SFDC Contact ID of the contact.

SFDC Lead ID String False

The SFDC Lead ID of the contact.

Date Created Date True

The Date Created of the contact.

Date Modified Date True

The Date Modified of the contact.

Eloqua Contact ID String True

The Eloqua Contact ID of the contact.

SFDC Account ID String False

The SFDC Account ID of the contact.

Last Modified by CRM System Date True

The Last Modified by CRM System of the contact.

Last SFDC Campaign ID String False

The Last SFDC Campaign ID of the contact.

Last SFDC Campaign Status String False

The Last SFDC Campaign Status of the contact.

Company Revenue String False

The Company Revenue of the contact.

SFDC Email Opt Out String False

The SFDC Email Opt Out of the contact.

Lead Source - Most Recent String False

The Lead Source - Most Recent of the contact.

Lead Source - Original String False

The Lead Source - Original of the contact.

Industry String False

The Industry of the contact.

Annual Revenue String False

The Annual Revenue of the contact.

Lead Status String False

The Lead Status of the contact.

Job Role String False

The Job Role of the contact.

Lead Score - High Value Website Content Double False

The Lead Score - High Value Website Content of the contact.

Lead Score Date - Engagement - Most Recent Date False

The Lead Score Date - Engagement - Most Recent of the contact.

Integrated Marketing and Sales Funnel Stage String False

The Integrated Marketing and Sales Funnel Stage of the contact.

Product/Solution of Interest String False

The Product/Solution of Interest of the contact.

Region String False

The Region of the contact.

PURL Name (Default Hypersite) String True

The PURL Name (Default Hypersite) of the contact.

Lead Rating - Combined String False

The Lead Rating - Combined of the contact.

Email Address Domain String True

The Email Address Domain of the contact.

First and Last Name String True

The First and Last Name of the contact.

Company Size String False

The Company Size of the contact.

Lead Score - Last High Touch Event Date Date False

The Lead Score - Last High Touch Event Date of the contact.

Lead Rating - Profile (Explicit) String False

The Lead Rating - Profile (Explicit) of the contact.

Lead Rating - Engagement (Implicit) String False

The Lead Rating - Engagement (Implicit) of the contact.

Lead Score - Profile (Explicit) Double False

The Lead Score - Profile (Explicit) of the contact.

Lead Score - Engagement (Implicit) Double False

The Lead Score - Engagement (Implicit) of the contact.

Lead Score Date - Profile - Most Recent Date False

The Lead Score Date - Profile - Most Recent of the contact.

Employees Double False

The Employees of the contact.

Territory String False

The Territory of the contact.

Lead Score String False

The Lead Score of the contact.

PURL Name String True

The PURL Name of the contact.

MD5 Hashed Email Address String True

The MD5 Hashed Email Address of the contact.

SHA256 Hashed Email Address String True

The SHA256 Hashed Email Address of the contact.

MD5 Hashed Business Phone String True

The MD5 Hashed Business Phone of the contact.

SHA256 Hashed Business Phone String True

The SHA256 Hashed Business Phone of the contact.

MD5 Hashed Mobile Phone String True

The MD5 Hashed Mobile Phone of the contact.

SHA256 Hashed Mobile Phone String True

The SHA256 Hashed Mobile Phone of the contact of the contact.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060