Supported databases

Note:

Database connections are supported in Insights in ArcGIS Enterprise and Insights desktop.

The following table lists the supported databases you can connect to when using Insights. Database connections allow you to add data from these databases to Insights.

Note:

Insights in ArcGIS Enterprise and Insights desktop allow you to create a connection to a supported Microsoft SQL Server, Oracle, SAP HANA, or PostgreSQL database that has a non-versioned enterprise geodatabase defined. If the geodatabase is versioned, the data must be unregistered as versioned to work in Insights. Currently, only geodatabase user tables not created under the sde user schema can be viewed and accessed from Insights. Insights does not work directly with file and personal geodatabases.

DatabaseInsights 2020.3Insights 2020.2Insights 2020.1Insights 3.4Insights 3.3

Microsoft SQL Server

Standard/Enterprise editions:

  • Microsoft SQL Server 2019 (64 bit)
  • Microsoft SQL Server 2019 for Linux (64 bit)
  • Microsoft SQL Server 2017 (64 bit)
  • Microsoft SQL Server 2017 for Linux (64 bit)
  • Microsoft SQL Server 2016 (64 bit)
  • Microsoft SQL Server 2014 (64 bit)

Standard/Enterprise editions:

  • Microsoft SQL Server 2017 (64 bit)
  • Microsoft SQL Server 2017 for Linux (64 bit)
  • Microsoft SQL Server 2016 (64 bit)
  • Microsoft SQL Server 2014 (64 bit)

Standard/Enterprise editions:

  • Microsoft SQL Server 2017 (64 bit)
  • Microsoft SQL Server 2017 for Linux (64 bit)
  • Microsoft SQL Server 2016 (64 bit)
  • Microsoft SQL Server 2014 (64 bit)
  • Microsoft SQL Server 2012 (64 bit)*

Express edition:

  • Microsoft SQL Server 2017 (64 bit)

Cloud database as a service:

  • Microsoft Azure SQL Database

Oracle

Standard/Standard One/Enterprise Editions:

  • Oracle 11g R2 (64 bit) 11.2.0.4
  • Oracle 12c R1 (64 bit) 12.1.0.2
  • Oracle 12c R2 (64 bit) 12.2.0.1
  • Oracle 18c (64 bit)
  • Oracle 19c (64 bit)

Standard/Standard One/Enterprise Editions:

  • Oracle 11g R2 (64 bit) 11.2.0.4
  • Oracle 12c R1 (64 bit) 12.1.0.2
  • Oracle 12c R2 (64 bit) 12.2.0.1
  • Oracle 18c (64 bit)

Note:

Oracle 11g supports read-only functionality. Other Oracle database versions support read/write functionality.

PostgreSQL

Postgres PostGIS Support:

  • PostgreSQL 11 (64 bit) with PostGIS 2.5
  • PostgreSQL 10 (64 bit) with PostGIS 2.4 or 2.5
  • PostgreSQL 9.6 (64 bit) with PostGIS 2.3, 2.4, or 2.5

PostgreSQL Geodatabase support:

  • PostgreSQL 10.6 (64 bit)
  • PostgreSQL 9.6 (64 bit)
  • PostgreSQL 9.5.12

For PostgreSQL databases without spatial extensions, only versions 9.6, 10, and 11 are supported.

Postgres PostGIS Support:

  • PostgreSQL 11.1 (64 bit) with PostGIS 2.5
  • PostgreSQL 10.6 (64 bit) with PostGIS 2.4
  • PostgreSQL 9.6 (64 bit) with PostGIS 2.3

PostgreSQL Geodatabase support:

  • PostgreSQL 10.6 (64 bit)
  • PostgreSQL 9.6 (64 bit)
  • PostgreSQL 9.5.12

SAP HANA

  • SAP HANA 1.0 SPS12
  • SAP HANA 2.0 SPS02
  • SAP HANA 2.0 SPS03
  • SAP HANA 2.0 SPS04
  • SAP HANA 1.0 SPS12
  • SAP HANA 2.0 SPS02
  • SAP HANA 2.0 SPS03
Note:

SAP HANA Modeling Views are not supported.

Additional database platforms

The ArcGIS platform supports many database management systems to which Insights does not support direct access. To use tables from these databases, including geodatabase-enabled databases, they must first be made available in your ArcGIS Enterprise portal as a feature layer.

Note:

The list of database management systems with which Insights can work directly will grow over time. Contact Esri Technical Support to provide feedback on your preferred vendor.

Resources

For more information about databases, see the following: