Feature Layer/Registered Reference vs Hosted Feature Layer

Anonymous User

We have data that is tied to a SQL server, in order for it to update, and theoretically be almost real time data, in the ESRI Enterprise, I need to publish it as reference registered data. 

I found when doing this there is no editing capability because it is a feature layer. There I cannot add columns to the data. I found that in order for me to be able to add columns it must be a hosted feature layer, then I can edit.

I can publish it as copy all data, and then it is a hosted feature layer and I can edit it, but it won't update automatically. 

So my question is, is there a way to be able to edit the data and still have it update automatically?

Thank you very much,
Annette

jcarlson

Oh, that's true, you can't add columns from the Portal interface, you'd have to do it from something that has direct access to the database, then republish. You just can't modify it in-place in Portal.

If you make it into a hosted feature layer, you'll just need some kind of scripted process to keep the hosted layer up to date with the original source. We do have a few layers like that, and a basic Python script to update the hosted layer takes less than a minute to run, so we can keep our layer as up to date as we want.