Required vendor files

Insights in ArcGIS Enterprise
Insights desktop

Vendor files are used to add database connectors for relational databases. Once a connector is added, database connections can be created and database tables can be accessed directly in Insights.

Note:

The Insights desktop installation includes the necessary JDBC drivers for Microsoft SQL Server, Oracle, PostgreSQL, and SAP HANA. Vendor files are not required when adding connectors for those databases in Insights desktop.

The PostgreSQL JDBC driver is included in ArcGIS Server. A vendor file is not required when adding a connector for PostgreSQL in Insights in ArcGIS Enterprise.

Supported databases

The following table lists the vendor files for each database type and the latest version that was certified with Insights:

Supported databaseRequired vendor files

Microsoft SQL Server

Microsoft JDBC Driver for SQL Server:

  • mssql-jdbc-9.2.1.jre11.jar

Oracle

The following three JAR files are required to register Oracle:

  • Oracle JDBC driver: ojdbc8-19.3.0.0.0.jar
  • Oracle Spatial and Graph (Spatial Java Class API):
    • sdoapi-19.3.0.0.0.jar
    • sdoutl-19.3.0.0.0.jar
Note:

You should use the latest version of the Oracle JDBC driver that is compatible with the Java Runtime Environment (JRE) used by ArcGIS Server.

PostgreSQL

PostgreSQL JDBC driver is included in ArcGIS Server.

SAP HANA

SAP HANA JDBC driver:

  • ngdbc-2.8.11.jar

Snowflake

Snowflake JDBC driver:

  • snowflake-jdbc-3.12.17.jar
Google BigQuery

Simba JDBC Driver for Google BigQuery:

  • SimbaBigQueryJDBC42_1.2.21.1025.zip
Note:

The Google BigQuery JDBC package includes mulitple files. All files in the package are required to add a BigQuery connector.

The required vendor files (for example, JDBC driver) must be provided to register relational data store types with ArcGIS Server. The following table provides tips on how to get these files. For more information, refer to the help documentation for the database type or contact your database account manager.

VendorInstructions

Microsoft SQL Server

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

Oracle

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

PostgreSQL

PostgreSQL JDBC driver is included in ArcGIS Server.

SAP HANA

The latest JDBC driver can be downloaded from SAP Support Portal.

Snowflake

The latest JDBC driver can be downloaded from Maven Central Repository.

Google BigQuery

The latest JDBC driver can be downloaded from Magnitude Simba.

Note:

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

Other databases

Connectors can be added for relational databases that use JDBC drivers that aren't on the list of supported database for Insights. For information about vendor files for connectors that have been tested in Insights, or to request help adding a connector, see the Insights connector guide.

Next steps

Now that you have the required vendor files, the next step is to add connector types. For more information, see Manage connector types.