Using FME to convert oracle sdo.geometry to SQL geometry datatype

430 views Asked by At

Hi I have to take the sdo_geometry field from an Oracle database and transfer the data to a SQL database (probably a geometry spatial data type). Could you help me on how to use FME for that purpose? Do I need FME to do this?

1

There are 1 answers

0
Barett On

FME will certainly help make things easier, but it's possible to do your data ETL without it. You'll need to handle each of the different OGS types yourself, if you want to get around having to use a tool that is aware of the geometric datatypes like FME.