I am in need to extract data from a cache database into my qlikview dashboard. This is the first time I am facing such a requirement and till now I used to connect and extract data from oracle and sql server.
Can anyone help me in getting this connection right. Do i need to install a new connection driver for this process ?
Re: How to connect to Cache database from QlikView
As I remember, Cache is a "non relational database" and so needs to be treated differently in practice, though using it as a LOAD in QV shouldn't be an issue as you're rebuilding your keys, links, joins and tables in the Script.
You may be caught out by the fact that Cache holds all data as strings and null data are zero length empty strings.