MSAMM
Back to course

Implementing Cloud Financials: From Empty Pod to Go-Live · Module 14 · Data Migration and Integration

The import architecture

Lesson 134 of 153 · 1 min

Every import follows one pattern: file → staging or interface → validation → import process → application tables. Knowing it means you can debug any import, including ones you have never seen before. Where things get stuck is in the interface tables, with an error code. That is where to look — not the process log, which frequently says the process completed, because from its point of view it did. Then the delivery mechanisms: file-based bulk import, spreadsheet-based entry, REST for real-time, and web services for system-to-system. Volume and frequency decide which one. High volume, one-off, goes to a file. Low volume, real-time, goes to REST. Ongoing and scheduled goes to a file or a service depending on what the source system can offer. And finally, where the file physically goes and how the import process finds it — which sounds trivial and is the step people get stuck on

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Implementing Cloud Financials: From Empty Pod to Go-Live, with a certificate on completion and a fourteen-day refund window.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 14 · Data Migration and Integration

  1. 1Migration strategy: what to bringFree preview
  2. 2The import architecture
  3. 3File-based import end to end
  4. 4The finance import objects
  5. 5Opening balances
  6. 6Configuration migration between environments
  7. 7Integration patterns and third parties
  8. 8What breaks
  9. 9Lab: migrate opening balances