Latest Activity

Denodo Express - Mac OS 11.6 Compatibility

Is Denodo Community edition compatible with Mac OS 11.6?

Forgot Username

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

GIT Integration: VCS management: VDP

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

Export script - Denodo Data Catalog

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

Connect denodo to ADF

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 ?

INSERT INTO with SELECT

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

Created Stored Procedure

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

Can I Use limit clause within the definition of a VQL view?

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

JDBC property as a parameter

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

Simba connection error in : uncategorized Column Type

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