Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
Oracle Eloqua Adapter Views
| Name | Description |
| AccountField | Retrieve Account Fields. |
| AccountView | Retrieve Account Views. |
| Activity_Bounceback | Retrieve Bounceback Activities. This table is only supported in bulk mode. |
| Activity_CampaignMembership | Retrieve Campaign Membership Activities. |
| Activity_EmailClickThrough | Retrieve Email Click Through Activities. |
| Activity_EmailOpen | Retrieve Email Open Activities. |
| Activity_EmailSend | Retrieve Email Send Activities. |
| Activity_EmailSubscribe | Retrieve Email Subscribe Activities. |
| Activity_EmailUnsubscribe | Retrieve Email Unsubscribe Activities. |
| Activity_FormSubmit | Retrieve Form Submit Activities. |
| Activity_PageView | Retrieve Page View Activities. This table is only supported in bulk mode. |
| Activity_WebVisit | Retrieve Web Visit Activities. |
| CampaignElement | Retrieve Campaign Elements. |
| CampaignField | Retrieve Campaign Fields. |
| CampaignFolder | Retrieve Campaign Folders. |
| ContactField | Retrieve Contact Fields. |
| ContactFilter | Retrieve Contact Filters. |
| ContactFilterFolder | Retrieve Contact Filter Folders. |
| ContactList | Create, update, delete, and query Contact Lists. |
| ContactListFolder | Retrieve Contact List Folders. |
| ContactScoringModelFolder | Retrieve Contact Scoring Model Folders. |
| ContactSegmentData | Retrieve Contact Segment Data. Note: The pseudo column SegmentID must be specified to retrieve the data of this table. This SegmentID can be retrieved from the ContactSegment table's ID column. |
| ContactSegmentFolder | Retrieve Contact Segment Folders. |
| ContactView | Retrieve Contact Views. |
| ContentSectionFolder | Retrieve Content Section Folders. |
| Dependencies | Retrieve Dependencies. |
| DynamicContent | Retrieve Dynamic Contents. |
| DynamicContentFolder | Retrieve Dynamic Content Folders. |
| EmailDeployment | Retrieve email deployments. |
| EmailFolder | Retrieve Email Folders. |
| EmailFooterFolder | Retrieve Email Footer Folders. |
| EmailHeaderFolder | Retrieve Email Header Folders. |
| ExternalType | Retrieve External Types. |
| FieldMerge | Retrieve Field Merges. |
| FieldMergeFolder | Retrieve Field Merge Folders. |
| FormElement | Retrieve Form Elements. |
| FormFolder | Retrieve Form Folders. |
| FormProcessingStep | Retrieve Form Processing Steps. |
| HyperlinkFolder | Retrieve Hyperlink Folders. |
| Image | Retrieve Image. |
| ImageFolder | Retrieve Image Folders. |
| ImportedFile | Retrieve Imported Files. |
| ImportedFileFolder | Retrieve Imported File Folders. |
| LandingPageFolder | Retrieve Landing Page Folders. |
| LeadScoringModel | Query Lead Scoring Models. |
| PageTag | Retrieve Page Tags. |
| PageTagGroup | Retrieve Page Tag Groups. |
| Program | Retrieve Programs. |
| Style | Retrieve Styles. |
| Template | Retrieve Templates. |
| TemplateCategory | Retrieve Template Categories. |
| TrackedUrl | Retrieve Tracked Urls. |
| User | Retrieve Users. |
| Visitor | Retrieve Visitors. |
| VisitorProfileField | Retrieve all of the visitor profile fields. |