Skip to main content Skip to complementary content

Data connections

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.

Information noteIf the name of a data connection in the imported app is the same as the name of an existing data connection, the data connection will not be imported. This means that the imported app will use the existing data connection with an identical name, not the data connection in the imported app.
Tip noteTo give access to the data connection to other users than the owner, edit the connection or go the Security rules page.

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.

Information noteIf the Data connections overview contains a connection called DM, that connection is for Qlik DataMarket internal use.

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.

Tip noteYou can adjust the column width by dragging the header border.
Name The name of the data connection.
Owner The owner of the data connection.
Tags The tags that are connected to 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.

ID The ID of the data connection. By default, not displayed.
Created

The date and time when the data connection was created.

Last modified

The date and time when the data connection was last modified.

Modified by

By whom the data connection was modified.

<Custom properties>

Custom properties, if any, are listed here.

SR

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.

See: Searching and filtering in the QMC

Actions

Options for clearing filter and search, selecting and deselecting all rows, and toggling wrapping.

Information noteThe 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 B to reset to the default columns.
F

Search – both basic and more advanced searches.

See: Searching and filtering in the QMC

ô

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.
Tip noteDouble-click an item in the overview to open the resource's edit page. For multiple selections, hold down Ctrl while clicking the items, or drag over the items.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!