For SFTP outbound data integrations, the system does the following:
- Generates files from the data.
The output format and required fields are defined when creating the data integration.
When inserting datetime fields, the system supports the following field types:- TIMESTAMP
- TIMESTAMP WITH TIMEZONE
- Transfers the files to the SFTP server for ingestion and processing by the external system.The authentication method used when defining the SFTP connection must have write access to the SFTP server and directory.
- Logs error messages for any errors such as.
- Insufficient disk space
- File not generated
- File not sent to SFTP server