Data connections enable you to select and load data from a data source. All data connections are managed centrally from the QMC. Data connections are created in the Qlik Sense data load editor. The user who creates a data connection automatically becomes the owner of that connection and is, by default, the only user who can access the data connection. The data connection can be shared with others through security rules defined in the QMC.
When you import an app developed on Qlik Sense Desktop, existing data connections are imported to the QMC. When you export an app from a server, existing data connections are not exported with the app.
The Data connections overview lists all the available data connections.
By default, the QMC contains two data connections: ArchivedLogsFolder and ServerLogFolder. These are the data connections for the two monitoring apps, License Monitor and Operations Monitor, which are installed together with the QMC. For users with admin roles (root, security, content, and deployment), the data connections are available in the data load editor in the Qlik Sense hub.
The following table presents the available fields and buttons. By default, only some of the fields are displayed. You can use the column selector () to add fields.
|Name||The name of the data connection.|
|Owner||The owner of the data connection.|
|Tags||The tags that are connected to the data connection.|
The connection string for the data connection. Typically, includes the name of the data source, drivers, and path.
The type of data connection. Standard data connections include ODBC, OLEDB, and Folder.
The user ID that is used in the connection string.
|ID||The ID of the data connection. By default, not displayed.|
The date and time when the data connection was created.
The date and time when the data connection was last modified.
By whom the data connection was modified.
Custom properties, if any, are listed here.
Sort the list ascending or descending. Some columns do not support sorting.
Type a string to filter on, or, when available, select a predefined value. All rows that match your filter criteria are displayed. You can filter on multiple columns simultaneously to narrow your search. If a filter is applied to a column, is displayed.
To remove your criteria, click Actions in the table header bar and select Clear filters and search.
You can combine filtering with searching.
Options for clearing filter and search, selecting and deselecting all rows, and toggling wrapping.
Note: The option Select all rows is applied to the rows that are currently displayed. Any rows that have been filtered out before selecting all rows are disregarded, even if they were selected. The option Deselect all rows is applied to all rows, including those that were filtered out.
|Column selector: Select which columns to display in the overview. Click to reset to the default columns.|
Search – both basic and more advanced searches.
Refresh the page.
|Edit||Edit the selected data connections.|
|Delete||Delete the selected data connections.|
|Show more||The overview shows a set number of items, by default. To show more items, scroll to the end of the list and click Show more. Searching, sorting, and filtering of items is always done on the full database list of items, not only the items that are displayed.|