Skip to main content
Question

Damage to SDE spatial record with Oracle Non-Spatial Writer???

  • July 9, 2018
  • 1 reply
  • 16 views
hlouie
Contributor
Forum|alt.badge.img+16

We have SDE connected with an Oracle backend database

The proposal is to use FME Oracle Non-spatial reader, FME for update required tabular data and FME to write the record with updated tabular via FME Oracle Non-spatial writer. Geometry will never change just updating tabular data

Yes, I could use FME SDE Reader but when I looking a 400,000 spatial with tabular records, it's slow

QUESTION, will this damage the spatial record?

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.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • July 10, 2018

If you're only looking to update attribute data and not the geometry, I'd rather recommend using the SQLExecutor, it should be the best performing option since you can specifically target only the necessary columns to update, without touching the geometry column, e.g.

UPDATE my_table
SET my_attribute = 'new_value'
WHERE my_primary_key = 12345

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.