Configure a database connection for ArcGIS Server

The sections below summarize using a supported database or cloud data warehouse with an ArcGIS Server site.

Configure clients and create a database connection file

The following topics provide instructions on how to install and configure client software and create a database connection file. 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.

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

Test the connection

To test a connection to a database or enterprise geodatabase, publish a service using data residing in the database.

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.