topic How to connect to Cache database from QlikView in QlikView

How to connect to Cache database from QlikView

vishnus85 — Thu, 13 Jun 2013 12:41:55 GMT

Hi QlikFriends,

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 ?

Thanks

Vishnu

Re: How to connect to Cache database from QlikView

deepakk — Sun, 08 Jun 2014 06:27:37 GMT

I think you can connect using odbc connection.

Did u face any performance issue while loading the data into qv??

Regards

Deepak

Re: How to connect to Cache database from QlikView

vishnus85 — Sun, 08 Jun 2014 22:41:08 GMT

Hi Deepak,

I remember I had to download specific driver for connecting the cache DB.

Once this was done, the loading happened just like as it happens with any other db.

Regards,

VishnuS

Re: How to connect to Cache database from QlikView

deepakk — Tue, 24 Jun 2014 09:42:00 GMT

HI Vishnu,

We have case where QV is not able to load the data at all not even for one month. We heard pulling data cache database is bit difficult. Is there anything we need to consider.

Regards

Deepak

Re: How to connect to Cache database from QlikView

ThornOfCrowns — Tue, 24 Jun 2014 10:29:21 GMT

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.