£s saved Using existing tech
Data Quality improved
Easy To flex

Background

The Environment Agency (EA) is the largest organisation within DEFRA, and is responsible for a variety of environmental issues in Great Britain including flood management, and air, land and water quality.

In 2013, Natural Resources Wales (NRW) was established with a view to become the authority on Welsh environmental matters.

The Challenge

Natural Resources Wales was due to be created, however it was clear that data collected by NRW would be of interest to EA, and vice versa. The division of responsibility would result in numerous issues and questions raised due to the shared border and the prevalence of common projects and environments. For example, if waterways feeding the River Severn in Wales increase in volume, this has the ability to flood major urban areas in Worcestershire and Gloucestershire. An environmental problem with its beginnings in Wales (under NRW jurisdiction), could easily have consequences in England (under EA jurisdiction).

The hugely important sharing of data between the two organisations was complicated by NRW’s decision not to replicate EA systems, focussing instead on cloud-based technology. This meant that data could not be shared in proprietary formats.

 

FME logo on the screen of a laptop

The Solution

EA needed a robust and scalable solution that would be flexible enough to adapt in-line with changing requirements.

The two organisations mutually agreed to use XML and XSD as the standard formats for the data transfer.

EA already had FME, and decided to reuse this to create a process which:

For organisation 1:

• Extracted new/changed data from the database and created an XML to XSD schema.

• Uploaded data to cloud-based storage.

For organisation 2:

• Downloaded and validated the incoming data against the agreed XSD schema.

• Loaded the data into their database.

Environment Agency use FME to automate the sharing of data with Natural Resources Wales

FME® automates data manipulation and transformation

Data rarely arrives in your environment in a state that’s ready to use. The repetitive tasks required to get it into a usable form are laborious and costly. FME® automates these data manipulation and transformation tasks, leaving you to work much more efficiently with your newly optimised data set.

Here’s the problem; you have lots of data from lots of different internal and external sources, but managing it all can be difficult. You’re faced with a unique set of challenges that have a large impact on the way you work:

  • Driving value for your organisation by making the most of your business intelligence.
  • Managing the complex combination of data sources, formats and destinations.
  • Dealing with evolving data, resources and requirements.