- 11 Oct 2024
- 3 Minutes to read
- DarkLight
Local QlikView Documents
- Updated on 11 Oct 2024
- 3 Minutes to read
- DarkLight
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.
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:
Name | Description |
---|---|
Name | The name of this datasource. This does not have to be the name of the QVW file. |
QVW Path | The 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 Credentials | This 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). |
Username | The 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. |
Password | The 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 Cache | When 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 Name | The name of the field to filter before rebuilding the cache. This property is only applicable if Set Filter Before Rebuilding Cache is enabled. |
Filter Value | An 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 Cache | When 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 ID | The 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).
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.