# Choosing ETL, iPaaS, events or API gateways

*MuleSoft Integration Foundations Study Guide · Recognize common integration problems, use cases, and technical solutions · Last updated November 2, 2026 · https://www.certifyforce.com/study-guide/mulesoft-integration-foundations/integration-problems-use-cases-and-technical-solutions/choosing-etl-ipaas-events-or-api-gateways*

How to match a business scenario to the right integration technology: ETL for batch warehouse loads, a hybrid-capable iPaaS for cloud-to-on-premises connectivity, event-driven processing for act-now needs, and API management with a gateway for secured, throttled, discoverable APIs.

- Certification: Salesforce MuleSoft Integration Foundations
- Exam section: Recognize common integration problems, use cases, and technical solutions
- Study guide: https://www.certifyforce.com/study-guide/mulesoft-integration-foundations

**Official exam objective:**

> Identify the types of integration technologies that are most suitable to realize different integration use cases and business scenarios.

## What the exam expects

- Choose ETL for large, batch-oriented loads into a data warehouse for business intelligence.
- Choose a cloud-native iPaaS with hybrid support when cloud applications must reach systems behind a firewall.
- Choose event-driven processing over scheduled batch when an action must happen the moment state changes.
- Choose API management with an API gateway when consumers must discover, authenticate to and be throttled on an API.
- Explain why having an API is not the same as having an integration.

Key terms:
- **ETL**: extract, transform, load; batch-oriented data movement, historically for data warehouses.
- **Hybrid integration**: integrating systems that reside both on-premises and in the cloud.
- **Event-driven processing**: integrations triggered by real-time state changes rather than fixed schedules.
- **API gateway**: the runtime that handles traffic management such as throttling, rate limiting and authentication in front of APIs.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| ETL primary historical use | Business intelligence via data warehouses | [ETL tools to ESBs](https://www.mulesoft.com/integration/etl-tools-vs-esb) |
| ETL orientation | Large data volumes in batches | [ETL tools to ESBs](https://www.mulesoft.com/integration/etl-tools-vs-esb) |
| iPaaS processing modes | Both real-time streams and batch processing | [What is iPaaS?](https://www.mulesoft.com/integration/ipaas-integration-platform-as-a-service) |
| Hybrid connectivity mechanism | Secure data gateways and containerized on-premises agents | [What is iPaaS?](https://www.mulesoft.com/integration/ipaas-integration-platform-as-a-service) |
| Gateway traffic tasks | Throttling, rate limiting, automated authentication | [What is iPaaS?](https://www.mulesoft.com/integration/ipaas-integration-platform-as-a-service) |
| API vs API integration | An API is the contract; the integration is the live connection | [API integration](https://www.mulesoft.com/api/what-is-api-integration) |
| Omni Gateway capacity | Up to 1,000 backend APIs per gateway; run several in parallel for high availability | [Omni Gateway Overview](https://docs.mulesoft.com/gateway/latest/) |

## Check yourself

- Which API integration pattern does MuleSoft suggest for sending website lead forms into a CRM?
- Why do modern iPaaS platforms use message brokers and webhooks for events?
- When does the Omni Gateway runtime act, and what does the control plane do?
- How should an integration stay within a provider's rate limits?

## Sources

- [What is iPaaS? Integration Platform as a Service Explained](https://www.mulesoft.com/integration/ipaas-integration-platform-as-a-service)
- [From ETL tools to ESBs](https://www.mulesoft.com/integration/etl-tools-vs-esb)
- [iPaaS vs. Full Lifecycle API Management](https://www.mulesoft.com/integration/ipaas-vs-full-lifecycle-api-management)
- [What is API integration?](https://www.mulesoft.com/api/what-is-api-integration)
- [Hybrid Integration](https://www.mulesoft.com/resources/hybrid-integration)
- [Omni Gateway Overview](https://docs.mulesoft.com/gateway/latest/)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 4 linked practice questions, and unlimited timed mock exams are included with the MuleSoft Integration Foundations pack (USD $19): https://www.certifyforce.com/practice-exams