Q&A

Hi Team, We have Denodo 7.0 on LINUX machine and use VNC viewer for GUI. How to create desktop icon now after the installation ? as it was missed during the installation. Thanks.

Hi Team, How to create a cron job which should run Monday to Friday at 4 PM (all 5 weekdays only) (not on weekends) Thanks

Hi, Are there any ways to automate the creation of revision, including all the envi changes that we need to make and run it on schedule as needed? In brief what are all possible methods for automating deployments in solution manager? This should inclu...

HI everyone, I have a task to transform a text field to a timestamp field. The content of the initial field looks like this: "2017007", so it's like "YYYY0MM". I was trying aroudn with totimestamptz, but I don't know how to deal with this 0 in the ...

Hello, I have couple of virtual database called "db-A" and "db-B". I have created some baseviews and derived views on "db-A". I am currently on "db-B". I would like to access those derived views which are available on "db-A" and would like to use i...

I have been reading through the documentation of Trace directive in Denodo Testing Tool. I need to access the 'staticO' element in my trace file. When I am accessing the 'staticO' element in the .DENDOTEST file by using the following code 'PLAN ABC.PLA...

Comparing columns in "VDP Cache Monitor" with actual events, two columns are missing. SqlViewName and Truncateddata Has the format changed for V8.X? Columns listed as elasped time, fail to provide the unit of measure. Seconds, milliseconds? From revi...

Related to: Log column details

When using a left join to join a CTE in Postgres, we receive a column "does not exist" error. This error occurs when one or several of the columns in the CTE are not used in the joined query. When inspecting the Execution Trace and reviewing the Postgr...

Hi, the link Tokenization and encryption refers to a dead URL: https://dzone.com/articles/tokenization-vs-encrypti

Related to: Anonymization in Denodo

In DENODOTEST, I need to test the JDBC access protocol that is present in the configuration.properties file. e.g. "jdbc:vdb://<localhost>:<portNumber>/<databaseName>". Is there any information about testing protocols in DENODO? The co...