SSIS Components for Oracle Eloqua

Build 24.0.8963

Visitor

Retrieve Visitors.

Table Specific Information

Select

The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Oracle Eloqua also has limited support on multiple conditions. In many tables the AND condition between filters is not supported. If AND is included the server might not return any results, nor will it return an error.

Columns

Name Type Description
VisitorId [KEY] Long The Id of the visitor profile.
CreatedAt Datetime Date the visitor profile was created.
V_IPAddress String IP address of the visitor.
V_LastVisitDateAndTime Datetime Date of last visit to an Eloqua asset for this profile.
ExternalId String Customer GUID for this visitor profile.
ContactId Long The Id of the contact associated with this profile, if any.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Depth String The depth of information requested from Eloqua.

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