Latest Activity

code

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

code

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

code

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 ?

code

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

code

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

code

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

code

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

code

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

code

Unable to start Virtual DataPort Server.

I have installed Denodo express 8 version on MAC Os with JDK 11 as per the info from https://community.denodo.com/docs/html/browse/latest/en/platform/installation/appendix/supported_java_runtime_environments/supported_java_runtime_environments Post th...

code

VCS configuration in solution manager

Hi team, We are trying to configure git in solution manager using VCS,can u please suggest where we can find the databses which we created in denedo platform (or denodo design studio),how to enable these databases in solution manager. Thank you.