Data connections in the data load editor provide a way to save shortcuts to the data sources you commonly use: databases, local files or remote files. Data connections lists the connections you have saved in alphabetical order. You can use the search/filter box to narrow the list down to connections with a certain name or type.
For more information, see Connecting to data sources.
Creating a new data connection
Do the following:
- Click Create new connection.
-
Select the type of data source you want to create from the drop-down list.
The settings dialog, specific for the type of data source you selected, opens.
-
Enter the data source settings and click Create to create the data connection.
The connection name will be appended with your user name and domain to ensure that it is unique.
The data connection is now created with you as the default owner. If you want other users to be able to use the connection in a server installation, you need to edit the access rights of the connection in the Qlik Management Console.
Deleting a data connection
Do the following:
- Click Ö on the data connection you want to delete.
- Confirm that you want to delete the connection.
The data connection is now deleted.
Editing a data connection
Do the following:
- Click @ on the data connection you want to edit.
- Edit the data connection details. Connection details are specific to the type of connection.
The data connection is now updated.
Inserting a connect string
Connect strings are required for most connections. Only folder and web file connections do not require connect strings.
Do the following:
- Click Ø on the connection for which you want to insert a connect string.
A connect string for the selected data connection is inserted at the current position in the data load editor.
For more information, see Connect.
Selecting data from a data connection
If you want to select data from a data connection to load in your app, do the following:
- Create new connection linking to the data source (if the data connection does not already exist).
- ± Select data from the connection.
Referring to a data connection in the script
You can use the data connection to refer to data sources in statements and functions in the script, typically where you want to refer to a file name with a path.
Example: Loading a file from a folder data connection
This example loads the file orders.csv from the location defined in the
Example: Loading a file from a sub-folder
This example loads the file Customers/cust.txt from the
Example: Loading from a web file
This example loads a table from the
Example: Loading from a database
This example loads the table
Where is the data connection stored?
Connections are stored using the Qlik Sense Repository Service.You can manage data connections with the Qlik Management Console in a Qlik Sense server deployment. The Qlik Management Console allows you to delete data connections, set access rights and perform other system administration tasks.
