Data integration and ETL

Good decisions are based on a solid foundation of data. Data records from different specialist applications which lay scattered over various servers, diverse database systems as well as data in different formats and qualities are an obstacle here. Disy supports you in all issues concerning data integration as well as in the preparation of your data, so that you can make fast decisions and fulfil your reporting and evaluation requirements.

In order for your data to be always up-to-date and quality assured in the future, we automate these data flows with the help of ETL processes (extraction, transformation and loading). We design and model the necessary ETL jobs or directly develop respective routines in the database. Depending on the requirements, we use modern data integration tools such as Talend with the Disy extension “GeoSpatial Integration” or tools for the transformation of special spatial formats such as FME from the company Safe. With our wealth of experience, we are in a position to provide you with comprehensive advice in terms of the strengths and weaknesses of the individual tools. Together with you, we design the best data flow solution for your organisation and your application requirements. To do this, we map database schemas to each other, data types are converted and key lists are harmonised. Data scrubbing, data aggregation and quality assurance are carried out on your data prior to dissemination or publication.

If desired, we additionally enrich your data in the data integration processes with official spatial data (e.g. BKG data), OpenStreetMap data, data from ESRI solutions and from commercial data providers such as GFK or Here, or also from sensor-based systems. By geocoding or integrating spatial services, we are proud to include our GIS know-how and help you expand your data with spatial information.

In future your data will be able to flow freely and automatically and will be available in a safe and excellent quality for well-founded decisions: for internal systems and also in the World Wide Web.