Problem: Performance issue with Insights on ArcGIS Enterprise if the dataset contains a large amount of data and is being pulled from a SAP HANA Database
Insights for ArcGIS is unable to load two-dimensional points (ST_Point) using a round-earth coordinate system from a SAP HANA database when the table contains a large amount of data, for example, 25 million rows. The operation times out before the dataset loads completely.
This is caused by an SAP HANA performance issue when calculating extents in a round-earth coordinate system for two-dimensional points (ST_Point). Insights for ArcGIS calculates the extent of the data before it can be loaded.
Solution or Workaround
Currently there is no workaround. Esri recommends contacting an SAP representative to find a solution. Please refer to SAP internal bug: 194295.