As all Playworks' school partners register for their training via an external Bridge LMS platform, all their data has to be kept in their Salesforce instance. The main challenge was to find a solution that would sync the data between two sources, would be low-cost and easy to set up for an in-house staff.
Playworks looked for a solution that could parse standard and custom data from Salesforce using complex and/or statements and export it as CSV to SFTP on a daily schedule. SFTP in its turn is set to automatically look for the CSV daily and upload the data into the external Bridge LMS platform.
Playworks tested several solutions, including Jitterbit and Mulesoft, but decided Skyvia was the most cost-effective and straightforward solution.