Latest Activity

code

Listing views with cache enabled

How can I get a list of views where cache has been enabled?

cache view option cached views

code

Partial cached data subset still going to source

We are currently trying to use partial cache in denodo in both the versions of 6 & 7 and facing one issue. When we put the partial cache on for the view and run the query to cache it. For eg. Select * from test1 where id in (1,2,3,4); it caches ...

Partial cache Cache

code

Schema change and Source Refresh with Denodo and Cache store

Hello, We have snowflake as our cache store. When we add a new column to source, our cache refresh jobs fails with "Number of columns in file (25) does not match that of the corresponding table (23),". Any process we ned to follow to update cache schem...

Source refresh schema change Cache Cache error

code

Why is it recommended that Apache Derby embedded database should NOT be used for storing cache data for production?

For almost all of the Denodo articles that talk about caching, we see snippets like this: "... you can configure the cache module to store the cache data in the Apache Derby database embedded in Virtual DataPort. However, we strongly recommend using an...

Cache

code

Cache Error Modifying View

Hi - we have been having intermittent problems with our cache. Randomly, when I try to change the cache mode on any view, I receive the error: Error modifying view: Error getting valid table name At this point, I have to ask our admin to reboot or res...

Cache

code

SSRS and Caching

I have created an SSRS report with parameters that the user inputs (using ? as parameter in the SQL). The derived view that the SSRS report is using has partial cache mode turned on with match exact queries only selected. It seems as if the report is ...

cache partial cache ssrs

code

Cache modes

Hi, I'm using the Denodo Express Edition platform and I'm trying to try the partial cache mode with the Match exact queries only option. I have entered Administration> Server configuration and I have activated Cache Status. Then before executing the...

Partial cache Cache

code

Cach data using Java

--typo on header can not edit :( i want to cache data using java .i have following question 1.Denodo have any API? 2.Please share sample code? i have modifed the denodo jdbc client sample and tried it is not working. please help me on this

java Cache

code

Power Query parameters not working when cache is on

Hi - I have a view with 1 parameter that I am consuming in Excel through ODBC. I cannot pass the parameter back to Denodo unless the cache is turned off of the view. Is there any solutions for this?

Power BI Cache

code

VDP "store results in cache" isn't working

when I execute the following SELECT FROM oneview CONTEXT ('i18n'='us_mst', 'cache_preload'='true', 'cache_wait_for_load'='true') it returns around 160 records. However, subsequently when i do select from oneview i get zero records.. why isnt my cache...

Cache