In ArcGIS Pro, charts are optimized to use server-side processing for data from an enterprise database or cloud data warehouse. This capability is faster than client-side processing when running the calculations and aggregations that are used to build a chart. When you create a bar chart, line chart, scatter plot, or histogram using a data source from one of the supported databases, the chart automatically processes the data using a database query. The following databases are supported:
- SQL Server
- PostgreSQL
- BigQuery
- SAP HANA
- Amazon Redshift
- Snowflake
Supported chart types
The following chart types have been optimized to use server-side processing for the supported enterprise databases and cloud data warehouses:
- Bar
chart
Note:
Bar charts must be aggregated to leverage server-side processing.
- Line
chart
Note:
Line charts must use a date field for the Date or Number parameter to leverage server-side processing.
Note:
Line charts will not leverage server-side processing if a numeric field is used.
- Scatter plot
Note:
Only scatter plots that display more than 10,000 points will leverage server-side processing.
- Histogram
Limitations
Charts that use a data source from one of the supported enterprise databases or cloud data warehouses have the following limitations:
- The Selection and Filter by Selection options are not available.
- Color matching is not supported.
- The skewness and kurtosis statistics are not calculated for histograms.
- Feature services are not supported.