Skip to main content
Question

Updating ArcGis directly from SQL server

  • February 18, 2021
  • 1 reply
  • 40 views
Z

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

canerakin
Contributor
Forum|alt.badge.img+6
  • canerakinContributor
  • Contributor
  • February 28, 2021

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.

Community Stats

32,757
Posts
124,226
Replies
41,278
Members
Terms & ConditionsAccessibility 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.