Support for enterprise databases and cloud data warehouses

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.