Local QlikView Documents
  • 18 Sep 2024
  • 3 Minutes to read
  • Dark
    Light

Local QlikView Documents

  • Dark
    Light

Article summary

General

This type of datasource connects to a QlikView document that is accessible through the local or network file system. The Service Account needs to have at least read-access to the location where the QVW file is stored.

NOTE

When using a Local QlikView Document Datasource, the machine that runs Mail & Deploy Server will load the QlikView document into memory and perform calculations and extractions locally. This means that the machine needs to have the required hardware resources to perform these operations; the amount of required RAM or CPU power strongly depends on the complexity and size of the QlikView document that is being used.

Properties

This type of datasource has the following properties:

NameDescription
NameThe name of this datasource. This does not have to be the name of the QVW file.
QVW PathThe local or UNC file path to the QVW document. The Mail & Deploy Service Account need to have at least read-access to that file (if you want to use Mail & Deploy to save the datasource, right-access is required as well). Mapped network drives are not supported; to access a network location you need a UNC path.
Use Custom Section Access CredentialsThis setting needs to be disabled if the QlikView document does not use section access. If the QlikView document does use section access and the Mail & Deploy Service Account is an NTNAME section access user, the property needs to be disabled as well. The property needs to be enabled if you need to specify a USERID section access user (see  QlikView Section Access Management).
UsernameThe USERID of the section access user to use to open the QVW document. This property is only applicable if Use Custom Section Access Credentials is enabled.
PasswordThe password associated with the USERID to use to open the QVW document. This property is only applicable if Use Custom Section Access Credentials is enabled.
Set Filter Before Rebuilding CacheWhen enabled a filter can be set before the cache of the datasource (see Datasources) is rebuilt. This can help speeding up the cache rebuilding process, especially for very large or complex data models.
Filter Field NameThe name of the field to filter before rebuilding the cache. This property is only applicable if Set Filter Before Rebuilding Cache is enabled.
Filter ValueAn Expression that returns the value to filter to before rebuilding the cache. This property is only applicable if Set Filter Before Rebuilding Cache is enabled.
Click Button Before Rebuilding CacheWhen enabled, you can specify a Button ID; this is the ID of a button object within the QlikView document that shall be clicked before rebuilding the cache of the datasource datasource (see Datasources).
Button IDThe ID of the button object within the QlikView document to be clicked before rebuilding the cache of the datasource. This property is only applicable when Click Button Before Rebuilding Cache is enabled.

Section Access

If the QlikView document is protected using Section Access there are two ways to allow Mail & Deploy to access that QlikView document (see  QlikView Section Access Management).

NOTE

Mail & Deploy always needs a section access with an ACCESS of ADMIN to the QlikView document.

NTNAME access

If the Mail & Deploy Service Account exists as an NTNAME section access user in the QlikView document, the property Use Custom Section Access Credentials does not need to be enabled.

USERID access

You can also add a custom USERID section access entry to the section access user list of the QlikView document. In that case, the property Use Custom Section Access Credentials needs to be enabled and you need to specify the USERID as Username and the associated password as Password.


Was this article helpful?