Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 28, 2021 1:36:48 PM
Jun 28, 2016 7:31:06 AM
Some connectors cache data locally, this has the benefit of:
?If you wish to delete the data cached for a connector manually
If you wish to clear the cache in your load script you may do so with the following script:
1 2 3 4 5 6 7 8 |
ClearCache: LOAD [Qlik Web Connectors_ClearCache_Result], |
You just need to replace CONNECTOR_NAME with the the right value, this will be the value present in the same place in the url for the other load statements you use for this connector.
So for example for the Twitter Connector you could place this as the first statement in your load script, perhaps running it conditionally based on the number of days since your last reload.
1 2 3 4 5 6 7 8 |
ClearCache: LOAD [Qlik Web Connectors_ClearCache_Result], |
Some connectors support an additional paramter: &clearcache_searchPattern=
Here you can pass in a string with * wildcards to further specify which cached items are to be deleted. Currently only the Facebook for Pages Connector and Facebook Insights Connector supports this - typically you would use 'clearcache_searchPattern=[pagename_or_id]'. So for example to clear all the cached items for the QlikView Facebook page simply use.
1 2 3 4 5 6 7 8 |
ClearCache: LOAD [Qlik Web Connectors_ClearCache_Result], |
You can use the parameter:
&clearcache_ageInHours=X
Where X is an integer greater than or equal to zero. If this is specified, then only items older than this will be deleted.
By default the Qlik Web Connectors cache will be contained in a sub-directory under QlikWebConnectors.exe. For example if Qlik Web Connectors is running in the folder:
- F:\Qlik Web Connectors\
the cache for each connector will be located at:
- F:\Qlik Web Connectors\App_Data\[User]\[CONNECTOR_NAME]_Cache
where [User] is the GUID for the user logged in when setting up the connector (Default GUID for Admin is DEFAULT0-000-000-000-00000000000)
As an example, results from the sentiment analyzer will be cached at:
- F:\Qlik Web Connectors\App_Data\DEFAULT0-000-000-000-00000000000\SentimentAnalyser_Cache
You can change the directory where the cache is installed by editing deploy.config and change the FileBasedCacheProvider setting:
<Cache provider="FileBasedCacheProvider" config="{app_root}/App_Data/{user_id}/{connector_id}_Cache/"></Cache>?
A large number of files can accumulate in the cache directory and for this reason we would recommend configuring Windows to compress it. To do this right click on your App_Data folder and select properties:
The click the 'Advanced' button:
Then check the 'Compress' option:
You should then confirm the following:
You should then see the folder highlighted in blue illustrating that it is compressed.