The following guide is on how to create a QVD file for use in Qlik (QlikSense).

Connect to data sources in the data load editor

Data connections in the data load editor let you 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 box to narrow the list down to connections with a certain name or type.

You can only see data connections that you own, or have been given access rights to edit. Please contact your Qlik Sense system administrator to acquire access if required.

Creating a new data connection

For a QVD file storage, you will need to create the database (Microsoft SQL, Oracle etc) connection and a local / network file connection.

  1. Click Create new connection.

  2. 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.

  3. 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.

The settings of the connection you created will not be automatically updated if the data source settings are changed. This means you need to be careful about storing user names and passwords, especially if you change settings between integrated Windows security and database logins in the DSN.

If Create new connection is not displayed, it means you do not have access rights to add data connections. Please contact your Qlik Sense system administrator to acquire access if required.

Data Load Editor Script

LIB CONNECT TO 'DatabaseConnection';

TableName:
LOAD *
SQL SELECT *
FROM DatabaseName.SchemaName.TableName
WHERE Filter=1;

STORE TableName INTO [lib://LocalFileConnection/TableName.qvd](qvd);

Source

Connect to data sources in the data load editor