Database and data warehouse clients

Database client software allows you to communicate between a client application and the database or data warehouse. Install a database client on all ArcGIS client machines when connecting to the following:

Database or data warehouseDatabase client

Amazon Redshift

Amazon Redshift ODBC driver

Amazon Relational Database Service (RDS) for Oracle

Oracle Database Client

Amazon RDS for SQL Server

Microsoft ODBC driver for SQL Server

Autonomous Transaction Processing database in Oracle Cloud

Oracle Database Client

Dameng

Dameng DM

Google BigQuery

Magnitude Simba ODBC driver

Google Cloud SQL for SQL Server

Microsoft ODBC driver for SQL Server

IBM Db2

IBM Data Server Runtime Client for Db2

Microsoft Azure SQL Database

Microsoft ODBC driver for SQL Server

Microsoft Azure SQL Managed Instance

Microsoft ODBC driver for SQL Server

Microsoft SQL Server

Microsoft ODBC driver for SQL Server

Oracle

Oracle Database Client

Oracle Co-managed Systems Virtual Machine DB Systems

Oracle Database Client

SAP HANA

SAP HANA client

SAP HANA Cloud

SAP HANA client

Snowflake

Snowflake ODBC driver

Teradata Data Warehouse Appliance

Teradata ODBC driver and associated files (GSS client and ICU library)

Obtain the database client from the database or data warehouse vendor and follow their client installation instructions to set up the client on your computer. IBM Data Server Runtime Client for Db2 and the Windows version of the Microsoft ODBC driver for SQL Server are also available on My Esri.

For information on supported database client versions for the ArcGIS release you're using, see the ArcGIS system requirements for the database to which you need to connect.

To connect from 64-bit ArcGIS clients (such as ArcGIS Server or ArcGIS Pro), you must install 64-bit database clients.

Caveats

Note the following in regard to database clients and ArcGIS:

  • No database client is required to connect to SQLite or a GeoPackage.
  • ArcGIS clients include the files you need to connect to PostgreSQL, so you don't need to install a PostgreSQL client.
  • ArcGIS no longer supports Oracle 11g clients. Even if you connect to an Oracle 11g database from ArcGIS, you must use a newer Oracle client.


In this topic
  1. Caveats