Data Integration Across Salesforce, Sage HR, PowerBI, and Runn
Pharmaceutical Manufacturing
2 months
Dublin, Ireland 
Azure SQL Database|Bitbucket Pipelines|Docker|Node.js|Runn API|Sage API|Salesforce API
Advanced ETL Application Development|Data Integration|DevOps|Project Management
Dedicated team behind the project
The Client
APC, founded by Dr. Mark Barrett and Prof. Brian Glennon of UCD School of Chemical and Bioprocess Engineering, specializes in accelerating drug process development for the pharma and biotech industries. Known for their commitment to breakthrough science, APC enables biopharma companies to significantly reduce drug development times through innovative processes and radical collaboration.
Client Achievements:
THE CHALLENGE
The client sought to integrate their newly adopted resource management platform, Runn, with their existing systems – Salesforce, Sage HR, and PowerBI – to enable real-time data synchronization and improve reporting accuracy.
The integration required:
- Ensuring that any changes in Salesforce or Sage HR data were instantly reflected in Runn without manual intervention.
- Consolidating and transforming data from multiple systems to meet specific business requirements and support insightful PowerBI visualizations.
- Developing a system to schedule regular, automated data migrations while ensuring reliability.
- Building an idempotent solution capable of handling interruptions without creating duplicate or inconsistent data.
- Implementing a robust architecture to handle increasing data volumes and adapt to future needs.
What Was Done
To address APC’s challenges, Ralabs developed an advanced ETL solution designed to synchronize data across platforms seamlessly.
The work included:

- Development of a Node.js Migration Application: Built to extract data from Salesforce and Sage APIs, transform it according to business rules, and load it into Runn.
- Dockerized Integration Service: The application was containerized using Docker for scalability and ease of deployment.
- Automated Scheduling with Cron Jobs: Ensured data migration occurred at specified intervals without manual intervention.
- Real-Time Data Synchronization: Enabled live data updates, ensuring that changes in Salesforce or Sage HR were automatically reflected in Runn.
- Business Insights Integration: Prepared and merged data from Sage and Salesforce with Runn, enabling detailed analytics in PowerBI.
- Idempotent Execution: Designed a migration process that could restart without duplicating data or introducing errors.
Implemented Features:
Extracted and transformed data from Salesforce, Sage, and Runn APIs, enabling precise business insights.
Enabled live data updates between systems with configurable sync intervals and automatic error handling with retry mechanisms for accuracy.
Provided real-time insights through a cloud-based logging mechanism.
Enabled on-demand data migration checks with comprehensive reporting.
Connected Salesforce CRM API, Sage API, Runn, and Azure SQL Database to ensure seamless data flow, automated synchronization, and reliable Power BI reporting.
Prevented poor-quality data (e.g., duplicates, typos) from affecting system performance.
Ran scripts only when new or updated data appeared, improving efficiency.
Provided technical and non-technical documentation, including data preparation for Power BI, structured datasets, and guidance on charts, dashboards, and visualizations for key metrics.
Addressed 100+ business cases to ensure system reliability.
Developed an interface to notify users about migration results, detailing migrated and newly added data.
Provided training sessions on script usage and migration processes.
Results
Delivered robust solutions for over 100 critical scenarios and edge cases, ensuring flawless handling of complex dependencies like client removals
Achieved lightning-fast runtime, reducing data migration checks to just 16 seconds when no source changes occurred
Configured Runn and Power BI databases to seamlessly store and manage thousands of records from Sage and Runn, with a caching mechanism ensuring high performance when no source data changes
Increased data integrity during UAT, addressing issues like duplicates and typos at no extra cost
Implemented an ETL (Extract, Transform, Load) process, consolidating data from Salesforce, Sage, and Runn to generate structured datasets for charts, dashboards, and visualizations in Power BI
Tech Stack
Our partners say
Muhamad Gamal El Dean
Senior Project Manager at APC Ltd.
Working with Ralabs was a great experience. They helped us connect several systems, ensuring our data stayed synchronized across all platforms we use. Now, we can quickly access accurate insights and reports, saving us significant time and effort.
The team’s attention to detail and problem-solving skills were impressive. They have a strong domain knowledge, and they proactively added extra features that weren’t initially discussed. Thanks to Ralabs, we now have a simpler and more effective process, and their support during testing was invaluable.
Alina Tivadar
Associate Project Manager at APC Ltd.
Ralabs was recommended by our network, and they turned out to be exactly what we needed. Their relevant experience and domain knowledge matched everything we were looking for. We’re especially grateful for the extra effort they put in – adding features that gave us more transparency into how the solution works, preparing detailed tech & non-technical documentation, slides and diagrams, and even training sessions for our team. Thank you, Ralabs, for going above and beyond to deliver a solution that exceeded our expectations!
Daniel
Head of Engineering at Ralabs
Transforming Data into Actionable Insights
Explore how innovative integrations can elevate your business operations.
Other Cases
