SFTP Inbound Data Integrations | Vantage CX - 1.4 - SFTP Inbound Data Integrations - Vantage Customer Experience

Vantage Customer Experience User Guide

Product
Vantage Customer Experience
Release Number
1.4
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-3800-099K
Language
English (United States)

When the system retrieves data from an external system using SFTP inbound integration node, any of the following scenarios can occur:

Scenario Description
Success System retrieves and processes all files from the SFTP server, based on the filename or expression defined in the data integration.
When processing multiple files, the files are streamed individually, in alphabetical order.
Invalid file content

For example, the file does not support delimited content.

System encounters an unsupported file type or content.
  • The workflow or customer list fails
  • Errors are logged and can be viewed on the Status page
  • Log file includes error messages and skipped files
File processing error

For example, 10 files are retrieved and an error encountered in processing the fifth file.

System successfully process the files until encountering an error.
  • Successful files are inserted into database as normal
  • Successful files are ignored in subsequent runs (tracked in DI_PROCESSED_FILES table) unless the file is altered (File Edit time stamp and Size is compared)
  • The unsuccessfully read file, and all subsequent files, are skipped
  • Errors are logged, indicating the line number that caused the failure in the unsuccessfully read file, and can be viewed on the Status page
  • Log file includes file and line number that caused the error and skipped files
When processing multiple files, the files are streamed individually, in alphabetical order.