Notifications
Announcements
No record found.
Has anyone ever set up an automated data transfer process using an SFTP server using data in GP. I need to send PO's to an SFTP server and then they will be sending back the PO receipts. I have all the necessary scripts in place to export and import the data. The question now is how to automate this process.
You can do it with SQL BCP commands and then scheduled with SQL Agent.
Hi Richard-
Thank you for posting your question on the Forums. I am not aware of anyone requesting this on our side, but let's wait and see if there is anyone in the community who has tried to do this. Have a great weekend!
Adam G.
Microsoft Dynamics GP
Lisa, how do you get the SQL agent to copy to an SFTP server? Can you provide links that describe the setup?
For other times I have done this, the server has an FTP (sFTP) folder used for the drop. Other systems (for example, Birchstreet) are monitoring the FTP site and extracting data. There are also system commands for scheduling file manipulations and FTP tools to manage the process once it is a file. (In the past, my part of the projects was to get the data to the operating system. I have occasionally had need to dig deeper into FTP options, but that last occurred a few - if not several - years ago.) Once the processes are in place, they rarely fail.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
