Good Morning!
I'm having trouble generating a stream that converts data of type MDSYS.SDO_GEOMETRY (oracle spatial) to SDE.ST_GEOMETRY (arcgis).If it is possible, is there any procedure or manual to perform this activity?
Thanks in advance for your cooperationExplo:
By far the easiest solution is to simply use an Oracle Spatial reader and send everything to an ArcGIS SDE writer. FME should take care of the rest.
Open FME Workbench and select Generate workspace, select your input tables and output database and that's about it.
The problem is when converting the information MDSYS.SDO_GEOMETRY - oracle spatial to SDE.ST_GEOMETRY - ArcGIS, I do not know how to do this conversion.
The problem is when converting the information MDSYS.SDO_GEOMETRY - oracle spatial to SDE.ST_GEOMETRY - ArcGIS, I do not know how to do this conversion.
+6By far the easiest solution is to simply use an Oracle Spatial reader and send everything to an ArcGIS SDE writer. FME should take care of the rest.
Open FME Workbench and select Generate workspace, select your input tables and output database and that's about it.
@david_r, Could you suggest how to perform the conversion from sdo_geometry to st_geometry in case we are not using ESRI? This because the field type of a DB we need to integrate uses that datatype and we can't modify it. So far I'm using an oracle query that do the job like ST_POLYGON(SDO_GEOMETRY)) but it implies to output sdo_geometry in a table and then run a sql query to fill in the final one. Thx.
@david_r, Could you suggest how to perform the conversion from sdo_geometry to st_geometry in case we are not using ESRI? This because the field type of a DB we need to integrate uses that datatype and we can't modify it. So far I'm using an oracle query that do the job like ST_POLYGON(SDO_GEOMETRY)) but it implies to output sdo_geometry in a table and then run a sql query to fill in the final one. Thx.
I'm not sure this is possible unless you've got the ArcGIS libraries (plus the corredsponding license).
+6I'm not sure this is possible unless you've got the ArcGIS libraries (plus the corredsponding license).
@david_r, unfortunately the customer is not using Esri products. Honsetly I don't know why the company that developed their solution decided to go for st_geometry instead of sdo_geom. Considering that the data upload is not so frequent, I can keep the multi-step procedure to upload in a temporary table and then to run a sql script at the workbench end.
