Data connections are created in the Qlik Sense data load editor or when you use the Add data option. The user who created a data connection automatically becomes the owner of that connection and is by default the only user who can access the data connection.
You can edit data connections that you have update rights to. Do the following:
-
Open the QMC: https://<QPS server name>/qmc
-
Select Data connections on the QMC start page or from the Start
drop-down menu to display the overview. -
Select the data connections that you want to edit.
Information noteIf you select several data connections, you cannot view, edit or add security rules. - Click Edit in the action bar.
-
Edit the properties.
You can display or hide property groups using the panel to the far right.Identification
Identification properties Property Description Name The name of the data connection. Owner The user name of the owner of the data connection. Connection string The connection string for the data connection. Typically, includes the name of the data source, drivers, and path. Type The type of data connection. Standard data connections include ODBC, OLEDB, and Folder. User ID The user ID that is used in the connection string. Password The password associated with the user ID used in the connection string.
Information noteThe password is saved encrypted.Tags
Tags properties Property Description Tags Tip noteIf no tags are available, this property group is empty.Connected tags are displayed under the text box.
Custom properties
Information noteIf no custom properties are available, this property group is not displayed at all (or displayed but empty) and you must make a custom property available for this resource type before it will be displayed here.Click Apply to save your changes. If a mandatory field is empty, Apply is disabled. -
Click Apply in the action bar.
Successfully updated data connection properties is displayed at the bottom of the page.