ERP Integration 5 — Questions and Answers
Question 1: Which ERP integration approach is best suited for migrating 10 years of historical invoice data from a legacy system to a new ERP?
- Real-time webhook streaming
- One-time bulk data migration with validation scripts (Correct answer)
- Ongoing nightly differential sync
- Manual re-entry by accounting staff
Correct answer: One-time bulk data migration with validation scripts
Historical data migration is a one-time, high-volume transfer that requires extraction, transformation, validation, and bulk loading rather than ongoing sync mechanisms.
Question 2: In ERP integration governance, a 'service catalog' serves what purpose?
- Lists all products available for sale in the ERP
- Documents available integration services, their owners, SLAs, and usage policies (Correct answer)
- Tracks software licenses for all integrated systems
- Records all failed integration transactions
Correct answer: Documents available integration services, their owners, SLAs, and usage policies
An integration service catalog gives developers and stakeholders a single reference for what integration services exist, who owns them, and how to use them.
Question 3: When ERP and HR systems exchange employee data, which regulation most commonly drives data-handling requirements for US-based companies?
- SOX (Sarbanes-Oxley)
- HIPAA (if benefits data includes health information) (Correct answer)
- FCC communications regulations
- Dodd-Frank financial reform
Correct answer: HIPAA (if benefits data includes health information)
When HR data includes employee health or benefits information, HIPAA's privacy and security rules govern how that data must be protected in transit and at rest.
Question 4: What is the primary benefit of using a publish-subscribe (pub/sub) pattern for ERP event integration?
- All subscribers must be online when the event is published
- Publishers and subscribers are decoupled, allowing new consumers without changing the publisher (Correct answer)
- Events are always delivered in strict order
- Only one subscriber can consume each event
Correct answer: Publishers and subscribers are decoupled, allowing new consumers without changing the publisher
Pub/sub decoupling means the ERP publishes an event (e.g., 'order created') and any number of downstream systems subscribe without the ERP needing to know who they are.
Question 5: A middleware integration error log shows 'schema validation failure' on incoming purchase order messages. What should the integration team do first?
- Restart the ERP application server
- Compare the incoming message structure against the expected schema to identify the mismatch (Correct answer)
- Increase message queue timeout settings
- Disable schema validation temporarily to restore flow
Correct answer: Compare the incoming message structure against the expected schema to identify the mismatch
Schema validation failures mean the incoming data doesn't match the expected format; inspecting the actual vs. expected schema reveals exactly which field is wrong.
Question 6: What is 'data lineage' and why is it important in ERP integrations?
- The sequence of user approvals required before data is posted
- The traceable record of where data originated, how it was transformed, and where it flowed (Correct answer)
- The hierarchy of master data ownership across business units
- The version history of the ERP software itself
Correct answer: The traceable record of where data originated, how it was transformed, and where it flowed
Data lineage lets auditors and analysts trace any data value back through every integration step to its original source, which is critical for compliance and troubleshooting.
Question 7: An organization runs SAP ERP on-premises and adopts a cloud-based procurement platform. Which integration architecture pattern best addresses connectivity across this hybrid environment?
- Direct VPN tunnel with manual file sync
- Integration Platform as a Service (iPaaS) with pre-built cloud and on-premises connectors (Correct answer)
- Replicating the entire ERP database to the cloud
- Using email attachments for purchase order exchange
Correct answer: Integration Platform as a Service (iPaaS) with pre-built cloud and on-premises connectors
iPaaS solutions are designed specifically for hybrid cloud/on-premises integration, providing connectors, monitoring, and managed infrastructure without requiring on-premises middleware.
ERP Integration 5
Which ERP integration approach is best suited for migrating 10 years of historical invoice data from a legacy system to a new ERP?