I need to read geographic data from an ORACLE spatial database in Gauss Boaga SRS, convert them in WSG84 (EPSG 32632), e put them in another ORACLE spatial data base.

I've tried to use GeoKettle 2.5 but I think that there is some bugs because it seems not set SRID on the new geometries.

I need a tool that works on server side and I would not to extract data from the source database, convert them in some intermediate format, to apply the srs conversion and then put the data in the new destination database.

Is there any other open source ETL or some other tool?

  • 1. The data format of your geo objects if you request the oracle stuff how does it looks like. 2. Is there a JDBC driver to get the oracle stuff in and out 3. Are there meta formats for geo objects for the oracle db like GML or WKT to clip on an external tool like proj.4? – huckfinn Jan 30 '14 at 20:20
  • Have you tried FME, www.safe.com. They have free trials. – jeb Feb 4 '14 at 18:59
  • A couple of other similar questions that may be helpful to you: Spatial ETL comparisons as well as Is there any Safe FME alternatives? – RyanKDalton Feb 4 '14 at 18:59
  • 1
    you could use an ogr/gdal python script – Below the Radar Feb 4 '14 at 19:22
  • 1
    @cesare - do you know if Oracle has a "ST_Transform()" function similar to PostGIS? If so, you can use python with pypyodbc to do this... – DPSSpatial Feb 18 '16 at 22:26