Skip to main content

Editing data connections

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:

  1. Open the QMC: https://<QPS server name>/qmc

  2. Select Data connections on the QMC start page or from the StartArrow down drop-down menu to display the overview.

  3. Select the data connections that you want to edit.

    Note: If you select several data connections, you cannot view, edit or add security rules.
  4. Click Edit in the action bar.
  5. 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.

    Note: The password is saved encrypted.

    Tags

    Tags properties
    Property Description
    Tags
    Tip: If no tags are available, this property group is empty.

    Connected tags are displayed under the text box.

    Custom properties

    Note: If 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.
  6. Click Apply in the action bar.

Successfully updated data connection properties is displayed at the bottom of the page.