Skip To Content

Databases, data warehouses, and ArcGIS Enterprise

ArcGIS allows you to access data in your database or cloud data warehouse through web services. How you interact with the database depends on your role in your organization:

Database administrators

Database administrators configure and maintain the database or data warehouse and ensure users can access the database or data warehouse from ArcGIS.

To allow ArcGIS users to access the data they need, you must do the following:

Publishers

Publishers make data available through web services. To make the data in your business's database or cloud data warehouse available to others through a map service, author a map in ArcGIS Pro that contains the data and publish. If you're using database data and want others to edit it, you can publish a feature service that references the data in your database.

  1. As a publisher, register a database connection with the ArcGIS Server site.
  2. Create a map in ArcGIS Pro that includes the data you want to publish.

    To provide read-only access to the data, publish a map service. To allow people to edit database data through a service, publish a feature service.

    For recommendations on authoring a map to publish a map service (map image layer) from ArcGIS Pro, see Author a multiscale map. For recommendations on authoring a map to publish a feature service, see Author maps to publish feature services.

  3. Configure ArcGIS Pro to publish to the correct ArcGIS Server site.
    • When publishing from ArcGIS Pro to a federated ArcGIS Server site, sign in to the ArcGIS Enterprise portal with which the ArcGIS Server site is federated, and set the portal as the active portal.
    • When publishing from ArcGIS Pro to a stand-alone ArcGIS Server site, add the site as a GIS server. Connect to the site with an account that has publishing privileges. This is not supported for data in a cloud data warehouse.
  4. Publish the data from the map. If you publish a feature service, choose what editing operations you want to allow through the feature service.

    See the help page for the type of service and the client you're using.

If the ArcGIS Server site is federated with an ArcGIS Enterprise portal, a map service is created on the ArcGIS Server site and a map image layer item is added to the portal organization. For feature layers, a feature service is created on the ArcGIS Server site and a feature layer item is added to the portal organization.

You can sign in to your organization and update the details associated with these items. You can also share the layer if you did not do so when you published.

If your ArcGIS GIS Server sites are federated with an ArcGIS Enterprise portal, you can add a database connection to the portal as a data store item. If the database connection accesses a database or enterprise geodatabase, you can register the database connection with multiple federated GIS Server sites at once, and you can publish all the feature classes and tables to which you have access using default extents and symbology. If the database connection accesses a cloud data warehouse, you can register the database connection with the hosting server only. All publishing for data stores that access cloud data warehouses takes place from ArcGIS Pro.

You cannot publish image services from a cloud data warehouse or database, but if the database contains a geodatabase, you can publish imagery data as an image service. However, although you can store raster data in a geodatabase, it is not the recommended storage method. You cannot publish imagery from a database data store item in the portal. For information about publishing an imagery layer from ArcGIS Pro, see Share a web imagery layer.

Editors and viewers

Editors maintain data through feature services and viewers consume web services in maps and apps. The easiest way for you to access the services that publishers make available to you is through the ArcGIS Enterprise portal. If the data was published to a federated server, a layer item already exists in the organization for that service. If the data was published to a stand-alone ArcGIS Server site, you can add the service as an item to your organization. From there, you can create maps to view the data. You can then use the maps in apps that provide the tools you and others in your organization need to interact with the data.

If the feature layer owner enabled editing and you have privileges to edit, you can edit the feature layer data in a portal map viewer, ArcGIS apps, configurable apps that organization members create with ArcGIS Configurable Apps templates, ArcGIS Web AppBuilder, or ArcGIS Experience Builder, and custom apps developers create for you.