I have an excel file of points which are resurveyed with updated Coordinates.Now I want to update my existing arcsde geodatabase. How can i update only coordinates in FME?
GEODB reader, Excel reader, featuremerger (objectid), VertexCreator (replace point), GEODB writer (update, objectid).
The SDE writer can create new tables but also, insert rows and update rows. I'm by no means an SDE export but I think OBJECTID is the unique ID created by SDE. This way only the rows that are merged with excel will get a new coordinate and only updated rows will be sent back to writer. With no attributes changed it will update the row with the same values and new geometry.
I would create a copy of the table in SDE for test, add table sde reader, duplicate on writer, AttributeExposer to get OBJECTID, AttributeKeeper to keep only OBJECTID, duplicate on sde writer, strip all attributes, set writer mode to update, set writer key to OBJECTID.
I built an example with the GDB API in FME 2016. The writer differs but the basics are the same: https://dl.dropboxusercontent.com/u/36253197/update_point.zip