Have Automation Manager create and manage Sage DSNs
When you create or upgrade a sage connection you also have to create a DSN that matches the DSN name and path in the CRM. It would be easier if the automation manager made/updated the correct DSN for you when it ran.