Latest Activity

code

Alter on Base View - Add Trim

I would like to add Trim() function to the column in the base view to remove the default spaces for CHAR data type. Can I do this by running an alter statement? I need to do this across all the coulumn in the Source, Is there any setting to do trim by ...

base view DENODO

code

Keep view names to cached tables

When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Thanks, Sa...

DENODO Denodo Scheduler 6.0 SQL Server

code

Avoid deleting the cached data at the time of deployment to upper environments

We have some views created in the local environment and when we deploy it the upper environment, we cache the views. So, every time we do a deployment we turn the cache back on all the views. This is making the tables which are cached previously in the...

cache DENODO SQL Server deploy

code

Export Denodo Scheduler jobs for the backup

Hi, I'm trying to use the export script to export all the denodo jobs and wanted to schedule the script on weekly basis. But before that when i'm trying to use the export script it throws multiple errors: In Test environment: C:\Denodo Platform\Denodo...

DENODO Denodo Scheduler 6.0

code

Denodo Monitor Service Not Maintaining Running Status

Hello, I just finished following this tutorial on two machines. The first machine worked flawlessly and is running well (my local dev machine). However, after performing this on the DEV server (running Windows Server 2012), I am experiencing issues k...

Related to: Denodo Monitor as a Windows service

Denodo Denodo Monitor Auditing

code

Execution time increased after turning on the Cache

I am having around 20 services created whose base views are cached and indexed. The performance(execution time) of all the services was improved when I switched to cache database except one service. This one service execution time is increased to more ...

performance DENODO Denodo Scheduler 6.0 SQL Server

code

Retry unless Date_Column date matches with CURRENT_DATE()

I want to create a VDP job in scheduler which must keep retrying unless the column returns a row which is equal to CURRENT_DATE() select count(*) from Table where Date_Column = CURRENT_DATE() This query must get completed in scheduler only if the cou...

VQL Scheduler DENODO SQL Server

code

Issue adding JMX connection in VisualVM

I am trying to add a JMX connection with hostname as localhost and port number as 9999, I am receiving an error cannot connect to localhost:9999 using service:jmx:rmi:///jndi/rmi://localhost:9999/jmxrmi Can someone help me Please let me know if extra...

jmx DENODO

code

Scheduler: Delay till the data gets loaded in actual databases

I have a scheduled VDPCache job which starts every Saturday at 12:00. The actual databases from where the cache data gets loaded will undergo a weekend processing and gets new data. Sometimes this processing will takes long time than expected. If I kee...

cache DENODO denodo scheduler SQL Server

code

Scheduler: Truncate cache tables instead of invalidating.

I have a scheduled VDPCache job which starts every Saturday at 12:00. It invalidates the data for All Rows and load the cache every weekend . This makes the Cache Database keep a lot of invalidated data which is of no use and the disk space consumption...

DENODO denodo scheduler SQL Server invalidate cache