Q&A BY TAG 'DENODO 7.0'
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 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
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
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
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 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 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
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
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