Virtualisation removes pipeline and storage cost and adds query cost. The platform is cheaper than a physical hub only while the freshness contract keeps expensive queries off the critical path.
The Denodo licence is core-based and is the largest fixed line. Pool sizing on view 29 is therefore a commercial decision as much as a performance one.
MPP compute is the most volatile line, because it scales with bytes scanned rather than with users.
Levers, in order of effect
Replace a repeated MPP aggregate with a summary — the largest single saving available, and the reason the loop on view 32 exists.
Federate rather than copy: every attribute not landed removes a pipeline, a storage line and a reconciliation obligation.
Right-size the analytical pool, which is idle for most of the working day.
Assumptions to confirm
SaaS API call volumes stay within contracted limits under federated load. Exceeding a Salesforce limit converts a design decision into an unplanned licence negotiation.
On-premises egress for the ERP path is charged at committed-bandwidth rates, not on demand.
