Install and configure the database client software

The following topics provide instructions on how to install and configure client software for specific databases. Keep in mind that you must install a release of the client software that is compatible with the release of the database to which you want to connect.

Follow the instructions in these topics to set up database client software on the ArcGIS Server machine:

• Connect to Amazon Redshift from ArcGIS
• Connect to Dameng from ArcGIS
• Connect to Db2 from ArcGIS
• Connect to Google BigQuery from ArcGIS
• Connect to Informix from ArcGIS
• Connect to Oracle from ArcGIS
• Connect to SAP HANA from ArcGIS
• Connect to Snowflake from ArcGIS
• Connect to SQL Server from ArcGIS
• Connect to Teradata from ArcGIS

No separate database client is needed to connect to PostgreSQL.

Restart ArcGIS Server

If ArcGIS Server was running before you configured an Oracle database client on each ArcGIS Server machine, you must restart ArcGIS Server. You can restart ArcGIS Server from the Windows Services interface on each machine in your site.

Test your connection

To test a connection to a database, do the following*:

1. Register the database with the ArcGIS Server site.
2. Publish a service using data residing in the database.

* For Informix and Db2 on z/OS databases, use ArcMap 10.8.x to create a service definition file that does not contain the service data, and publish the service definition file to test the connection. After 10.9.1, you cannot publish services tht contain data from Informix or Db2 on z/OS.

To test a connection to a cloud data warehouse, do the following:

1. Add a data store item that registers the database connection file with the hosting server.
2. Define a query layer for a table in the cloud data warehouse.
3. Publish a service from the query layer.

If you encounter problems with your connection, consult the server logs for more information. To learn more about server logging, see Work with server logs.