Question

Updating ArcGis directly from SQL server

  • 18 February 2021
  • 1 reply
  • 2 views

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?


1 reply

Badge +4

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