You can translate the question and the replies:

Multiple Cache databases in one Denodo Server

Would like to find out if we can create multiple Cache databases within one Denodo server: 1. Admin, Virtual Database1, Virtual Database2, Virtual Database4: uses a MySQL Cache database DB1 2. Virtual Database3: uses a MySQL Cache database DB2 3. Virtual Database5, Virtual Database6: uses a MySQL Cache database DB3 The MySQL databases will reside in the same database server, but will be created as different databases.
17-11-2016 16:40:14 -0500

1 Answer

Hi there, What I do to configure specific caches for different virtual databases is use the Admin tool > Administration > Database Management. Then, for each database you want to configure, check the checkbox next to it, and click 'cache' from the top of the Database Management panel. In the new popup, deselect 'Default configuration', and then deselect 'Default data source'. Now, the Connection tab becomes available and you can configure the cache like a normal JDBC source. You can do this with a different database as the cache for each of your virtual databases. Hope this helps!
Denodo Team
18-11-2016 20:55:11 -0500
You must sign in to add an answer. If you do not have an account, you can register here