topic Re: Can services using query layers be used in Insights? in ArcGIS Insights Questions

Can services using query layers be used in Insights?

LSaunders — Fri, 07 Apr 2017 19:43:19 GMT

I use query layers to create many web services so that my data is updating. I want to use these in Insights as data feeds, but it doesn't seem to work for me.

When publishing the query layer, it creates a map service. I add the feature service url to my Portal content after this as a separate item so that Insights can see it as a feature service.

When I add it to a map on a card, the symbology shows, but the actual points don't show.

Has anyone successfully used a feature service that is using a query layer?

Re: Can services using query layers be used in Insights?

AravindStoryMaps — Tue, 11 Apr 2017 21:57:11 GMT

Hi Leah,

Is the Query Layer coming from a non-geodatabase or an enterprise geodatabase?

Additionally,

When publishing the query layer, it creates a map service. I add the feature service url to my Portal content after this as a separate item so that Insights can see it as a feature service.

When you publish the query layer with feature access, it should add two items to your Portal if the ArcGIS Server is federated: Map Image Layer and a Feature Layer. So, you can use the item called "Feature Layer" to add this to the Insights workbook.

I published a view from my non-geodatabase to ArcGIS Server as a feature service. I can see the points rendered in the "Map" card.

Thanks,

Aravind

Re: Can services using query layers be used in Insights?

LSaunders — Tue, 11 Apr 2017 22:25:57 GMT

The query layer is pulling data from a non-spatial Oracle db. I did add the feature service to my Portal as content then tried to add it to a card, but the points don't show.

All of our data is projected to a local coordinate system and we store the st. We use these services in most of our web maps.

I can't publish with feature access, this fails during publishing as the data is from a read only query layer.

Sent from my Verizon, Samsung Galaxy smartphone

Re: Can services using query layers be used in Insights?

LSaunders — Thu, 13 Apr 2017 20:58:53 GMT

I can't publish the query layer with feature access due to the nature of the query as I get errors about complex queries and virtual fields.

Re: Can services using query layers be used in Insights?

AravindStoryMaps — Thu, 13 Apr 2017 23:02:07 GMT

Hi Leah,

it looks like the behavior is a defect:

BUG-000103325 : When adding a service to a map in Insights for ArcGIS where the data source for the service is from an Oracle database, the data will not be visible on the map, but attributes can be viewed.

Thanks,

Aravind

Re: Can services using query layers be used in Insights?

LSaunders — Fri, 14 Apr 2017 01:26:00 GMT

Thanks for finding that!

No information about when it might be fixed though?

This renders Insights useless for us unfortunately.

Leah

Sent from my Verizon, Samsung Galaxy smartphone

Re: Can services using query layers be used in Insights?

NathanSmith8 — Mon, 29 Jan 2018 18:26:02 GMT

Hi Leah,

Quick FYI for you - The above bug has been fixed as of Insights v2.0.

Thanks,

Nathan