Q&A

Troubleshooting steps for Denodo API failure
answered 21-09-2020 06:51:36 -0400

Hello Denodo Team, In case, if the REST APIs stops retrieving data. Could you please provide Step by Step troubleshooting sequence to handle this issue.

Answers: 1

#API #Rest_API

How do we do string_agg(sample1, ' + ') in denodo?
answered 21-09-2020 02:12:14 -0400

The operation string_agg(sample1, ' + ') done in Oracle needs to be implemented in Denodo.

Answers: 1

HTTP client JSON
answered 19-09-2020 16:28:08 -0400

Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a JSON HTTP client example to practice. This does not work : http://data-server:8080/sales-ws/sales/ Thanks.

Answers: 2

JSON HTTP client

Automated update of views on source data change
answered 18-09-2020 21:24:19 -0400

Is there any way to setup automated update of base and derived views whenever there is a source data change ?

Answers: 1

#Source Data

denodo roadmap
answered 18-09-2020 14:55:50 -0400

where can I found roadmap? what is the difference between denodo and dremio?

Answers: 1

roadmap

Multiple Users in 1 session, assessing same database same view.
answered 18-09-2020 08:08:27 -0400

would just like to check whether there are any restrictions or performance related impacts when multiple users are accessing the same views at the same time.

Answers: 1

session

Extract all option in Excel without sheet name is possible(Excel has multiple sheets)
answered 18-09-2020 07:54:04 -0400

Hii, I have a question related to Excel data dource wherein I am trying to create a scenario where I have multiple sheets in one single excel..say demo1.xsls. When I tick (a) Extract Sheet name as column name (b) extract data from all sheets. Then...

Answers: 1

Excel Denodo Excel Add-In

Record size exceeds internal limit error
answered 18-09-2020 04:33:46 -0400

Hello Team, I connected Netezza Data Source.I have created an view in Denodo. I am getting an error like 'Record size 90220 exceeds internal limit of 65535 bytes' while executing query. I serach this error and i found that it is Netezza's error. But ...

Answers: 3

Error

Denodo 7 Unattended Installation Issue with SCCM Deployment
answered 17-09-2020 07:50:53 -0400

Hello, I am currently attempting to install Denodo 7 with update 20200310 and when deploying through SCCM it always fails, here is the output, I have tried increasing the java memory heap but that does not resolve issue, do you have any things to try ...

Answers: 1

Denodo 7 sccm

1. How one can acess Encrypted Excel file via Excel data source.? 2. using an Interpolation variable will excel file who have all different password set
answered 17-09-2020 07:49:11 -0400

I have set passowrd to Excel file and was trying to access my file but it doent helped using Decrypt(DES, MD5 ) option How can we use interpolation variable when we have lots of locked Excel file. SO I have query around password only and How ca...

Answers: 1

Excel Interpolation Variables Denodo Excel Add-In