- 04 Sep 2024
- 2 Minutes to read
- DarkLight
Server QlikView Documents
- Updated on 04 Sep 2024
- 2 Minutes to read
- DarkLight
General
This type of datasource connects to a QlikView document on a QlikView server using a QVP URL. The Service Account needs to have access to the QVW on the QlikView server.
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. |
QVP URL | The QVP URL of the QlikView document. You can get the QVP URL by launching QlikView Desktop Client and opening the QVW; the title bar will then display the QVP URL. |
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.