Is it possible to share a non-spatial stand-alone table that is not related to any feature? I can publish the service with the table as long as there is a feature in the mxd, but just the table looks like is not possible (share as option is grey out). The idea is to later use the data in a operational dashboard, but is not identified as external data, just the feature layers. In other words, is it possible to use a stand alone table (no relations or joins) in the dashboard? I'm using 10.2.
Untested, but looking here Data sources in the operation view—Operations Dashboard for ArcGIS | ArcGIS it should be fairly easy to add a stand alone table. Here's an excerpt from the link: You can add a stand-alone table by entering the URL to the particular table, for example http://sampleserver5.arcgisonline.com/arcgis/rest/services/ServiceRequest/MapServer/1.
I did test the workflow suggested in my link above. It is easy to publish standalone tables to be used in an operations dashboard.
1. Add the tables to ArcMap along with a feature class. I wasn't able to publish just the tables without the feature class. I think there are other discussion out there about this issue. But once the feature class was added to the map then the "Share as service" option was active.
2. Publish the service
3. Access the REST directory and make note of the url for the tables
4. Share the content on AGOL
5. Open a new or existing operation view
6. Add an external data source and browse to the table shared in step 4
7. Configure widgets using new data source
If you have issues with this please post back so we can learn together.
Thanks Brandon. I'll give it a try when possible and let you know how it goes. Looks like it will work with tables registered with ArcGIS, but will it work with tables from another databases that are not registered? Thanks again...
That is an excellent question. I haven't been able to find a definitive answer but it seems like it should be possible. Looking forward to hearing your experiences.
I am not sure what the "register" here means,Does it mean register as versioned in GDB? if this is the case, you don't need to register, the only requirement is to publish the table to AGOL. and make it accessible through a web service. I haven't tried accessing web services outside of AGOL or ArcGIS Server, it will be another interesting topic.
It's been a little while but I think the "register" refers to having the database registered with ArcGIS server rather than copying the data to the server. I would think that both methods work but haven't tested anything besides registering the data with the server.
I agree, it should not matter whether the database is registered to server or not. because OD is the service consumer, form its perspective, it makes no difference to the services it consumes.