Q&A

remove all _0 from field names on new base view
asked 07-10-2021 14:23:59 -0400

we have config turned on where if a field is renamed because of space or special characters it appends underscore 0 to the end of the field name, we want to keep that feature on but I have a view of like 100 fields and half of them have it. Is there a...

Answers: 0

Base view Vql shell Rename

JDBC property as a parameter
answered 07-10-2021 12:59:57 -0400

Is there a way that we can pass a denodo JDBC property in as a parameter? PostgreSQL has an "options" parameter which does this as seen on https://jdbc.postgresql.org/documentation/head/connect.html. We are trying to define the ticketCache property fr...

Answers: 2

jdbc property parameter

Failing to connect
answered 07-10-2021 09:17:04 -0400

Failing to connect (via the browser on port 9090 and 9999 respectively, web design studio or virtual data port ) to the denodo VM. its a sentos7 denodo pre backed instance I have installed denodo on it and have started denodo and from the admin tool I ...

Answers: 3

Denodo VM

Denodo and POST to API
answered 07-10-2021 05:47:25 -0400

If I have a view in Denodo that is being frequently updated with new rows, is it possible to have Denodo POST the contents of the newest rows when they are added to the view to a 3rd party endpoint that is listening for the new data?

Answers: 1

Gettimeinmillis
answered 06-10-2021 08:51:55 -0400

Hi, I am trying to convert a timestamp field which is in the format (2021-08-25 12:53:29.13) to milli seconds by using the function gettimeinmillis(timestamp). Why is it not working? When I try it using dual for example : SELECT gettimeinmillis(now())...

Answers: 5

Gettimeinmillis

Issue post installing Denodo Express
answered 06-10-2021 01:48:53 -0400

Hi Team, I am not able to create any folder/VDB after successfully installing Denodo Express in one of the WIndows Machine with the default login/password: admin/admin. I took help of the IT team while installing it in the machine as advised during i...

Answers: 4

#Metadata Loading Metadata

End of life for denodo platform 7, 6
answered 05-10-2021 23:26:07 -0400

what is the end of life / end of support for the older version of denodo platform.. (e.g.- denodo platform 7, 6, older)

Answers: 1

Denodo vdp jdbcdriver
answered 05-10-2021 08:28:24 -0400

We have a requirement to do a security scan on denodo-vdp-jdbcdriver to make sure there are no security vulnerabilities. Do we have the source code for these drivers? Or is there any alternate available?

Answers: 1

Denodo vdp jdbc driver

Column Descriptions for VDB_CACHE_QUERYPATTERN
answered 05-10-2021 04:47:58 -0400

Could you please share a small decsription about the columns in the cache control table VDB_CACHE_QUERYPATTERN in order to understand more about the columns and the values (meaning of each values) it can store?

Answers: 1
Related to: https://community.denodo.com/kb/en/view/document/Cache database size estimate

SP-PRL-6788-21-47

The data source does not support 'cache_invalidate'='matching_pk'.
answered 04-10-2021 23:16:00 -0400

I have a data source that is doing a series of calls to an API to pull in a full data (the first time) that takes almost 6 hours. I successfully cached that data into a view -- but now want to only update records everyday that have a "last updated date...

Answers: 2

primary keys Cache Error API