Extract, Transform, Load (ETL) is a process by which information is extracted from multiple different sources, transformed according to set rules then loaded into a unified data repository.
During the Extract stage, raw data is acquired from source locations, the data might come in the form of SQL servers, Comma Separated Values (csv) files, web pages and even emails.
During the Transform stage data is cleansed, filtered, and validated. Duplicate data for example might be removed alongside erroneous data.
During the Load stage, converted data is written to a target database ready for access or transfer to the client.
Spatial Database Development – A spatial database provided specialised management, processing and analysis engines for complex geospatial data. Typically, these are standard databases that have been extended to accept spatial data types and queries. At WKC Group we have extensive experience in developing and deploying both file based and server based databases both on premise and in the cloud. Some examples of spatial databases that we work with include Geopackages, Oracle Spatial and Graph, ESRI Geodatabases, SQLite , PostGreSQL/PostGIS and SQL Server with spatial extension.
Find out more about our related services by clicking on the links below: