Latest Activity

code

Getting a stored procedure via VQL

Is there a way to get the stored procedure for a view / table created in Denodo via VQL? For example, I have a view called 'p_raw_data' that is created using the following procedure: CREATE OR REPLACE VIEW p_raw_data FOLDER = '/0. raw data' AS SELECT ...

code

Separating the Tomcat web container from Denodo

Hi, I would like to ask the following questions: Is it possible to separate the Tomcat built in web container which comes by default with Denodo, to a separate server? If yes how and do you have documentation with the steps for that? Instead of...

code

Error: 403 Authentication required

I am not able to download denodo installer. Its showing error 403 Authentication required. how to install it?

code

Error connection to Denodo via DBeaver

Hello Team, im havig issue while trying to connect to Denodo via Dbeaver version 21.XX using JDBC, i'm using the same driver on both and it's the driver of the installed version. The probleme is im not getting this issue from DBeaver 6.XX. The error...

code

Solution Manager: connection error checking the version of the Denodo server

Hello Team, I have an issue when trying to create a new revision in Denodo Solution Manager. After selecting which server I want to connect to, I receive an error that states "connection error checking the version of the Denodo server" that pops up. I...

code

Connecting to databases across network

I have 2 different networks with each of it’s own VPN is used. I have a SQL SERVER on one N/W and another N/W has Redshift database. I need to see both databases data same time. Is it possible? Thanks!

code

Issue connecting to Salesforce

Hello, I am having issues connecting to Veeva Salesforce. Performed the follwing tasks Created admin account in Salesforce Created a connected App in Salesforce Created a Data source connection ( File-> Data Source-> Salesforce) Selec...

code

Limitations

In the known Limitations, I see there items. “matching_rows” invalidation does not work. Only adding increments or full refresh (“all_rows”). Is this limitation still applicable in the latest version of Denodo. Please let us know as we are looking at...

Related to: Configuring Databricks as MPP and Cache

code

Multiple Aggregate fields in a selection view

Hello Denodo Developers, is it possible to create multiple agrregate field in one selection view? say for example, I want to see count of cases denied, case processed and total cases by state. The filters for the denied, processed need to be passed int...

code

VQL Shell count() discrepancy

Hi Team, We are getting less count from VDP VQL Shell than actual count. Example: VDP Admit tool: select count(*) from myview; count 300; if we execute the view retrieve all rows, count is 1000.