London Borough of Hackney Council needed a solution to automate the loading of data feeds from organisations such as Transport for London (TfL) and the NHS, into its own Oracle database.
Due to the multiple sources of data that the Council were compiling, it was inconsistent in both format and quality. Manually loading the separate data feeds into their database took time and effort from Council employees.
The Miso team used FME to create an API link to the Council’s Oracle database for other organisations to connect to. FME workspaces were also developed and delivered to the council which automatically transformed the data feeds into the Council’s standards before uploading them into the database.
The solution saved time and resource for the Council, and also ensured that the Council could more easily work with the data that it sourced from third parties.