Skip to main content
  • EN

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?

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

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
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.