Q&A

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

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

Connecting to denodo from .net core 3.0
answered 28-12-2021 10:38:22 -0500

I am using .net core 3.0 with entity framework core . Is there an article somewhere detailing how to connect to denodo vdp using ef core and .net core. I tried connecting like a postgres database using Npgsql and it does not work.

Answers: 5

.Net core Entityframework Npgsql

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