I'm not sure this is possible, and the ESRI documentation is a bit of a mess it seems. Or maybe it's not possible at all and the ESRI documentation is giving me the nearest it can.
Basically, the organisation I work for has a fair bit of data on an SQL Server - both spatial and non-spatial.
We want to link this to ArcGIS Online / Collector, so that a user can log in and see the latest data and have it updated. Bonus points if they can make updates back.
I believe this will require ArcGIS Server, and there seem to be a whole myriad of options. I've been told that it doesn't, but not sure whether to believe it. Also, we'll be trialing ArcGIS Server shortly, in order to make our SQL Server database into a geodatabase (this is the approach ESRI themselves have said to use).
If we do that, even once the trial expires, would we be able to have ArcGIS Online look at that?
As near as I can understand it, we need to set up an ArcGIS Server web service.
Would we still be able to use this once the trial expires?
We've currently got a standard editor licence.