Q&A

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

Connecting Tabealu on Denodo ODBC Tableau 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

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 custom wrapper derived view