SFTP Inbound Data Integrations | Vantage Analyst - SFTP Inbound Data Integrations - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst User Guide
Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.4.1
Published
May 2022
ft:locale
en-US
ft:lastEdition
2022-05-09
dita:mapPath
ufz1626905554941.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
B035-3805
Product Category
Teradata Applications

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 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.