Hi
I am trying to transfer data from Oracle sde database from one server to other with same environment. But when i add reader and writer these get other columns but miss shape column.
Please experts guide me.
Page 1 / 1
Hi
If you use the SDE reader/writer, the shape column won't show as an attribute, this is normal. The geometry is automatically handled by FME, not as a value but as a proper geometry. If you need to rename the shape column, you can do it in the feature type properties, under the "Format parameters" tab.
David
Same as @david_r mentioned is true for the Oracle Spatial Reader. The geometry (SHAPE) is the feature in FME and will be written to the table column defined in the writer featuretype.