75,730
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.
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.
Lisa, how do you get the SQL agent to copy to an SFTP server? Can you provide links that describe the setup?
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
You can do it with SQL BCP commands and then scheduled with SQL Agent.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (