SFTP schedules

Holistics allows admins/analysts to schedule report data to be sent to an SFTP destination. This is very helpful when you need to backup report data periodically to your SFTP server, or deliver data regularly to your partners’ servers.

A SFTP Schedule execution follows these steps:

  1. Execute the Query Report to get result data.
  2. Write the result data to a temporary file in $REMOTE_PATH/.holistics_tmp/ ($REMOTE_PATH is configured in the SFTP connection).
  3. Prepare the destination path: create the non-existing directories in the destination path.
  4. Move the temporary file to the destination path.

Learn more about this feature in details in our SFTP schedules docs, or Sign up for a free trial to experience it yourself.