Data Migration
One of the most complex aspects of the project was migrating membership data from the legacy OpenEngage system, which lacked clear documentation, field-level rules, or consistent formatting.
Cantarus tackled this by:
- Conducting a detailed data audit to identify inconsistencies, duplicates, and incomplete records.
- Collaborating closely with Mothers’ Union to define business rules and data transformation logic.
- Applying data cleansing and validation checks during migration to ensure only quality data was transferred into Dynamics 365.
- Establishing a single source of truth for membership and volunteer data for the first time in the organisation's history.
In addition to data migration complexities, key challenges addressed in the project included:
- Undocumented Legacy System: OpenEngage lacked proper field definitions and enforcement rules, requiring manual interpretation and validation of thousands of records.
- User Adoption: Cantarus invested significant time in stakeholder workshops, change management, and training sessions to ensure smooth user onboarding and ownership.
- Complex Financial Processes: The Direct Debit cycle, involving six systems and multiple handovers, was completely reimagined into an automated, auditable workflow that minimised human intervention.
- Integration Landscape: Building seamless connections between Dynamics 365 and third-party systems (GoCardless, Business Central, Stripe, ClickDimensions, Shopify, Loqate) was critical to success and achieved with secure, scalable architecture.
The Results
The solution has transformed Mothers’ Union’s operations, reducing administrative burden, improving data quality, and enabling better engagement with members and supporters. Through deep collaboration and a practical, insight-driven approach, Cantarus has laid the foundation for long-term digital success and future growth.
Tangible outcomes include:
- Centralised member and volunteer data for the first time
- Significant reduction in manual processing across payment workflow
- Automated quarterly Gift Aid submissions for greater consistency
- Real-time insights into supporter activity via Dynamics 365
- Removal of spreadsheet dependency for donations and newsletters
- Greater autonomy for dioceses with self-service membership and finance tools