As you already know, Denodo includes a module to store local copies of the data as required. This cache will use a Relational Database accessible through JDBC protocol (MySQL, Microsoft SQL Server, Oracle, DB2, Netezza, Oracle TimesTen, etc).
To use the cache system it can be enabled at server level or at database level. For this tutorial we will configure the cache at server level. Let's see how to configure the Denodo server to use cache:
Administration > Server configurationand then click
Cache statusto On.
Embedded Derby serveris the
Database adapterthat will be used this tutorial.
In the next section, you will learn how to configure what views have to be cached.