Tuesday 23 June 2009

First release of GeoReport for SpagoBI Platform!

Thanks to the technology partnership agreement signed by Engineering and Inova, GeoReport for SpagoBI 2.1 was released!

This first version, “SpagoBIGeoReportEngine”, is based on SpagoBI 2.1 platform and able to execute SpagoBI Analytical Documents directly from the map click using an OGC compliant WebGIS client.

Integration with SpagoBI represents an evolution of GeoReport engine highlighting its flexibility and adaptation towards new Business Intelligence platforms. SpagoBIGeoReportEngine interprets a new way to satisfy business requirements through the usage of SpagoBI and jointly WebGIS tools.

For SpagoBI 2.1 you can execute SpagoBI documents directly from cartographic features selection and display the results on a georeferenced map. The collaboration between the two companies is structured according to a precise roadmap, so future versions of SpagoBIGeoReportEngine are expected in the next months!

GeoBI is following now two ways:

  1. one for PentahoBI suite

  2. one for SpagoBI platform

with the aim to keep and improve the same paradigms, standars and logic!

Please, try it!

Download here!

Monday 15 June 2009

GeoKettle on Sourceforge portal

The GeoKettle project now relies on the project hosting infrastructure offered by Sourceforge. You can access the project on the Sourceforge portal.
Among other things, you will now be able to access to the svn repository of the project and to an issue tracking system.
Note that a new version (3.2.0-20090609) of GeoKettle has just been released.




What is new since release 3.1.0-20081103?
  • The GeoKettle extensions were ported to the new Pentaho Data Integration (PDI) version 3.2.0-stable. As such, this release of GeoKettle includes all the improvements from the new PDI version.
  • Added a "GIS File Output" step. At present, this step supports the writing of Shapefiles
  • Added support for Spatial Reference Systems (SRS). SRS metadata was added to ValueMeta for Geometry fields. Steps allowing to set a SRS ("Set SRS") and transform coordinates (reproject) of geometries from one SRS to another ("SRS Transformation") have also been developed. The SRS support is based on GeoTools' implementation of coordinate reference systems (org.opengis.referencing package)
  • In line with SRS support, SRS metadata for PostGIS and Oracle Spatial DBMS is retrieved and written when reading/writing geometry columns. To conform to integrity constraints when writing to a geometry column, one must ensure that the SRS in GeoKettle matches the one defined for the geometry column in the DBMS.
  • Reading and writing SRS metadata (in the form of .PRJ files containing WKT definitions of SRS) is also supported when reading/writing Shapefiles in the GIS File Input/Output stepsUpdated GeoTools libraries to version 2.5.5 and JTS to version 1.10

GeOLAP: news from GSoC 2009!

Spatialytics-GeoReport integration project for GSoC 2009 started about 3 weeks ago and you can follow related news on this page!


The aim of the project is to develop GeOLAP module in GeoReport by using Sptialytics and Pentaho CDF with the aim to set and create GeoDashboards as easy as possible both for spatial OLAP cubes navigation and for charts, diagrams, indicators displaying directly from the map click, depending on user needs!

There are ongoing discussions to see if it is better to modify Spatialytics using Pentaho CDF logic or create a new project composed by GeoReport, GeoMondrian and Pentaho CDF.

Please, stay tuned!