Open Forum

Expand all | Collapse all

Free SFTP file transfer and data export tool for Dynamics GP file-based integrations

  • 1.  Free SFTP file transfer and data export tool for Dynamics GP file-based integrations

    TOP CONTRIBUTOR
    Posted Sep 26, 2017 12:54 PM
    Edited by Steve Endow Sep 26, 2017 12:54 PM

    Hi everyone,

    A somewhat common part of file-based integrations between Dynamics GP and external services or SaaS solutions involves uploading or downloading files from an SFTP server (SSH File Transfer, completely different than the similarly named FTP or FTPS).  SFTP has some technical quirks, so it is often a hassle for customers to automate SFTP file transfers as part of their Dynamics GP integrations.


    I have developed an application that can export data from GP, save it to a CSV file, and upload it to an SFTP server.  It can also download files from an SFTP server.  The tool is fully automated, can be scheduled using Windows Task Scheduler, and it includes file archiving, logging, and email notification in case of errors.

    If you use Blackline, Coupa, IQ BackOffice, or any other provider or service that requires upload or download of files with an SFTP server, this tool may be helpful.  It can be used in place of WinSCP or similar tools that require command line scripting.


    I am offering this tool for free to the Dynamics GP community.  It can be downloaded from my web site at:

    https://precipioservices.com/sftp/

    The download includes a user guide and sample configuration file.  There are quite a few configuration settings, so please make sure to review the documentation to understand how the settings are used.

    If you end up using the Precipio SFTP tool, I would be love to hear about which system or service you are using it with and how it ends up working for you.

    If you have questions or encounter issues, you can contact me through my web site at:

    https://precipioservices.com/contact-us/

    Or you can email me at steveendow (at) gmail (dot) com.


    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    ------------------------------


  • 2.  RE: Free SFTP file transfer and data export tool for Dynamics GP file-based integrations

    TOP CONTRIBUTOR
    Posted Sep 26, 2017 01:13 PM
    Nice, Precipio FTW again!

    ------------------------------
    Matthew Arp
    Business Systems Developer
    Hunton Group
    Houston TX
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role