With the release of GeoKettle 2.0-RC1, various tools (wiki, trac, forum, …) have been set up and made available for supporting the community interested in open source projects hosted on spatialytics.org and developed by Spatialytics.

This blog post initiates a series of documentation posts that should help users and developers in better mastering GeoKettle. It will be followed week after week by different tutorials, how-to, tips and tricks that will detail some specific and interesting capabilities offered by this open source spatial ETL tool.

This first post deals with the creation and usage of a job/transformation repository. It is a very powerful and exclusive but not so known feature of GeoKettle. A repository in GeoKettle lets you create a common workspace where to share jobs and transformations between different users across your organization. It is a practical way for some users to collaboratively work on a data integration process and to keep track of changes on the jobs and transformations during time. As it allows the centralisation of jobs and transformations in a shared repository, it avoids having different versions of a same transformation on various computers, which often results in the users finally do not know anymore what is the right and up-to-date version of the transformation.

To know more and especially how to create and use such a job/transformation repository in GeoKettle, please visit the associated documentation page on the wiki.

Hope it helps and do not hesitate to provide us with feedbacks or ask questions on the forum.

Here it is, the version 2.0 of GeoKettle is now available to download. (Link to the official press release from Spatialytics Solutions Inc.)

A major milestone

Today marks a new era for this Open Source Spatial ETL. There was the « before version 2.0 » and there will be the « after version 2.0 ». We can talk about the « before version 2.0 » in person if we have the occasion but lets talk « now version 2.0 ».

Know that GeoKettle, in addition to our efforts to develop the product itself, is a tool at the heart of all our consulting projects and custom developments since the creation of the company in August 2009. GeoKettle is an incredible tool to clarify, automate, accelerate, standardize and secure all processes requiring steps and jobs to extract, process and load alphanumeric data as well as geometric data. That’s a Spatial ETL.

Read More

Thierry Badard will give the keynote address at OSGIS 2011, Nottingham, UK, June 22nd, titled : “Open Source Geospatial Business Intelligence (GeoBI): Definition, architectures, projects, challenges and outlooks”.

This is the third Open Source GIS Conference and will be held in the Centre for Geospatial Science, University of Nottingham.

Building up Open Source, Open Standards, Open Data research

The OSGIS conference series has a strong international focus and takes a holistic approach in bringing together speakers and delegates from government, academe, industry and open source communities. High profile speakers from all over the world are invited for giving presentations and running hands-on workshops for the conference series.

The full agenda of OSGIS 2011 is here.

Thierry Badard will give a Workshop on GeoKettle at FOSS4G 2011, in Denver, CO, September 12.

Workshops are 3 hour hands-on experiences with participants following along with the instructor, working directly with the application under discussion. Computers will be provided. Workshops will be held on the two days immediately before the main conference, Monday and Tuesday September 12-13. There is a separate fee for workshops.
Read More

The presentation Dr. Thierry Badard gave at FOSS4G 2010 in Barcelona is now online on SlideShare.net. The version of GeoKettle used in the demo was the next version, coming in the coming weeks, version 2.0.

Version 2.0, among other things, now benefits from the OGR Simple Feature Library ability to import/export from/to 33 vectorial file format and RDBMS. V. 2.0 also support .GML and KML.

Read More