I am currently architecting a data pipeline for our Workforce and Continuing Education department and would love some real-world advice.
Our immediate goal is to set up a nightly automated flat-file (CSV) ingestion from Modern Campus (Lumens) into Salesforce EDA, and possibly our main SIS, Ellucian Colleague.
My primary requirement is keeping this an "admin-centric," declarative (no-code) solution so our CRM team can fully own, troubleshoot, and maintain the architecture without relying on our internal IT department. They are against any integration they have to maintain.
Right now, I am weighing two cloud options:
- Skyvia: I am currently testing a free trial and like the visual, drag-and-drop interface for mapping the CSV to our EDA objects.
- Lingk: I know they are an industry standard for Higher Ed and have native Modern Campus & Colleague connectors. I have submitted several requests and haven't been able to get a hold of their sales team to actually see it in action.
Has anyone here used either of these tools specifically for Modern Campus or Colleague? I would love to hear any pros, cons, or hidden gotchas before committing to a platform.
#Higher Education #Education Data Architecture #Integration #Salesforce Admin
Eric Burté (DEVOTEAM) Forum Ambassador
Hello @Carissa Hansen you an leverage Skyvia, Talend or other ETL / iPaaS solutions that you would already have in your IT ecosystem.See if the solution has on-the-shelf connectors, and see also the price / support to see which one of them will match your requirements the best. Eric