Article content
When considering different use cases and architecture there are a few things to keep in mind about the data model and related processes.
Data model
Eloqua has a simple data model. The contact table stores both lead and contact records, with a one-to-many relationship to accounts. Custom Data Objects can have many-to-many relationships with contacts or accounts, but not both, and critically, CDOs cannot relate to other CDOs, so you cannot expand the model to multiple levels. That makes scenarios like households, or an e-commerce order with multiple line items linking to products, impossible to replicate; the only feasible option is to aggregate. Oracle recommends no more than 20–25 million records across all CDOs.
Marketing Cloud allows more complex models that can broadly mirror your CRM. Data Extensions store large volumes: up to a million records is comfortable, and you should avoid more than a hundred million in a single extension. Contact Builder’s Data Designer lets you design the model you actually need.
Data retention
Retention is not possible out of the box in Eloqua; you use a third-party app or build your own auto-deletion process. That is a real issue for retailers storing purchase history. Marketing Cloud lets you define a retention policy as part of the Data Extension configuration, running dynamically or on a fixed date. It matters for performance and for GDPR compliance.
Data tools and processes
Eloqua is strong here. Its Data Tools toolbox provides update rules, match rules, deduplication rules and lookup tables, none of which require code, the process usually called data washing.
Marketing Cloud does this differently. You can use Automation Studio with custom SQL activities, or AMPscript and server-side JavaScript, or third-party apps from AppExchange. If you integrate with Sales Cloud, Sales Cloud can do the cleansing and Marketing Cloud can focus on automation and orchestration.
Integration and forms
Oracle phased out the legacy native connector in 2021 in favour of the Oracle Eloqua Salesforce Integration App, faster, better interface, but Sales Cloud only. Marketing Cloud offers Marketing Cloud Connect out of the box, syncing data down from Sales Cloud and tracking data back up.
On forms, Eloqua’s builder is powerful, with drag-and-drop design and form processing steps that trigger actions on submission, a genuinely strong lead generation tool. Marketing Cloud’s Smart Capture is far more limited; the practical route is AMPscript on the landing page, which is slower and needs developer resource but offers total flexibility.
Summary
Marketing Cloud is a more powerful solution with a more flexible data model, but that comes at a cost, in licence fees and in the IT skills needed to configure and maintain it. Eloqua is simpler and needs fewer resources, but cannot handle very complex setups or large data volumes.
Archive: this article dates from an earlier phase of our work, when marketing automation was our main focus. We have kept it online because the thinking still holds, but it is not where our practice sits today.
Is your org one people actually want to use?
The experience lens of our assessment looks at where users work around the system instead of in it: the shadow spreadsheets, the abandoned screens, the reports nobody trusts.
Explore assessment scopesRelated
A Truly Customer-Centric Experience
There is a graveyard of failed CX initiatives. Serving your customer is one thing; understanding them is another entirely.
The European Accessibility Act
Since June 2025 accessibility is law, not preference. What it covers, what it costs, and why it is a market opportunity rather than a burden.
EX Boosts CX Success
Companies pour everything into customer experience while ignoring employee experience and Salesforce puts the cost of that at up to 50% of revenue growth.