SFTP
File-based integration (often over SFTP) exchanges data as files, a simple, widely-supported, asynchronous style used for batch data transfer with many systems and partners.
Use file/SFTP integration for batch data exchange, partner integrations that use files, and legacy systems, especially where real-time is unnecessary.
- File/SFTP integration writes or reads files (CSV, XML, IDoc-XML, etc.
- File adapters (SFTP/FTP/file) in the middleware.
- Formats: CSV, XML, fixed-length, IDoc-XML.
- Watch out: Wrong tool for the integration style.
What SFTP / file integration does
File/SFTP integration writes or reads files (CSV, XML, IDoc-XML, etc.) to/from a secure file location, with middleware (PI/PO or CPI) picking them up, transforming and routing. It is a reliable, low-tech mechanism for batch and partner data exchange where real-time APIs are not available or needed.
Key aspects
- File adapters (SFTP/FTP/file) in the middleware.
- Formats: CSV, XML, fixed-length, IDoc-XML.
- Polling & scheduling for pickup.
- Security: SFTP/encryption, and integrity checks.
When to use it
Use file/SFTP integration for batch data exchange, partner integrations that use files, and legacy systems, especially where real-time is unnecessary. It is simple and robust, but plan for scheduling, security and error handling (partial/failed files).
Common pitfalls
- Wrong tool for the integration style.
- Ignoring monitoring/error handling.
- Point-to-point instead of governed integration.