An English council needed to combine mismatched same theme data from legacy systems to produce a single coherent dataset in Azure.
It used FME to map, transform, and load thousands of records into a central data warehouse.
Each legacy council captured, processed, and stored their data differently.
The Council used Unique Property Reference Numbers (UPRNs) as a key data point to match records to.
Data was matched to 122,000 households saving the council days of manual processing.
We get it – time is tight, and while you know there’s a whole lot more you could do with FME, having the space to explore that capability is tough.
That’s why we’re hosting a series of hands-on in-person events across the UK designed to quickly ramp up what you can do, connect you with other local FME experts, and give you this workspace ready-to-use.