Q&A BY TAG 'DENODO 7.0'

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

Passing case statement as subquery in select statement.
answered 22-07-2021 17:57:43 -0400

We are automating function to get prior two business days excluding weekends using below logic : select * from dw_vdb.cib360_bv_daily where as_of_date in (select case getdayofweek(current_date) when 3 then addday(current_date, -4) when 2 then addday(c...

Answers: 3

Denodo 7.0 Select Query CASE

Denodo JDBC connector for PostgreSQL 11
answered 30-06-2021 02:38:05 -0400

Hi, I am trying to connect to a PostgreSQL 11 from Denodo 7.0, but the latest available JDBC driver seems to be for PostgreSQL 10. Does any of you know if there exists a JDBC connector for PostgreSQL 11 available in Denodo 7.0? If not, is it safe to us...

Answers: 1

Denodo 7.0 PostgreSQL

denodo testing with nested complex structure
answered 27-04-2021 06:34:00 -0400

Hi, I am trying to test some complex structure. Suppose I have the following view: tech_data Array and Array is: measurements weights additional Register Register R...

Answers: 1

Denodo 7.0 Denodo Testing Tool complex array

Aggregation of derived views delegating search methods to base view
answered 02-04-2021 07:46:17 -0400

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

Answers: 3

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation

Pivot rows into columns in an array
answered 01-04-2021 08:07:04 -0400

Hello, what I would like to achieve could be straightforward but I'm very new to Denodo. I have a view like this: model_id equipment 1 Array where the Array is like this: description v...

Answers: 1

Denodo 7.0 ARRAY Pivot

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

Denodo 7.0 VQL search methods join Derived views

Error: maximum number of concurrent queries by group reached
answered 19-03-2021 08:38:20 -0400

We are getting 'maximum number of concurrent queries by group reached' error in VDP admin tool first time and can't find the reason/solution from community. We are getting this error when we try to even open the existing view and all queries are gettin...

Answers: 1

Denodo 7.0 Error

denodo base view refresh
answered 15-03-2021 08:46:28 -0400

We have scenario where we need to refresh base views using scripts/VQL. Is there a script to mass refresh base views and confirm with single script?

Answers: 3

Denodo 7.0 Base view Source refresh

"Remote license not found. The server is not registered in Solution Manager." when starting VDP server in Docker container.
answered 18-01-2021 06:04:32 -0500

Can't get past the server trying to find a license on the license/solution manager when starting a VDP server in a Docker container. I've successfully started a local installation of a VDP server getting a license from the license/solution manager and ...

Answers: 1

container Denodo 7.0 Denodo 7 Solution Manager Docker 7 License 7.0 docker

After AMI update to denodo solution manager there is a foilder /denodo but no solution manager software under that folder, Any ideas?
answered 20-11-2020 04:15:59 -0500

After AMI update to denodo solution manager there is a foilder /denodo but no solution manager software under that folder, Any ideas? In /etc/fstab file there is entry for /dev/sdh and no errors in AWS console for attached volume to the new instance I...

Answers: 1

Denodo 7.0 DENODO