Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Server shutdown without information
answered 14-07-2020 07:55:15 -0400

We are doing a client POC with a partner license. The Denodo server is being shutdown randomly the last few weeks (although the computer is running from weeks ago without restarting). I have the main services (VDP server etc) prepared to be restared a...

Answers: 1

Server Shutdown Issue
answered 13-07-2020 11:33:20 -0400

I am unable to shutdown my VDP, Scheduler, IT Pilot Wrapper server. Please help urgently Error: Unexpected Error. Connection refused: Connect

Answers: 1

#VDPserver

How to connect Denodo with SSL certificate in Tableau?
answered 13-07-2020 04:26:23 -0400

Hi, Can any one provide me the steps to coonnect tableau with Denodo if SSL is enabled in Denodo server. I am also trying to connect by tableau but unable to get the option to attache public SSL certificate.

Answers: 1

ODBC Tableau Connecting Tabealu on Denodo ODBC DENODO Driver Tableau SSL

VDPCACHEDATASOURCE not connecting directly
answered 13-07-2020 02:23:03 -0400

I am using denodo express Enabled the cache at the database level in derby DB Created a cache with FULL mode at a derived view level. I did not create a cache at the base view level I can also confirm that queries on my derived is also using this cache...

Answers: 1

vdpcachedatasource

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