Q&A

Denodo Monitor Batch File failing to Start
answered 30-12-2021 07:07:19 -0500

Hello, I'm attempting to configue and launch the Denodo Monitor tool for Denodo Platform 8.0. I've followed the documentation to configure it through the ConfigurationParameters and launch it. When attemtping to run the denodomonitor startup.bat it fa...

Answers: 1

Denodo 8.0 Denodo Monitor Tools

Read DF with DataRange - error
answered 30-12-2021 06:41:30 -0500

Hi, I'm trying to read the monitor query log files with DataRange. If i try this: '<DENODO_HOME>/tools/monitor/denodo-monitor/logs/vdp-queries.log.^DateRange(“yyyy-MM-dd”,@start_date,@end_date,”yyyy-MM-dd”)' i recive the error when i try save dat...

Answers: 1

OS upgrade RHEL 7.3 to 8.4
answered 29-12-2021 07:09:36 -0500

We are planning to upgrade our Red Hat based Denodo servers from RH 7.3 to 8.4. Can we perform an in-place upgrade of the OS or are there issues we will need to be aware of?

Answers: 1

Redhat OS upgrade

Join Views with fields that have similar data, but not identical
answered 29-12-2021 05:25:21 -0500

Hello, I'm new to the Deonodo coummunity. I'm currently working on a poc using two Exel datasources I've created and built views on top of. I am trying to join two of these views together based on a field that contains a calendar quarter. In one field ...

Answers: 1

Excel join

Extracting Data from Views into a file
answered 28-12-2021 07:45:46 -0500

Do we have any in-build denodo function or script to export the data from a view into a file without using denodo scheduler ?.

Answers: 1

Create a Temporary Table in a CTE using Denodo in Dbeaver
answered 28-12-2021 07:02:58 -0500

Hi. I am using the below in Dbeaver Lite using Denodo. Select from V4780_B_TABLE_LOB WITH cte AS ( SELECT FROM ( VALUES ('B4000') ) AS a (agent_code) ) -- select * from cte; This works when accessing another Database outside of Denodo but doesn'...

Answers: 1

Connecting Ksqldb with denodo
answered 28-12-2021 06:31:17 -0500

Hi Team, Is there a way to connect Ksqldb with denodo ? Any suggestions will be highly appreciated . Thank you !

Answers: 1

ksqldb

In object Vql, PROPERTIES is the same, but order different,
answered 28-12-2021 06:10:10 -0500

Hi team, we are useing import .sh for Denodo objects auto-deploy, and we found, now is doing some tes, I found, when using Solution Manager, the Property is: PROPERTIES ('includeSynonyms'='false', 'remarksReporting'='false') When usin gimport shel dep...

Answers: 1

solution manager PROPERTIES order changed

Aggregate query for a denodo view with bind variable
answered 27-12-2021 22:45:11 -0500

Hi - I have a Interface denodo view with 10 columns and storeid as bind variable. When i tried to run a query with aggregate function, it returns syntax error. Also I need to run the query without passing any value to the bind variable column, select...

Answers: 3

Access Denodo Express

system-specific data access pattern
answered 27-12-2021 07:52:38 -0500

Hi, What doses mean system-specific data access pattern in denodo? Thank you

Answers: 1