Latest Activity

code

using import from repository and properties file

i would like to use the import script command with the -r and -f options such that I have a vql file generated from the source control repository. the only other thing that is missing is the properties file. I would like to be able to execute the vql f...

code

Ms-Access database connection

Dear Sir, I have data in the MS-Access database and please let me know the procedure for connecting these database from the Denodo Tool. Give with example of connectivity. Regards, Senthil

code

Dynamic column names generated from a pivot

Is there a way in Denodo to do a pivot where you generate the column names from a column's distinct values. The only example I could find for Denodo used static values you already knew. I am assuming if there is, it is going to have to be custom VQL q...

code

LEFT JOIN losing rows

Hello, I am trying to join some tables, all with LEFT JOIN, but when I try, the numbers of rows in the results is less than the table in FROM statament. The strange thing is that if I change the order of the joins the number of the results rows change....

code

Design studio default VIRTUAL DATAPORT SERVER

Hi Denodo Team, When I load design studio, by default the VIRTUAL DATAPORT SERVER field is populated with //localhost:9999/ value. How can I override this value with my preferred value or list of values as drop down? This is to make the DIY team's lif...

code

VCS Management is disabled

Hi team, we are trying to configure git in denodo 8,but VCS Management is disabled in the Administration tab.Please suggest us how to enable it. Thank you

code

About Access to view vql of derived views

Some one of my team wants to exexcute one derived views that I created, and he also wants to have the read access of that derived views's vql. I grant "metedata", "execute" access of this derived view to him, I think it is the read access we mentione...

code

Failing to connect

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 ...

code

Denodo and POST to API

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?

code

Gettimeinmillis

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())...