TDV Adapter for Oracle Eloqua

Build 22.0.8462

ExternalAsset

Create, update, delete, and query External Assets.

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 ReadOnly Description
ID [KEY] Long True

The unique identifier of the external asset.

Name String False

The name of the external asset.

CreatedAt Datetime True

Date the external asset was created.

CreatedBy String True

The Id of the user who created the external asset.

Depth String False

The depth of the external asset.

UpdatedAt Datetime True

Date the external asset was updated.

UpdatedBy String True

The Id of the user who last updated the external asset.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462