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?

closed as too broad by PolyGeo Jul 6 at 4:08

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 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? – RyanDalton Feb 4 '14 at 18:59
  • 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