nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Enterprise 11.0: How “data store” can allow “exporting data, and adding or deleting fields?

JamalNUMAN

It’s mentioned in the manual that “hosted feature layers that rely on the relational data store allow you to more easily share and manage feature data in your organization” amongst “exporting data, and adding or deleting fields.

How this(“exporting data, and adding or deleting fields) can be performed?

https://enterprise.arcgis.com/en/portal/latest/administer/windows/what-is-arcgis-data-store.htm

Vind meer berichten getagd met

Accepted answers

All comments

ChristopherCounsell

You have options. Different workflows require different options. Esri facilitated all of them. It's a good thing. Like licencing, it can make it complicated, but if you can understand it it's the best thing for end-users.

If you are an enterprise database administrator. Do you think non-spatial staff can create feature classes in your database with the right naming convention? Do you want to provide them with read/write access? No. The ArcGIS Data Store lets them publish Hosted Feature Layers. Through applications like the Survey123 web designer, uploading CSVs directly to Portal for ArcGIS or from analysis. It's user-friendly, provides spatial to these users, and is easy to administer. The system handles the technical side.

Traditional user-managed service publishing is still available. Generally you do this when you want to work with the source data directly. Best example is publishing from an enterprise database and leveraging the full functionality of an RDBMS.

Think of driving. A go-kart on the track is friendly. Anyone can jump in. Works great. Sometimes you want a Ferrari. You can't put the Ferrari engine in the go-kart as people crash. So you need go-karts for new drivers and Ferraris for the good drivers who require more.

For the data location, I would recommend this page. It has images showing where the data sits when you publish each option and scenarios where you want it:
https://enterprise.arcgis.com/en/server/latest/manage-data/windows/overview-register-data-with-arcgis-server.htm

ChristopherCounsell

you can't add a field to an ArcGIS Server feature service through the service. You add it to the source data. You would need to turn off the lock on the dataset and then republish the service:
https://support.esri.com/en/technical-article/000012871

You can add a field to a Hosted Feature Service. You do so through the User interface. You can't access the database ydirectly and add the field.

https://enterprise.arcgis.com/en/portal/latest/use/manage-hosted-feature-layers.htm

https://enterprise.arcgis.com/en/portal/latest/use/add-or-delete-fields.htm

The comparison is again user managed (database, locks, schema updates) vs system managed (add a field or enable exports through the user interface).

JamalNUMAN

But why technically it’s impossible to gain all? To have all the advantages of “hosted feature layer” (as it behaves exactly as class feature where symbology, labeling, analysis, export, etc can be performed) along with having all the edits reflected on the source data?

In additon to that, I don’t figure out why “an ArcGIS Server designated as Hosting server should be a separate from another ArcGIS Server doing traditional map layers”

The Hosting Federated ArcGIS Server can do both:

Can publish data with traditional services (map image service). The published services are the same ones that are published with federated or unfederated ArcGIS Server
Can publish data with hosted services (feature layer)

In return, the Non-hosting Federated ArcGIS Server can’t publish “feature layer”

This means that the hosting federated ArcGIS Server can do all:

As a non-federated ArcGIS Server
As a federated ArcGIS server
Of course, as hosting federated ArcGIS Server

Scott_Tansley

Glad to see that this messaging is coming out from the 'factory' as well. It's my default standard as well. Nice.

NathanEnge

Map Image layers (traditional stand-alone arcgis server map services) VS hosted feature layers (Federated ArcGIS Server to Portal [Enterprise]) is an on-going debate amongst GIS Users.
Most of my customers have adopted an approach where they leverage both the Hosted feature services, as well as traditional map image layers - with the map image layers' data source originating from an enterprise geodatabase like SQL Server or Oracle, etc.

You can do both; however, be aware, from an architecture point-of-view, it is recommended that an ArcGIS Server designated as Hosting server should be a separate from another ArcGIS Server doing traditional map layers.

JamalNUMAN

Despite the disadvantage of feature layer service (published with relation arcgis data store) of having the edits performed in the source data not reflected directly in the service but needs overwrite publishing, the feature layer has the advantage that it behaves as if it’s a feature class and thus symbology, labeling, analysis, export, etc. are all possible

ChristopherCounsell

The behaviour of a referenced service is more or less the same for non-federated and federated ArcGIS Servers. The difference is the security model: users authenticate through Portal for ArcGIS (opposed to Server). An item is also created for the services in Portal for ArcGIS, to allow the service to be shared using the Portal security model (users, groups etc).

It's probably tied to caching. When publishing a Map service, you can choose how the map will draw from the data. From the data every time or from a cache. I would check these settings:

https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/configure-a-map-service.htm

JamalNUMAN

But if the referenced “map image” option is selected, then why do we need to re-publish the service to get the edits reflected?

With the regular “ArcGIS Server”, we don’t need to republish the data to get the edits reflected.

Why the “federated arcgis server” requires republishing the data to get the edits reflected?

Scott_Tansley

If you're using a Map Image Layer, then by default you're using referenced data. You make the changes in excatly the same way as you would in a file or enterprise geodatabase, and then republish the service to reflect the changes.

Note that you need to stop the service to make the changes.

You only make those changes via the Enterprise Portal for Hosted Feature Layers.

ChristopherCounsell

Go to the Item Details Page > Data to manage it.

Or via the REST API.

It is equivalent to ArcGIS Online. You do everything via REST API or applications (ArcGIS Pro, ArcGIS Portal) that interface with it.

JamalNUMAN

For example, I have “parcel” layer that’s published as map image layer, them how fields of the attribute table can be added, deleted, updated, etc.?

NathanEnge

The ArcGIS datastore is used only as part of a federated Portal environment. The add/update/delete capabilities on an hosted feature layer are accessed via the Portal interface or its corresponding Rest API.

Scott_Tansley

Through the Enterprise Portal, just like exporting etc. in ArcGIS Online.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.