We are building a custom mobile application using the ArcGIS Runtime SDK for iOS.
We have converted our SQL Server database into an enterprise geodatabase and published the feature classes and tables as a feature service to ArcGIS Online for the mobile app to consume and write data into it.
Almost the same question:
Published a hosted feature service layer to AGOL for use with the Collector app.
Made some edits (Status has been changed) and added new points
How do we get the edits back in to the geodatabase? Append doesn't work (duplicates) but what does?
Maybe I'm looking over the obvious, but I'm stuck at this moment
Using ArcGIS Pro 2.2.# Standard, a fgdb, AGOL and the Collector App
This article deals specifically with attachments but the first few steps are still applicable to your question. This would be a good way to get the edits made in Collector back into the original file geodatabase.
I've found, before calling TS with a SDE issue, to work through and solve all of the DB vendor performance issues first. On that note, please do call TS. Many of us are suffering horrible performance issues with SDE <-> Pro and more people experiencing the same problem means it likely will get fixed.
Thanks for the suggestion on the synchronization method.
Regarding the SQL Server, it’s an on-premises instance ( SQL Server 2017) in our data center. We can connect to and operate our database in this instance fairly quickly via SQL Server Management Studio.
The workflow we adopted is basically as follows:
1. Build a database for our app on the SQL Server instance
2. Use ArcGIS for Desktop to run the Enable Enterprise Geodatabase tool to enable the database as an enterprise geodatabase
3. Set up relationship classes and indexes among the feature classes and tables
4. Drag the feature classes and tables over to a map within ArcMap or ArcGIS Pro
5. Publish them as a web layer (feature service) to the ArcGIS Online portal
100% convinced the issue is with your relationship classes and indexes. How do they perform in SSMS when doing joins via select? Do them all, full join, left join, etc...look at query execution plan on each and see what's getting hit the most with cost. Again, rule out any DB issues first. Any performance difference between Pro and Map when "Dragging" Over? Do some zoom, pan, change symbology, bulk edits using a join. Need more details on "Publish them as a web layer (feature service) to the ArcGIS Online portal", are you publishing to a hosting server where SQL is a registered DB? A federated Server? A standalone GIS Server? How is auth setup? IWA? SSL? In your OP you mention AGOL....have you migrated this as a test environment to PTL? There are numerous "pain points" for a performance hit in enterprise. Again, TS, not Geonet, is going to ultimately solve this problem, but they're going to ask the same, and many more, detailed questions about your environment. Think instruct a robot to make a jelly sandwich. Specifically, how are you defining the indexes, and are they fragmenting already?
ArcGIS is still relatively new to our app dev team. We’ll optimize the database starting with indexes and relationship classes as you suggested.
Everything seems pretty smooth in SSMS.
Both ArcGIS Pro and ArcMap are slow ( e.g. 5 sec to right-click a table to display the context menu and 30 sec to get the properties ; no noticeable differences are observed between the two.
Sent from my iPhone