GEOKETTLE: A POWERFUL OPEN SOURCE SPATIAL ETL TOOL
Geospatial Business Intelligence (BI) tools (geo-analytical dashboards, reporting and Spatial OLAP) present to users summarized data from operational systems in interactive maps, charts, graphs and reports. They allow decision-makers to analyze data in order to make better decisions. They rely on data warehouses which organise geo-analytical data according to dedicated data structures (e.g. star schemas). They enable a fast navigation in large data volumes in order to not hinder the analysis process flow. Some spatial ETL (Extract, Transform and Load) tools are used to build such data warehouses. GeoKettle, a spatially-enabled version of Pentaho Data Integration (Kettle) is a powerful, metadata-driven spatial ETL tool dedicated to the integration of different spatial data sources for building/updating data warehouses. It is part of the open source geospatial BI software stack designed by the GeoSOA research group at Laval University and now developed and supported at http://www.spatialytics.org.
At present, Oracle spatial, PostGIS and MySQL DBMS and ESRI shapefiles are natively supported in read/write modes. It is thus possible to build and feed complex and very large geospatial data warehouses with GeoKettle in these different DBMS. Spatial Reference Systems management and coordinates transformations have also been fully implemented and an active and growing community has federated around the project.
This talk will present and demonstrate how GeoKettle works and its different features. Based on progressive real case study samples, the attendance will learn the basics of GeoKettle and will be able to assess the potential benefits of such a tool for their organisation. It will also be the opportunity to present the new features supported by GeoKettle: read/write support for new data formats and DBMS (GML, KML, ...), OGC SOS and WFS support, a geospatial previewer, some conflation and geospatial data cleansing capabilities, etc.
Thierry Badard - Spatialytics