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

Unable to connect to MariaDB server
answered 01-03-2022 07:11:27 -0500

Hello, I'm trying to connect to our MariaDB database in Denodo 7.0. As the MariaDB driver is not installed in our Denodo server, I tested using the MySQL5 Database adapter as a substitute, as suggested here: https://community.denodo.com/answers/quest...

Answers: 1

Denodo 7.0 MariaDB

denodo view name maximum length
answered 21-02-2022 01:17:57 -0500

I can not find the maximum limit for denodo view name anywhare. We want maximum charecters denodo supports for view naming for denodo 7.0 Appreciate your help.

Answers: 1

Denodo 7.0 create view view name

Bit datatype transforms to boolean in denodo base views
answered 18-02-2022 07:18:24 -0500

I have one scenario where one of the fields from the source(MSSQL) is a bit datatype while creating a base view in denodo it gets transformed into boolean datatype. Users want to see the results in 0/1 instead of true/false. Even end user application...

Answers: 1

Denodo 7.0 datatype

Pivot rows into columns in an array
answered 01-10-2021 02:09:00 -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: 3

Denodo 7.0 ARRAY Pivot

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

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