Integration Flashcards
7 cards from real ERP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Integration flashcards as text
Which ERP integration topology creates the highest number of point-to-point connections as the number of systems grows?
Answer: Full mesh (spaghetti integration)
In a full mesh, every system connects directly to every other system, creating N×(N-1)/2 connections that become unmanageable at scale.
A warehouse management system (WMS) and the ERP must stay in sync on inventory levels. Which consistency model is most appropriate?
Answer: Eventual consistency with near-real-time event streaming
Eventual consistency via event streaming gives near-real-time accuracy without the performance overhead and complexity of distributed two-phase commits across separate systems.
What is the primary function of a data transformation layer in an ERP integration pipeline?
Answer: Convert data structures and formats between incompatible systems
The transformation layer converts source data (e.g., XML, legacy codes) into the structure and format the target ERP system expects.
An ERP vendor provides a pre-built connector to Salesforce CRM. What is the main advantage of using this over a custom-built integration?
Answer: Pre-built connectors are vendor-supported, faster to deploy, and handle version updates
Vendor-certified connectors are tested, documented, and updated with product releases, reducing implementation time and long-term maintenance burden.
During ERP integration, a 'heartbeat' or 'ping' mechanism is used to:
Answer: Detect when a connected system or endpoint has become unavailable
A heartbeat sends periodic lightweight signals to confirm a connected system is alive, enabling fast failure detection before real messages are lost.
What risk does token-based OAuth 2.0 authentication mitigate in ERP API integrations?
Answer: Passing static usernames and passwords in API calls that could be intercepted or reused
OAuth 2.0 tokens are short-lived and scoped, so even if intercepted they expire quickly and cannot be used to access the full system like a stolen password.
A company's ERP finance module and its e-commerce platform must post orders in real time. After go-live, orders occasionally appear duplicated in the ERP. What is the most likely root cause?
Answer: The integration lacks idempotency keys, causing retried messages to create duplicate records
Without idempotency keys, network retries after a timeout can send the same order message twice, each creating a separate ERP sales order.