SFTP

SFTP integration is the last resort when the above 3 methods are not feasible based on client systems and tech capabilities. SFTP integration involves manual transfer of files through an FTP application.

Script to transform the data into an acceptable format which can be ingested into the Compass system

Manual, queries are not standardized and might change frequently causing the script to fail, variability of solution scope based on client requirements