Home / Archives / February 2023 / Articles

FTP INTEGRATION PATTERNS ACROSS ERP BOUNDARIES: DEPENDENT DEMAND FLOW ARCHITECTURES

Authors: Sivasankararao Kavuri

Country: USA

Abstract

File Transfer Protocol remains, more than two decades after more modern integration technologies emerged, one
of the most widely used mechanisms for exchanging demand and supply data between independently operated
ERP systems. It persists not out of inertia alone but because batch file exchange over FTP or its secure variants
remains simple, broadly compatible, and adequate for a meaningful share of integration scenarios, particularly
those involving dependent demand signals such as planned orders and purchase requisitions that do not require
sub-second latency.
This article presents a structured treatment of FTP-based integration patterns specifically for dependent demand
flow across ERP boundaries. It defines dependent demand and its propagation mechanics, compares three
principal FTP integration patterns, and provides architecture, file design, scheduling, security, performance,
governance, and migration guidance. The article combines structural diagrams, illustrative benchmark charts, and
an extensive set of reference tables to give integration architects a comprehensive, practical foundation.
Illustrative benchmark data presented in Section 12 shows a hub-and-spoke broker pattern achieving roughly 60
percent higher throughput than simple point-to-point batch exchange, while Section 8 shows that demand signal
latency scales sharply with batch frequency, from under half an hour at 15-minute intervals to well over three days
at weekly intervals

Keywords

Not provided

References

1) APICS (Association for Supply Chain Management). (2019). CPIM Certification Study Guide:
Materials Requirements Planning. APICS.
2) Chopra, S., & Meindl, P. (2019). Supply Chain Management: Strategy, Planning, and Operation (7th
ed.). Pearson.
3) Fette, I., & Melnikov, A. (2011). RFC 6455: The WebSocket Protocol. Internet Engineering Task
Force.
4) Postel, J., & Reynolds, J. (1985). RFC 959: File Transfer Protocol (FTP). Internet Engineering Task
Force.
5) Silberschatz, A., Galvin, P. B., & Gagne, G. (2018). Operating System Concepts (10th ed.). Wiley.
6) Vernon, M. (2013). Managed File Transfer: A Practical Guide to Secure Data Exchange. IT
Governance Publishing.
7) Vollmann, T. E., Berry, W. L., Whybark, D. C., & Jacobs, F. R. (2004). Manufacturing Planning and
Control for Supply Chain Management (5th ed.). McGraw-Hill.
8) Ylonen, T., & Lonvick, C. (2006). RFC 4253: The Secure Shell (SSH) Transport Layer Protocol.
Internet Engineering Task Force.