WaterAid: From Custom Codes to Jitterbit Data Integration

Endpoints: A Salesforce to INFOR SUN to Mwater to Yammer to FTP to BasWare to MS PowerApps to Project Center to RIS to Board BI to MS Dynamics to SQL Datawarehouse to Social Media Success Story

“Some things were just not possible without Jitterbit.”
– Christopher Agopian

Background

WaterAid is an international non-governmental non-profit, focused on water, sanitation, and hygiene. The organization was established by the UK water industry in 1981 as a response to the UN International Drinking Water Decade. In 2010, WaterAid expanded to become an international federation with entities in the UK, USA, Australia, Japan, Sweden, Canada, and India. Its focus is to provide people around the world with clean water, safe sanitation, and better hygiene. Their main offices are in London, but WaterAid operates in 34 countries around the world.

Challenge

Oversite of funding cumbersome and time consuming. Integrations were taking a couple of staff-days to code per month. Synthesizing and reporting information, as well as documenting events and activities, were complex. Graphs were not automatically calculated and needed to be tracked through monthly postings.

“Jitterbit offers us the opportunity to introduce automated integrations as the need arises. It scales up!”
– Christopher Agopian

Outcome

• Data driven performance management
• Donors pleased
• Easier to create success stories for grant applications

Solution

An integration platform centered on Jitterbit Harmony. A full-featured cloud integration platform that brings together data, apps, and devices with and without coding. Using Harmony, organizations like WaterAid can quickly and easily orchestrate, automate, and integrate various applications, business processes, and data views. Jitterbit Harmony makes it easy to integrate your systems so you can focus on what you do best.

Results

Jitterbit has improved planning at a federated and country program level. Program managers can now compare budgets against operational plans. Before Jitterbit, it was not clear which system was correct. Data transfer is now made on a secure, scheduled, and reliable way. Among other things, reliable data transfer enables development officers to manage their own budgets daily. Jitterbit’s alerting capability identifies when something goes wrong, allowing IT to respond before an issue becomes a wider business problem.