Tables

The server models the data in Oracle Eloqua as a list of tables in a relational database that can be queried using standard SQL statements.

CData MCP Server for Oracle Eloqua Tables


Name	Description
Account	Create, update, delete, and query Accounts. This table is supported in bulk mode.
AccountGroup	Retrieve Account group.
Campaign	Create, update, delete, and query Campaigns.
CampaignResponses	Create, delete, and query Campaign Responses. This table is only supported in bulk mode.
Contact	Create, update, delete, and query Contacts. This table is supported in bulk mode.
ContactEmailSubscription	Retrieve all email group subscription status for the specific contact.
ContactSegment	Create, update, delete, and query Contact Segments.
ContentSection	Create, update, delete, and query Content Sections.
CustomObjects	Create and delete custom objects.
Email	Create, update, delete, and query Emails.
EmailFooter	Create, update, delete, and query Email Footers.
EmailGroup	Create, update, delete, and query Email Groups.
EmailHeader	Create, update, delete, and query Email Headers.
Event	Create and delete Event.
ExternalActivity	Create and query External Activities.
ExternalAsset	Create, update, delete, and query External Assets.
Folder	Create, update, delete, and query Folders.
Form	Create, update, delete, and query Forms.
Hyperlink	Create, update, delete, and query Hyperlinks.
LandingPage	Create, update, delete, and query Landing Pages.
Microsite	Create, update, delete, and query Microsites.
OptionList	Create, update, delete, and query Option Lists.
OptionListElement	Create, update, delete, and query Option List Elements.
SecurityGroup	Create, update, delete, and query SecurityGroup.

The server can expose custom tables, views, and columns from Oracle Eloqua that are not mentioned in the Tables and Views. The data model illustrates a sample of what your Oracle Eloqua data model might look like. The actual data model will be obtained dynamically based on your user credentials and Oracle Eloqua account.