As the owner of a user-managed data store item or as an organization administrator, you can manage data store settings and details to help organization members discover and use the data store. This includes updating the overview information for the item, sharing the data store, changing the item's status, enabling delete protection on the item, and defining the spatial extent to which the data in the data store applies.
You can also change which servers have access to the data store or delete a data store item if you no longer need it.
If the data store item accesses a relational database or enterprise geodatabase, the password used to access the database will likely change periodically. When the password changes, you must update it for the data store item. If the database data store item accesses a NoSQL database, you must update the password for the data store item when the password changes in the NoSQL database.
Similarly, the password or secret key used to access a cloud storage location may change. If it does, you must update this information for the cloud storage data store item.
Add or remove a server
After you create the data store item, you can allow more federated ArcGIS Server sites to access the data store. For example, if your administrator federates additional GIS Server or ArcGIS Image Server sites with the portal, you can add the data store to the new sites so you can publish data from the data store to those sites.
You cannot add another federated server to a NoSQL data store item.
If a site should no longer have access to the data store, remove the server from the data store. For example, you may have registered a database data store with four ArcGIS Server sites when you added the data store item, but you didn't realize one of the sites was not an ArcGIS GIS Server site. You can remove the data store from the erroneous site, which unregisters the database connection from this site.
Note:
You can only remove an ArcGIS Server site from the data store if there are no bulk-published services running on the site. For all other web layers, removing the ArcGIS Server site breaks the connection between the service and the data, which can cause problems later.
Only one federated server—the portal's ArcGIS Knowledge Server site—is allowed for a NoSQL data store. You can remove the Knowledge Server site from the NoSQL data store if you intend to delete the NoSQL data store item.
To add an ArcGIS Server site to or remove a site from a data store item, complete the following steps:
- Sign in to the portal and open the item page for the data store item.
- Click the Settings tab.
- Scroll down to the Servers section and click Edit Servers.
You may need to wait until the ArcGIS Server site statuses are verified before you can edit the list.
- Check or uncheck the box next to each federated server to change the site's access to the data store item.
- Click Save to apply the changes.
Delete a data store
In rare instances, you may decide you no longer want a particular data store item. For example, you may have registered a data store to publish layers for a short-term project. When the project ends, you delete the layers and the data store item.
Deleting the data store item does not delete the data or the data source location. However, because dependencies exist between the data store item and the services and layers you publish from it, you must delete all web layers published from the data store and remove all servers from the data store before you delete the data store item.
To delete the data store item, complete the following steps:
- For database data stores, you must delete all bulk-published web layers that reference data in the data store item.
- Delete other web layers that reference data in the data store.
- Remove all servers from the data store.
- Delete the data store item from the organization.
Update a database password
In most organizations, passwords must be reset on a regular basis to maintain security. When the password changes for the account that the data store item uses to access a relational database, you must update the password for the data store item. Updated passwords are sent to every server that you added to the data store item.
Note:
This workflow does not apply to database data store items that access NoSQL databases. To update the password for a NoSQL database, see Update information for NoSQL database data stores below.
If the database data store item accesses Snowflake, you can update the connection file to use key-pair authentication in place of user authentication, but the username must be the same.
To replace the password for a database data store item that accesses a relational database or cloud data warehouse, complete the following steps:
- Start ArcGIS Pro and open the database connection properties of the database connection file (.sde) you used to create the data store item.
- Update the password in the database connection file and save the change.
If the connection is to a cloud data warehouse, you can update the key file, token, access key, or key-pair file provided that the username is the same.
For a connection to Snowflake, you can change to using key-pair authentication if the username is the same. Provide the key-pair file and, if required, the pass code for the file.
- Sign in to the portal from a machine that has access to the .sde file you altered in the previous steps.
- Open the item page for the data store item and click the Settings tab.
- Scroll down to the Database section and click Update Password.
- Click Import a connection file with an updated password for the connection you need to update.
- Choose the .sde file you updated in steps 1 and 2 and click Validate to confirm the servers can access the data store.
- Click Save to apply the changes.
Update information for cloud storage data store items
When you create a cloud storage data store item, ArcGIS authenticates your connection using the credentials you provide (such as an IAM role or access keys). It cannot confirm that the cloud storage location exists in the location you specify. Therefore, it is possible to create a cloud storage data store item and mistype the bucket name or mistakenly choose the wrong region. When you attempt to publish an imagery layer from the data store, you'll receive a message that indicates the data store is inaccessible. To correct this, you can update the connection information for the cloud storage data store item.
You cannot change cloud providers, but you can change the other settings. Only change the other settings, though, to correct a problem or update credentials. If you change the settings to another location for a cloud storage data store from which you already published layers—for example, you specify a different Blob storage location—and the data is not in that other location, your layer may stop functioning.
Note that you can also update information for folder data stores. However, similar to changing the location for a cloud storage data store item, if you change the file path for a folder data store item and the data used by existing layers is not there, you may encounter problems with the existing layers.
To correct information for a cloud storage data store item, complete the following steps:
- Sign in to the portal as the data store item owner.
- Open the item page for the cloud storage data store item and click the Settings tab.
- Scroll down to the Data Store (cloud) section and click Update Password.
You can edit the following for cloud storage data stores:
- Amazon Web Services, Alibaba, and Google Cloud—You can edit the access key, secret key, region, bucket name, and folder.
- Microsoft Azure—You can edit the account name, account key, environment, container name, and folder.
If you already published imagery services from this cloud storage data store and change the storage location (such as the region, environment, container namer, or folder), you must ensure the same image files are in the new location. If they are not, the imagery services will no longer function.
- Click Validate to confirm the federated servers can access the data store.
- Click Save to apply the changes.
Update information for NoSQL database data stores
In most organizations, passwords must be reset on a regular basis to maintain security. When the password changes for the account that the data store item uses to access Neo4j or ArangoDB, you can update the password for the NoSQL database data store item.
If server addresses change in the Neo4j cluster, you can update the URI and fallback server information. This must be the same Neo4j cluster—you cannot use this option to connect to a different cluster.
To change information for a NoSQL database data store item, complete the following steps:
- Sign in to the portal as the data store item owner.
- Open the item page for the NoSQL data store item and click the Settings tab.
- Scroll down to the Data Store (NoSQL) section and click Update Password.
You can edit the following for NoSQL database data stores:
- Connection URI—Provide an updated string.
- Fallback Servers—Update the list of fallback servers.
- Password—Type the new password associated with the connecting user.
- Click Validate to confirm the Knowledge Server can access the data store.
- Click Save to apply the changes.