Q&A

I am run the free trial of Denodo on Azure. I am trying to use DbVisualizer JDBC connection from outside of Azure. I've opened the network security but still cannot connect to the public IP .
answered 10-07-2020 04:25:38 -0400

jdbc:vdb://52.247.107.138:9999/tutorial where 52.247.107.138 is the public IP for my denodo-vm Windows I can connect using DbVisualizer to jdbc:vdb://localhost:9999/tutorial Is there any documentation on how to do this?

Answers: 2

Denodo on Azure free-trial

Denodo 7.0 not invalidating matching rows with dynamic VQL, working in 6.0
answered 10-07-2020 01:43:08 -0400

I have a cache update query with the paramaters: select * from view_name where "PeriodMonth" in ( cast('text',substr(FORMATDATE('MMM', ADDMONTH(CURRENT_DATE(),-1)),1,1)||lower(substr(FORMATDATE('MMM', ADDMONTH(CURRENT_DATE(),-1)),2,3))||'-'||FORMATDAT...

Answers: 1

7.0 Cache

Incomplete statistics in the following nodes
answered 09-07-2020 07:15:57 -0400

Hi Team, I'm facing an issue on gather stats. when i ran a query and gone through execution trace, I can see Optimizer message 'Incomplete statistics in the following nodes' and showing some base view names. i'm getting same message even after gathe...

Answers: 1

Gather Statistics

Error: Invalid number format for port number
answered 09-07-2020 06:00:00 -0400

I'm trying to make the DEN70EDUD1001VID01 - Data Sources. JDBC module and i am unable to establish connection. Here is the message : Unable to establish connection : invalid number format for port number. I need help, Thanks

Answers: 4

Question on VDP client for Linux64
answered 09-07-2020 02:28:06 -0400

If we have a Denodo Platform installed on Linux64, AND a VDP Client for Linux64- does the VDP client give access to a Graphical Interface to administer the otherwise "headless" Denodo Linux server?

Answers: 1

VDP 7.0

Denodo cache in AWS
answered 09-07-2020 00:30:30 -0400

What is the best database alternative to use in AWS as Denodo cache? (having S3 as main source to create "virtual datamarts").

Answers: 3

AWS S3

Denodo 8
answered 08-07-2020 13:46:23 -0400

Hi Guys i need small help where can i find to download Denodo 8 version

Answers: 1

joining multiple base view error via custom wrapper parquet file in S3.
answered 08-07-2020 11:00:56 -0400

Hi Team, I am getting below error while creating the derived view from joining multiple base view. Accessing the AWS S3 bucket data source from custom wrapper parquet file in S3. [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error accessi...

Answers: 3

S3 parquet file DENODO AWS S3 derived view custom wrapper

Query to find our who has access to an interface?
answered 08-07-2020 09:41:45 -0400

Is there a query we can run or API to determine who has read access to an interface? Anything more elegant than exporting the create with users and permissions and look at the VQL? Anything in Data Catalog? Damn. No way to edit the typo in the questio...

Answers: 1

Duplicate views are getting created while creating base views
answered 07-07-2020 14:18:41 -0400

Hi Team - I am creating base views on a delimited data source(CSV). For this I created a base view under this data source object in the server explorer pane of VDP Admin client. I also see another base view (with the same name) also getting created aut...

Answers: 2

Base view