Tables
The adapter models the data in Oracle Eloqua into a list of tables that can be queried using standard SQL statements.
Generally, querying Oracle Eloqua tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Oracle Eloqua Adapter 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. |
| Custom | Create and delete custom. |
| 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. This table is not supported in bulk mode. |
| 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. |