Q&A BY TAG 'denodo'

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

The version of Denodo on which window (analytic) function of SQL can be used
answered 12-01-2021 07:09:17 -0500

<Reference> https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F <Denodo VDP Version> 6.0 Administration tool:...

Answers: 1

DENODO #Analytic function

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity
answered 08-01-2021 05:42:07 -0500

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. <Error Description when retrieving data from De...

Answers: 1

ODBC Excel Microsoft Query DENODO data types

Fetching Column issue in VQL
answered 05-01-2021 05:39:50 -0500

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select <Column_name> from <data_base>.<Base_view_name> throwin...

Answers: 1


I can able to execute the table but unable execute the specific column of the table
answered 04-01-2021 05:51:58 -0500

I can able to execute the table but unable execute the specific column of the table. error message Finished with error: Field not found 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CHANNEL_ENGAGEMENT_AGG_001.start_date' in view 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CH...

Answers: 1

Invalid query in create base view from query DENODO

How to connect denodo from airflow
answered 28-12-2020 06:50:53 -0500

I would like to connect to denodo views to read the created views from airflow. Pls advice

Answers: 1


Getting this when trying to connect Denodo: authentication error: Database 'admin' not found.
answered 18-12-2020 13:41:19 -0500

Hi Team, we are using Denodo from Azure market place. Everyday VM need to shutdown and restart when required. Once the VM is started, the services for Denodo becomes up and running. But when trying to connect with vdp it is giving this errror: authenti...

Answers: 1

Connection issue to VDP DENODO

Export denodo views to ADLS (AZURE DATA LAKE)
answered 14-12-2020 04:58:21 -0500

I am using denodo 7.0 in on-prem, i want to export a denodo views such as base view, derived view,etc as xlsx file, parquet, avro to azure blob storage in ADLS. Pls advice. thanks!

Answers: 3

Denodo on Azure BLOB azure blobl storage DENODO Export Azure Data Lake Storage Gen2

Command to confirm for odata4 service running in vdp server?
answered 02-12-2020 06:24:37 -0500

What is the command to confirm for odata4 service running ( by default) in a vdp server?

Answers: 1


How to have all view statistics regarding to how many times queries have been thrown to each view
answered 01-12-2020 06:39:27 -0500

I would like to know how to have all view statistics regarding to how many times queries have been thrown to each view. https://community.denodo.com/docs/html/browse/6.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_stati...

Answers: 1

DENODO view statistics Denodo view

In support.denodo.com there Licenses and then actions --> Get License. Our denodo env. is 7.0 and there no actions under 7.0 license, but there is actions under 6.0 version.
answered 25-11-2020 20:15:15 -0500

Question - Is this a bug in the licenses portal at denodo.support.com ? We need to get license under actions in the Denodo 7.0 and not under Denodo 6.0. Please advise.

Answers: 1