Database connections are supported in Insights Enterprise and Insights Local.
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.
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.
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.
Depending on the database you are connecting to, you can update the following properties for the connection:
- Spatial type
- User name
- Server name
- Database name
- Instance name
- Port number
You can't change the type of database in a connection. For example, changing to SAP HANA from Microsoft SQL Server is not supported.
Edit connection properties
Use the following steps to edit a database connection:
- If a workbook is open in Insights, save your work and click the Home button to return to the home page. If you are signing in to Insights you will be brought to the home page automatically.
- Click the Connections tab .
- 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.
- Update the connection details. All details can be changed except Type.
- Enter the password for the database, if it was not already updated. The password must be entered before the edits can be saved.
- Click Save.
See the following topics to learn more about database connections: