Re:Escape the scripter mentality if reliability matters (2011)
by statictype on Saturday July 27, 2019 @08:03PM
(#20545031)
Sounds like an iPaaS is exactly what they need and since hes not a dev he may even embrace it?
What’s your iPaaS product?
The guy who handles this has set up a SQL database and pulls data in via FTP and email. Outlook sits open on a server so that Outlook message rules can be used to fire up a VBScript which in turn calls a stored procedure to ingest the data. There are a bunch of combinations of these to deal with different feeds.
He's a brilliant guy and he's used the tools he knows (not a dev) but it's brittle and only he knows how to support it. It's unlikely they'll move to our platform (invasion of his turf) but I do hope he finds another solution that's more reliable.