Skip To Content

Required vendor files

Note:

Vendor files must be downloaded and registered to create database connections in Insights Enterprise. The Insights Local installation includes the necessary JDBC drivers, so no vendor files are needed to create database connections in Insights Local.

The following table lists the required vendor files for each database type:

Supported databaseRequired vendor files

Microsoft SQL Server

Microsoft JDBC Driver for SQL Server:

  • mssql-jdbc-6.2.2.jre8.jar

Oracle

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

PostgreSQL JDBC driver is included in ArcGIS Data Store.

SAP HANA

SAP HANA JDBC driver:

  • ngdbc.jar

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 to download files.

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