Q&A

Java Spring boot 2.3.4 application with denodo 6.0 vdp jdbc driver - Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (unable to initialize connection pool.)
answered 21-05-2021 21:12:55 -0400

Hi, I'm trying to establish connectivity from spring boot 2.3.4 application with denodo-vdp-jdbcdriver (6.0 20170515). I'm using DPCP2 to create jdbc datasource. driver-class-name=com.denodo.vdp.jdbc.Driver url=jdbc:vdb://localhost:9999/admin?poolEnab...

Answers: 3

Not able to start Denodo monitor from Solution Manager 8.0
answered 21-05-2021 09:13:52 -0400

Hi Team, We have configured Denodo Solution Manager 8.0. SSL/TLS is enabled.I am able to connect to Designer studio and VDP admin tool. But when I start monitor on VDP, I am getting the below error: "Cannot read JMX port of VDP. Unable to connect to D...

Answers: 1

#Diagnostic&MonitoringTool #Monitor

Promotion across environments
answered 21-05-2021 09:03:14 -0400

Typically the ideal scenario is to have one installation of the Solution Manager to access different environments such as SIT, UAT and PROD. This will allow to promote the changes from one environment to another using single instance of Solution Manage...

Answers: 1

QUERY [JDBC WRAPPER] [ERROR] Received exception with message 'Error obtaining some values for column(s): 'full_path''
answered 21-05-2021 05:16:22 -0400

Hi, I have this script below but I received this error Seems to be an issue with group by because other scripts without the group by and same filters do work. (please also note this is sourced from db2 resevoir) Not sure because the consultants ensure...

Answers: 3

Error

Postgres ADDDAY translates, but other ADD datetime functions do not
answered 20-05-2021 21:10:43 -0400

We recently started using a Postgres connection in Denodo. We've noticed that on larger datasets (particularly in joins) that performance is impacted when using the ADDMONTH function. ADDMONTH can't be delegated to the data source since it's not a Post...

Answers: 3

datetime PostgreSQL Date time function

How to access Delta Table on Azure BlobStore from Denodo
answered 20-05-2021 20:00:47 -0400

Hi, I stored my delta tables on Azure Blob Storage. Now I want to access these tables from Denodo. Alternatively, I tried Simba connector to connect Azure DataBricks tables, and that works fine. But that does not show the Blob Store Tables. Ideally Sim...

Answers: 2

BLOB simba deltalake Azure Data Lake Storage Gen2

User Metadata Access
answered 20-05-2021 17:59:32 -0400

Is it possible for the user to view the metadata for all the base views across all databases/schemas but limited to query only the data they are entitled to those base views?

Answers: 1

Role and User Management

Machine requirements for Denodo Express
answered 20-05-2021 16:33:05 -0400

I will load Denodo 8 Express on a Windows machine but I don't see required resources anywhere: RAM, CPU? Obviously more is better, but just to try it with minimal data, what do I need? Thanks Judith Judith Ullman Business Intelligence Team Lead The N...

Answers: 1

Memory Requirements CPU Requirements Denodo Express 8

Error handling mechanism on Baseview
answered 20-05-2021 14:21:32 -0400

Hi, I created one datasource and on top of it there is a baseview. Suppose the source is unavailable now and base view is throwing error and its not retrieving the data. Now whenever baseview throws error due to any reason. It should trigger an mail ...

Answers: 1

ERROR_HANDLING error handling

Listagg distinct
answered 20-05-2021 13:37:54 -0400

Hi, Denodo 8.0 supports listagg function, but can distinct clause can be used inside the listagg?

Answers: 1

Listagg