About Our Client
Our client is one of the UK’s most respected children’s hospital charities, dedicated to providing the best treatment and care to seriously ill children. They aim to leave no child behind and offer them a happy childhood. The charity supports medical research on critical diseases and illnesses, cutting-edge treatments, and family-centered care to help all children across the UK.
Business Objective
The charity was looking for a solution to modernize its integration platform by replacing the existing complex and high-maintenance Talend setup. They sought to reduce reliance on external vendors, reduce licensing costs, and accelerate integration delivery. Additionally, our client sought to empower their internal team with a low-code platform to align with their operational and fundraising goals.
Challenges Faced by the Charity
The charity relied on a legacy ETL platform, Talend, for its integration needs. Talend was once a reliable ETL solution, but today it struggles to meet modern integration demands. To maintain Talend, our client required extensive coding expertise due to its lack of flexibility and low-code capabilities. A significant amount of business logic was programmed using Java, so even minor updates to the integrations led to dependency on external vendors, resulting in high costs and slow delivery cycles.
While Talend had served its purpose earlier, it was proving to be
- Expensive due to high licensing costs
- Required experienced developers to manage Talend
- Dependency on external vendors for minor changes
- Lack of flexibility, limiting, scalability, and innovation
Why did the charity choose to migrate to Boomi?
Boomi is known as the most reliable iPaaS. The ideal blend of agility, scalability, and ease of use makes it the best solution for organizations with limited internal resources and big integration goals. Boomi’s low-code and cloud-native capabilities enabled the charity’s small team to have complete control over their integrations without relying on external vendors. It reduced the cost of vendor support, decreased deployment time, and offered advanced built-in features to map, monitor, and automate processes.
How NeosAlpha Helped?
With their Talend license approaching renewal, the pressure was to migrate fast, reduce costs, and equip their in-house team with a more agile and modern integration platform.
We partnered with the charity to offer them a smooth and timely migration from Talend to Boomi. With the Talend license set to expire in three months, our team proactively accelerated the migration timeline to avoid the need for a costly one-year renewal. With meticulous project planning and a collaborative approach with the client, we successfully migrated over 70 integrations to Boomi within three months.
We initiated the process by conducting a thorough analysis to understand their integration landscape, enabling them to migrate to Boomi with minimal downtime and disruption.
We also trained their team to understand Boomi, enabling them to resolve queries and leverage its full potential quickly. Our agile approach, collaboration, and deep understanding of both systems ensured a future-proof transition with zero downtime.
1. Migration from Talend to Boomi for Cost-Efficiency
The hospital charity used Talend, which required extensive coding knowledge, vendor intervention, and a high license investment. They sought a faster and more cost-effective alternative for their integration capabilities.To address all the challenges, we introduced Boomi, the low-code integration platform. Our team successfully migrated their Talend instance to the Boomi platform by completing over 70 integration processes before the renewal deadline, resulting in significant time and licensing cost savings.
2. Reverse Engineering and Process Documentation
Our approach to reverse engineering involved beginning with existing integrations by mapping out data flows, dependencies, and system interactions across their environment. Even though it was a reverse engineering and migration project, we did not just recreate the existing solution; we optimized and improved it wherever opportunities were identified.
This approach helped us understand their existing architecture and recreate it within the Boomi framework.
3. Integration Between Salesforce and Agresso
Donation and payment management between Salesforce and Agresso was a critical task.
A directional integration process automated the generation and updating of order numbers, reconciled payment data, and ensured that both systems reflected data in real-time. Salesforce-recorded data, such as donations from various channels, was validated and then pushed to Agresso to update accounts and enhance accuracy.
4. Real-Time Sync with Enterprise Data Warehouse
The charity relied on data warehouses to drive insights, compliance, and strategic planning.We implemented data synchronisation workflows that fetched, cleaned, and consolidated user, donation, and transaction data from Salesforce and Agresso. These processes ensured regular updates to the warehouse, enabling their systems to reflect the most up-to-date information.
Technology Stack
The solution leveraged the following technologies:
- Talend
- Boomi
- Agresso
Results
Our approach helped the charity successfully migrate to Boomi, eliminate vendor dependency, and build a future-proof integration solution. Here is what the charity achieved with our solution and support:
- Successfully migrated to Boomi with over 70 integration processes.
- Re-engineered the processes and deployed them within 3 months before the client’s Talend license expires.
- Minimal downtime and zero operational disruption during the Boomi migration.
- Automation of donation, order, and payment processing across Salesforce, Agresso, and the data warehouse.
- The charity team can manage the integration internally without depending on vendors for small changes.
- Developed a cost-effective solution by eliminating high licensing fees for integration platforms.
