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.
Question
Shape column is not showing from oracle spatial table in both reader and writer
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
+26- Contributor
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.