Denodo Server - Setup & configure Cache Database to MySQL:

Denodo Server - Setup & configure Cache Database: - Bottlenecks

Step1:

Install the Denodo Server by clicking the executable and follow the steps with giving inputs and files as required to complete the server install.

There will be 8 steps for the entire process and it will take 10-15 minutes to complete the install

Step2: bottlenecks faced

The Admin tool was giving the connection Error when connecting to the VDP Server due to reasons below           

                      Connection Error -

                      Service on Denodo gets started and stopped immediately

                      Log file shows the license error message

Solution tried was to close all the admin tool of denodo , start the denodo vdp server and scheduler and open the Admin tool to connect to server - it works

Step3 : Denodo Setup activities to import the VQL or create a new data base and data source connection as required ( normal Admin & Developer stuff)

Step 4: Validation of the new database created on denodo and querying the underlying objects to make sure everything is working as expected. Also check the respective denodo Server and scheduler logs respectively to verify the errors.

Step5: by default the Embedded Derby will be configured as cache database for the objects, now we will try to replace with MySQL database for Cache Loading & Performance

Step6 - My SQL - Install and configure database:

Bottleneck. Faced:

                      Prerequisites were not met so ended up in install of Microsfot Dotnet Framwork ( Visual c++ 20003 Kit for install to continue successfully.

                      Command prompt execution of my sql commands to connect, create & configure the cache database with required options

Step7: Configuration of the my sql cache database to Denodo Database Cache options.

Bottleneck faced

                com.jdbc mysql driver error when the new database is configured in denodo

                Could not change the cache parameters- unable to find the jar / driver

Step8: Place the Jar file (my SQL connector JAR) file in both the location of the lib folder in Denodo and My sql it worked and was able to successfully configure the new database

Step9: Configure the cache for the object and Load the cache, invalidate the cache and repeat few iterations to make sure the functionally works and its consistent.