Q&A

Is Denodo Community edition compatible with Mac OS 11.6?

I tried to login to Denodo virtual dataport administration tool but I cannot remember my user name can someone help me

Hi, We have installed denodo 8 in our server and accessing the design studio as clients (through url). But we are unable to connect to the VDP admin tool from the client machines with the following error: Connection Error: Check the hostname and port n...

Hi, We are trying to take backup of the Data Catalog metadata (Denodo 8 base version). For that we are using the export script that has been provided. In our environment we have https configured and http connections have been blocked. So, when we run...

Hello, Can we connect ADF to denodo. I want to read denodo view through ADF(Azure data factory). Is it possible and if yes how ?

Hi Team, Could you please confirm the below limitation of VQL syntax. Working - INSERT INTO view2 SELECT col1 FROM view1; Working - INSERT INTO view2 (col1) VALUES ("abc"); Not working - INSERT INTO view2 (col1) SELECT col1 FROM view1; Not working - ...

I try to create an SP to create all the vdb folder structures, but when I run this: String query = "CONNECT DATABASE" + vdb + ";" + "CREATE OR REPLACE FOLDER '/01 - connectivity';" + "CREATE OR REPLACE FOLDER '/ 01 - connectivity / 01.1 - data sources'...

CREATE OR REPLACE VIEW my_limit_derivedview folder 'myfolder' AS SELECT X,Y, Z FROM my_derived_view WHERE x = 10 limit 1; Cannot save the above as a VQL view definition. The error comes as "Exception parsing query near limit" The same select query "S...

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

Hi, I am trying to fetch the data from a table on Azure Databricks (ADLS). Tables are delta tables. I am using Simba driver on Denodo and the connection is successful as suggested in denodo documentation. After successful connection. I try to do "Creat...