Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 7 down vote favorite
2

Just wondering if there is any open source solution which comes close to safe FME? I would like to integrate it into my workflow, but it´s just another few thousand which my employer has to give out for software.

If anyone knows of anything similar, please let me know.

yours,

Rob

share|improve this question
4  
Possible duplicate: gis.stackexchange.com/questions/5049/spatial-etl-comparisons – blah238 Apr 29 '12 at 10:57
1  
Please refine your need. Do you have a specific workflow, or do you need a multi-purpose ETL ? – Vincent Apr 29 '12 at 11:14
multi-purpose ETL opensource software please! – Robert Buckley Apr 29 '12 at 19:38

4 Answers

up vote 4 down vote accepted

If you look at blah238s duplicate link you find more information. I would say that Talend Open Studio and Pentaho GeoKettle is the most prominent open source solutions one can choose. Of these two Talend targets more than just ETL and GeoKettle a little more easy to use as far as I have read.

My municipality are about to give GeoKettle a go as we are having problem using FME to write a GML dialect put together by the swedish association of local authorities and regions (SALAR) and we need this format to deliver geodata to different commercial intrests.

And I believe GeoKettle have support for OGR/GDAL from version 2.0...

share|improve this answer
3  
Hi. Mark Ireland from Safe Software here. I'm obviously going to be as neutral as I can, and not say you should or shouldn't use one product over another. But what I can say is that if you have an XML or GML problem with FME, please email us using xml@safe.com - that address goes straight to our president who is an XML addict and has a standing challenge that there is NO XML/GML problem that he (and FME) cannot beat! So please, whatever route you take, send us an email anyway because we'll want to investigate this format regardless. – Mark Ireland May 4 '12 at 16:33
up vote 7 down vote

I love open-source but FME easily wins out against the opensource ETL's as best I can tell. It's actually quite cheap for maintenance and support too (at least compared to most other corporate solutions we have for things).

If you're looking for translations between formats then OGR may do it (with some piping into GDAL for transformations). Of course, that's command line.

For visual modelling beyond those listed in the "possible duplicate" comment, they're working on a QGIS/SEXTANTE model builder; proof of concept video: https://www.youtube.com/watch?v=LTUu-I2ouqU

(No, I don't work for Safe, I'm just a relatively happy customer).

share|improve this answer
Agreed. FWTools (which GDAL/OGR are a part of) is something to try, but for ease of use, number of formats, and overall productivity FME is a lock. I spent over a year cobbling together open-source alternatives and wasn't happy with any, GDAL/OGR being the best. – Lou Apr 30 '12 at 12:23
The QGIS/Sextante ModelBuilder looks really impressive. It looks like it will be a great addition when it is fully hashed out. – RyanDalton Apr 30 '12 at 17:59
up vote 5 down vote

Most of the simple operations can be carried out by these open source utilities

  • ogr2ogr for vector
  • gdal_translate and gdalwarp for raster

Get FWtools http://fwtools.maptools.org/ and give it a try.

share|improve this answer
up vote 4 down vote

FME is probably the best product to use in this space. After that it's GDAL/OGR. Another open source product in this space is geokettle - http://www.spatialytics.org/projects/geokettle/ although I have never used it in anger (being lucky enough to have both the other products mentioned).

If none of those generic options work, you probably want to use a specific conversion tool - what exactly do you need to ETL within your workflow?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.