This article is by Carole Gunst and originally appeared on the Qlik Blog here: https://blog.qlik.com/save-the-children-moves-real-time-data-to-azure-data-lake-with-attunity
When the IT Business Solutions Group at Save the Children need to move their data from disparate CRM and ERP systems to Azure Data Lake Storage (ADLS), they used Attunity solutions. Now, their data analysts have insight into their data and can run up-to-the-minute reports to help them with their critical business initiatives.
Background
Save the Children believes every child deserves a future. Since their founding 100 years ago, they’ve changed the lives of more than 1 billion children. In the United States and around the world, they give children a healthy start in life, the opportunity to learn and protection from harm. They do whatever it takes for children – every day and in times of crisis – transforming their lives and the future we share.
Challenge
The IT Business Solutions Group located in Fairfield, CT was working on a new business intelligence (BI) initiative. Santha Kumar, Director of Application Architecture and Development, was leading the project to move data onto a data lake in the cloud so that the data analysts could use to measure program and financial data from across the Agency. To do this, the IT team at Save the Children needed to work with real-time data from their CRM and ERP systems rather than a snapshot of yesterday’s data. And, they couldn’t afford any downtime.
While Save the Children primarily uses Microsoft technology, the IT Business Solutions Group had tried using other tools for some of their ETL work. Unfortunately, it wasn’t proving to be the right solution for moving bulk data.
Solution
They selected Attunity Replicate as the data integration software to move their data from multiple sources to Azure Data Lake Storage (ADLS) to Azure SQL Data Warehouse. Now, the data analysts at Save the Children will have insight into their data in real-time. They are no longer siloed. They also can run up-to-the-minute reports to help them with measuring various areas of their business and reacting immediately to address those needs. Save the Children is also looking at Attunity Compose to automate their data warehouse.
“With Attunity, we’re able to better integrate data from multiple sources – including our CRM and ERP systems. Working tightly with Microsoft technology, Attunity’s solutions make our data available immediately so that data analysts across Save the Children have access to the freshest data possible for real-time analytics and reporting.” -- Santha Kumar, Director of Application Architecture and Development, Save the Children