Export SQL data to files
Export data from a SQL Server to delimited text files, ready to upload.
Integration · Free
Precipio SFTP
Export SQL Server data to files and move them over SFTP. Free.
Precipio SFTP is a small command line tool that does one job well: move data between SQL Server and an SFTP server on a schedule.
Define your export, upload, and download tasks in an XML file, point Windows Task Scheduler at it, and let it run. It archives every file it moves, logs each run, and emails you if anything goes wrong. Use it to feed services like BlackLine, Coupa, and IQ BackOffice, or to send Safe Pay and Positive Pay files to a bank.
The challenge
Connecting Dynamics GP to outside services often means exporting data to files and moving those files over SFTP — on a schedule, with logging and archiving. Doing that by hand, or building it from scratch, is more work than it should be.
How Precipio SFTP helps
Precipio SFTP is a command line application that exports SQL Server data to delimited text files, uploads files to an SFTP server, and downloads files from one. It runs on demand or on a schedule, archives everything it moves, logs all activity, and emails you if something fails.
Benefits
What you get
Upload and download over SFTP
Upload files to, and download files from, an SFTP server.
Archive automatically
Archives all exported and downloaded files automatically.
Log everything
Provides full activity logging for every run.
Get error notifications
Sends error notification emails when a task fails.
Run on a schedule
Run on demand, or on a schedule with Windows Task Scheduler.
Call your own SQL
Calls custom SQL stored procedures at the start and end of a task.
Free
Free to download and use.
Features
How it works in detail
Task-based configuration
Processes one or more tasks defined in an XML configuration file, so one run can export, upload, and download.
Data export
Exports SQL Server data to delimited text files for upload to the SFTP server.
SFTP transfer with archiving
Uploads and downloads files over SFTP, and archives everything it moves.
Scheduling, logging, and alerts
Runs from Windows Task Scheduler, logs all activity, and emails you when a task fails.
Getting started
How to put it to work
-
Define your tasks
Set up one or more tasks in the XML configuration file: what to export, where to upload, and what to download.
-
Run it or schedule it
Run the command line application directly, or schedule it with Windows Task Scheduler.
-
Files move and archive
The application exports the data, transfers files over SFTP, and archives everything it moves.
-
Review the logs
Check the activity log, and receive an email if an error occurs.
Requirements
Compatibility and requirements
Supported: Dynamics GP 2016 through 18.x.
What you need
- Microsoft .NET Framework 4.5.2
- A Windows Domain user account with sufficient access to the SQL Server stored procedures (if data export is required)
- Visual C++ Redistributable Packages for Visual Studio 2013 (x86 version)
Good to know
- Supports the SFTP protocol only. FTP and FTPS are not supported.
- Supports username and password SFTP authentication only. SSH key authentication is not supported.
- Does not support passing parameters to stored procedures. Procedures must run without external parameter values.
Download
Get Precipio SFTP
Free to download and use. Links open in a new tab.
FAQ
Common questions
Is it free?
Yes. Precipio SFTP is free to download and use.
Does it support FTP or FTPS?
No. It supports the SFTP protocol only.
How does it authenticate?
With an SFTP username and password. SSH key authentication is not supported.
What can I integrate with it?
It integrates Dynamics GP with services such as BlackLine, Coupa, and IQ BackOffice, and uploads bank Safe Pay and Positive Pay files.
Related