To connect an ArcGIS Server site to a supported database platform, you need to do the following:
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 Dameng from ArcGIS
- Connect to Db2 from ArcGIS
- Connect to Informix from ArcGIS
- Connect to Netezza from ArcGIS
- Connect to Oracle from ArcGIS
- Connect to SAP HANA from ArcGIS
- Connect to SQL Server from ArcGIS
- Connect to Teradata from ArcGIS
No separate database client is needed to connect to PostgreSQL.
Note:
Use of Altibase with ArcGIS is deprecated.
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
You should test the connection by doing the following*:
- Register the database with the ArcGIS Server site.
- Publish a service using data residing in the database.
* For Informix and Db2 z/OS databases, create a service definition file that does not contain the service data, and publish the service definition file to test the connection.
If you encounter problems with your connection, consult the server logs for more information. To learn more about server logging, see Viewing, querying, and configuring server logs.