{"id":495768,"date":"2023-07-18T06:52:24","date_gmt":"2023-07-18T04:52:24","guid":{"rendered":"https:\/\/www.devoteam.com\/success-story\/omgevingsdienst-gets-more-control-of-their-data-through-new-data-platform\/"},"modified":"2025-02-11T10:51:33","modified_gmt":"2025-02-11T09:51:33","slug":"omgevingsdienst-gets-more-control-of-their-data-through-new-data-platform","status":"publish","type":"success-story","link":"https:\/\/devoteam.info\/en-nl\/success-story\/omgevingsdienst-gets-more-control-of-their-data-through-new-data-platform\/","title":{"rendered":"Omgevingsdienst gets more control on their information through new Data Platform"},"content":{"rendered":"\n

About the Omgevingsdienst Zuidoost-Brabant<\/strong><\/p>\n\n\n\n

The Omgevingsdienst Zuidoost-Brabant (hereinafter “ODZOB”) is one of 29 environmental services in the Netherlands and was established in 2013 in response to the Enschede fireworks disaster, the Hemeltje fire in Volendam and the Moerdijk disaster. Environmental services deal with a wide range of activities. For municipalities, province and network partners they perform tasks in the field of licensing, supervision and enforcement, and they give advice on environmental law. Nearly 240 ODZOB employees ensure a safe and healthy physical environment. Every day again.<\/p>\n\n\n\n

Way of working<\/strong><\/p>\n\n\n\n

ODZOB receives cases from external organizations. Think for example of a company that applies for an environmental permit or a municipality that requests that supervision be carried out somewhere. Via the requested cases the information is processed into a product: a license or an enforcement decision and thus delivered back to the chain (municipality, province or other authorities).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The challenge<\/strong><\/p>\n\n\n\n

The Omgevingsdienst used an on-premise SQL environment where various sources were collected, including data from the case system, land registry, KVK data. The SQL environment was used both to extract data from the sources and to generate queries for reports. In the old way of working, a lot of information got stuck in these systems or documents were stored somewhere directly. The Environmental Department was running into data system limitations and not being able to optimally use both internal and external data.<\/p>\n\n\n\n

The old data warehouse<\/strong><\/p>\n\n\n\n

Several years ago, an SQL environment had been set up that collected data and made it available for reports. At that time, the SQL environment was adequate and well built. But with the new developments, it became unstructured. To extract data, 1 large table was used, with more than 100 columns. This table was used in all kinds of reports, where it was not always clear where information came from and what transformations had taken place. This made it difficult to interpret the data and determine whether it had the right quality.<\/p>\n\n\n\n

In addition, there was no uniform notation defined for the data fields, there were no unambiguous keys of the different (source) objects and thus it was often not possible to link this data to other sources. Due to the size of the SQL environment, the Omgevingsdienst was unable to backup the entire table in one day.<\/p>\n\n\n\n

Information exchange for receiving as well as sharing information between different partners is crucial. The desire was that data could be delivered from the data environment rather than directly from the source applications. This should make it possible to continuously and automatically feed dashboards with fresh information.<\/p>\n\n\n\n

The solution<\/strong><\/p>\n\n\n\n

Devoteam took a pragmatic approach, so that results could be achieved within a relatively short period of time. This offered the possibility to start with a defined and limited investment and lead time, after which it could be quickly evaluated whether this solution met the wishes and expectations of the Omgevingsdienst Zuidoost-Brabant.<\/p>\n\n\n\n

Migration to the cloud<\/strong><\/p>\n\n\n\n

Since ODZOB already used Microsoft products within the organization, Microsoft Azure was chosen as the Cloud Provider. It was easy to integrate with the other products within the organization, including Power BI. The Omgevingsdienst migrated from an on-premise environment to the cloud platform, which brought many benefits. For example:<\/p>\n\n\n\n