Skip to main content
  • EN

I was looking into connecting directly SQL server to arcgis and ran into issues when using the update feature in the writer's field, can this be fixed? as when I have it on update I get number of errors, I have found a work around that issue by setting up insert and truncate features instead of update but this is taking too long, any idea why I the update feature is causing issues? and can it be fixed?

Hey @zain​ ,

If I understand correctly. Your source data is SQL Server, the workbench pulls the information, makes some changes, and loads it into the geodatabase.

 

You can bring the geodatabase as a source and use the ChangeDetecter transformer.

For ChangeDetector Ports

  • Original - SQL Server
  • Geodatabase

Choose the ID for the attribute. I would generate a list of changes.

Reply


Community Stats

30,163
Posts
114,502
Replies
37,817
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.