Update a database connection

Insights in ArcGIS Enterprise
Insights desktop

Database connections are supported in Insights in ArcGIS Enterprise and Insights desktop.

You cannot edit database properties through Insights. If you need to change the properties of your database, you must do so within the database itself, then update the connection properties in Insights.

A database connection will be broken if the database properties, such as the database name or port number, are changed. You can restore the connection by editing the connection properties.

All connection properties can be updated, except Type. For example, changing to SAP HANA from Microsoft SQL Server is not supported. For a complete list of connection properties, see Create a database connection.

If you attempt to add data from a database with a broken connection, the message Something went wrong. Check to see if the connection properties need to be updated will appear. The connection properties may need to be updated, or there may be other reasons that the connection is failing. For more information, see Troubleshoot a database connection.

Edit connection properties

Complete the following steps to edit a database connection:

  1. If a workbook is open in Insights, save your work and click the Home button Home to return to the home page. If you are signing in to Insights you will be brought to the home page automatically.
  2. Click the Connections tab Connections.
  3. Click the name of the database connection you want to edit. You can only edit database connections that you created. Users with Administrator privileges can update database connections created by other members of the organization.

    The Edit connection window opens.

  4. Update the connection details. All details can be changed except Type.
  5. Enter the password for the database, if it was not already updated. The password must be entered before the edits can be saved.
  6. Click Save.

See also

See the following topics to learn more about database connections: