Skip To Content

Supported data

The following data sources are supported in Insights:

  • Available hosted or registered feature layers from your content, groups, or organization
  • Feature layers from ArcGIS Living Atlas of the World
  • Excel files (.xlsx)
  • Comma-separated value files (.csv)
  • Shapefiles (.zip)
  • Map image layers
  • Connections to Microsoft SQL Server, SAP HANA, PostgreSQL, and Oracle databases. The following data types are supported:
    • Spatial tables
    • Nonspatial tables
    • Relational database views
  • Connections to enterprise geodatabases

Note:

Map image layers require that the Feature Access capability be enabled to support statistics. If statistics are not supported, you cannot use many Insights features, including creating charts. See Troubleshoot a map image layer for tips on how to enure that statistics are supported when you publish a map image layer. For more information, see Set map service properties and Editor permissions for feature services.

Map image layers must also have standardized query enabled. To enable standardized query, the layer must be shared as a dynamic service, rather than a tile layer.

For Insights Enterprise users, data from a spatiotemporal big data store can be added from your portal as a feature layer. A common way to create data in the spatiotemporal big data store is using GeoAnalytics Server in Portal for ArcGIS or ArcGIS Pro.

Insights does not support the following:

  • Multipoint geometries
  • Feature layers from ArcGIS Online with a definition query or feature layers that use an ArcGIS Arcade expression
  • Query layers

Insights Online does not support consuming on-premises feature services that are not Internet accessible.

Support for the spatiotemporal big data store

The following tools and capabilities are supported in Insights for feature layers with data stored in the spatiotemporal big data store:

The following tools are supported with limitations in Insights for feature layers with data stored in the spatiotemporal big data store:

*Does not support styling by a number field using Counts and Amounts (Size) and Counts and Amounts (Colors).

**Does not support more than one subgroup for a statistic. An error is returned when the Subgroup option is used in a bar chart. Chord diagrams, data clocks, and heat charts are not supported for data from the spatiotemporal big data store.

Resources

Use the following resources to learn more about data in Insights: