Skip To Content

Supported databases

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

Note:

Insights for ArcGIS allows you to create a connection to a supported Microsoft SQL Server, Oracle, SAP HANA, or PostgreSQL database that has an enterprise geodatabase defined. 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.

Supported databaseDescriptionRequired vendor files

Microsoft SQL Server

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

Microsoft JDBC Driver for SQL Server:

  • sqljdbc42.jar

Note:

The JRE8 version of the JDBC driver should be used for Microsoft SQL Server databases.

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)

Note:

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

Oracle JDBC driver:

  • ojdbc7.jar or ojdbc8.jar

Note:

You should use the latest version of the Oracle JDBC driver that is compatible with your Java Database Kit (JDK).

Oracle Spatial and Graph (Spatial Java Class API):

  • sdoapi.jar
  • sdoutl.jar

PostgreSQL

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

PostgreSQL JDBC driver is included in ArcGIS Data Store.

SAP HANA

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

SAP HANA Modeling Views are not supported.

SAP HANA JDBC driver:

  • ngdbc.jar

* Not supported for Insights 3.2 or later.

The required vendor files (for example, JDBC driver) must be provided to register relational data store types with ArcGIS Server. The following are some tips on how to get these files:

VendorInstructions

Microsoft SQL Server

The latest JDBC driver can be directly downloaded from the Microsoft Download Center.

Oracle

The latest JDBC driver can be downloaded from the Oracle Technology Network.

The latest Oracle Spatial and Graph software option can be downloaded from the Oracle Technology Network.

PostgreSQL

PostgreSQL JDBC driver is included in ArcGIS Data Store. For more information, see What is ArcGIS Data Store.

SAP HANA

The JDBC driver should be part of the SAP HANA client installation. Visit the SAP Store for more details.

Note:

Some vendors may require you to have a customer account in order to download files.

Once you have the required vendor files, you need to register each database as a relational data store type. See Configure the portal to support Insights for ArcGIS for the steps to register a relational data store type.

For more information about supported data and databases, see the following: