My GitHub repository for this project
It was a fortunate coincidence that I needed to build this tool at just the right time. Aquamor had recently brought on a new customer whose EDI connection required SFTP. At the time, the DelmiaWorks EDI module only supported FTP. Normally, a new customer like this would ramp up gradually, and we could’ve used something like FileZilla in the interim—but eventually, a more robust solution would be necessary.
As it happened, IQMS was planning a mandatory upgrade for June 2025. According to their EDI technician, customers unable to upgrade in time were being advised to use WinSCP as a workaround. I had completely forgotten about WinSCP—I had used it in a WordPress FTP plugin a year or so earlier. That experience allowed me to quickly port some of that code and integrate it with my existing custom IQMS libraries to automate polling of EDI files and transfer data in and out of DelmiaWorks.
Although Aquamor was prepared for the upgrade, this particular customer was not using the DelmiaWorks VAN, so a separate connection was required. Technically, eServer supports custom connection strings and could have been used instead of this tool, but that wasn't an option available to us before the upgrade deadline. Besides, there’s no telling what hybrid setup future customers might require. As I’ve mentioned elsewhere, Aquamor operates as a hybrid manufacturer while also handling eCommerce—so we’re constantly onboarding new customers and integrating new connections into the system.
Since this tool ended up being a bit of a novelty that we didn’t strictly need long-term, I thought it might be useful to others. So I posted it on my GitHub.