A database client is required on all machines that connect to a database management system. The database client release must be compatible with the release of the database management system to which you are connecting.
You can obtain the following database management system client installations from the database management system vendor or download them from My Esri:
- IBM Data Server Runtime Client for Db2
- Microsoft ODBC driver for SQL Server (Windows only)
The following clients must be obtained from the database management system vendor:
- Dameng DM
- Microsoft ODBC driver for SQL Server Linux
- Oracle Database Client*
- SAP HANA ODBC driver
- Teradata ODBC driver and associated files (GSS client and ICU library)
*Oracle 11g clients are no longer supported with ArcGIS. Even if you connect to an Oracle 11g database from ArcGIS, you must use a newer Oracle client.
PostgreSQL client files are included in ArcGIS clients; therefore, you do not need to install a PostgreSQL client separately.
Follow the database management system client installation instructions to set up the client on your computer.
32- vs 64-bit clients
Some ArcGIS clients, such as ArcMap and ArcGIS Engine, are 32-bit applications. If you connect from one of these clients, you must use a 32-bit Informix, SAP HANA, Oracle, Teradata 14.x, or Dameng database management system client to connect to the database. This is true even if you install the ArcGIS client application on a computer with a 64-bit operating system and the database and server operating system are 64 bit. To connect from 64-bit ArcGIS clients (such as ArcGIS Server or ArcGIS Pro), you must install 64-bit database management system clients.
When installing the SQL Server client, use the 64-bit executable to install on a 64-bit operating system; the executable detects the type of operating system and installs the correct database management system client. If you run the 32-bit executable on a 64-bit operating system, it will fail. To connect to Microsoft Azure SQL Database or SQL Server 2014 or later releases, configure the Microsoft ODBC driver for SQL Server. For specific supported database client versions, see Microsoft SQL Server database requirements for ArcGIS.
If you install the IBM Data Server Runtime Client for Db2 or Teradata 15 client on a 64-bit operating system, run the 64-bit executable; these clients install both 32- and 64-bit files.