Real-Time Strava & Azure Integration
Project overview
Built a real-time Strava-to-Azure data pipeline using webhooks and Azure Logic Apps to automatically collect and visualize fundraising fitness activities.
Client information
ABF The Soldiers Charity is the National Charity of the British Army, supporting soldiers, veterans, and their immediate families in times of need. The charity conducts nationwide fundraising initiatives and fitness challenges to raise vital support for armed forces members.
Business challenge
To manage complex cases, our customer uses special technology solutions. Portfolio management is handled through modern, data-driven tools, and when cases go to litigation, these tools help ABF The Soldiers Charity make the whole process faster, more transparent, and harder for assessors to ignore.
ABF The Soldiers Charity needed to automatically track participant fitness activities from Strava for fundraising campaigns without any manual data entry.
The second challenge involves an increase in operational risk. With no clear visibility into problem areas, every investment decision was made amid significant uncertainty.
The final challenge was to define a clear roadmap for modernization across all layers (infrastructure, frontend, backend, and database) to guide future improvements.
Technical challenge
One of the main technical challenges was assessing a complex multi-layer system without causing disruption, while also prioritizing findings across architectural, operational, and organizational vulnerabilities. Additionally, it was essential to present findings in an actionable format, rather than simply cataloging historical changes.
Solution delivered
Aridian Technologies conducted a comprehensive engineering & development program to address all challenge areas. We implemented Azure Logic Apps workflows triggered by Strava webhooks, streaming activity data into Azure SQL with Power BI visualization for campaign tracking. Each finding was evaluated for severity and complexity, accompanied by actionable recommendations, and mapped into a phased modernization roadmap. This approach provided ABF The Soldiers Charity with a solid foundation for a structured, evidence-based remediation program.
Key deliverables
Team processes and project management review
- >Definition of team structure, roles, and responsibilities
- >Description of current processes and project management practices
- >Recommendations for improvement
Back end and database architecture review
- >100% automated activity data collection — zero manual entry
- >Real-time fitness metrics visible in Power BI dashboards
- >Webhook-driven pipeline processes new activities within seconds
- >Enabled data-driven fundraising campaign reporting
Front end review
- >Project structure assessment and recommendations for refactoring
- >UI/UX improvement recommendations
- >High-level security review and recommendations for improvement
Infrastructure review
- >Infrastructure patterns review and recommendations for improvement
- >Cloud resource utilization, security compliance, and cost optimization audit
- >Disaster recovery, backup protocols, and high-availability configuration review
Value delivered
Actionable modernization roadmap
Developed a clear, phased plan for system improvements, enabling the client to address technical debt and scale efficiently.
Risk reduction
Provided visibility into critical vulnerabilities, empowering the client to proactively manage operational and security risks.
Improved decision-making
Equipped stakeholders with evidence-based insights to support informed investment and resource allocation decisions.
Enhanced operational resilience
Ensured recommendations were sequenced to avoid production disruptions, resulting in a more robust and dependable platform.
Our tech stack
Real-Time Strava & Azure Integration
Project overview
Built a real-time Strava-to-Azure data pipeline using webhooks and Azure Logic Apps to automatically collect and visualize fundraising fitness activities.
Client information
ABF The Soldiers Charity is the National Charity of the British Army, supporting soldiers, veterans, and their immediate families in times of need. The charity conducts nationwide fundraising initiatives and fitness challenges to raise vital support for armed forces members.
Business challenge
ABF The Soldiers Charity needed to automatically track participant fitness activities from Strava for fundraising campaigns without any manual data entry.
Technical challenge
One of the main technical challenges was assessing a complex multi-layer system without causing disruption, while also prioritizing findings across architectural, operational, and organizational vulnerabilities.
Solution delivered
Aridian Technologies conducted a comprehensive engineering & development program to address all challenge areas. We implemented Azure Logic Apps workflows triggered by Strava webhooks, streaming activity data into Azure SQL with Power BI visualization for campaign tracking. Each finding was evaluated for severity and complexity, accompanied by actionable recommendations, and mapped into a phased modernization roadmap.
Key deliverables
Team processes and project management review
- >Definition of team structure, roles, and responsibilities
- >Description of current processes and project management practices
- >Recommendations for improvement
Back end and database architecture review
- >100% automated activity data collection — zero manual entry
- >Real-time fitness metrics visible in Power BI dashboards
- >Webhook-driven pipeline processes new activities within seconds
- >Enabled data-driven fundraising campaign reporting
Front end review
- >Project structure assessment and recommendations for refactoring
- >UI/UX improvement recommendations
- >High-level security review and recommendations for improvement
Infrastructure review
- >Infrastructure patterns review and recommendations for improvement
- >Cloud resource utilization, security compliance, and cost optimization audit
- >Disaster recovery, backup protocols, and high-availability configuration review
Value delivered
Actionable modernization roadmap
Developed a clear, phased plan for system improvements, enabling the client to address technical debt and scale efficiently.
Risk reduction
Provided visibility into critical vulnerabilities, empowering the client to proactively manage operational and security risks.
Improved decision-making
Equipped stakeholders with evidence-based insights to support informed investment and resource allocation decisions.
Enhanced operational resilience
Ensured recommendations were sequenced to avoid production disruptions, resulting in a more robust and dependable platform.
Our tech stack
Have a similar challenge?
Let's Talk