Q&A BY TAG 'Denodo'

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

How to convert a date in string format to interval date
answered 18-01-2021 05:54:50 -0500

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Answers: 1

Date Conversion VDP DENODO

"SELECT top 1 1 as ID FROM <base view> uanble to excute
answered 13-01-2021 02:26:45 -0500

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM &lt;base view&gt; " for the expected result ID 1 what changes can be done as the expected result thanks in Advance

Answers: 1

Top N SAP DENODO SAP BW/4HANA denodo with tableau

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

&lt;Reference&gt; https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&amp;title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F &lt;Denodo VDP Version&gt; 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. &lt;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 &lt;Column_name&gt; from &lt;data_base&gt;.&lt;Base_view_name&gt; throwin...

Answers: 1

VQL SAP DENODO SAP BW/4HANA

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

DENODO JDBC Python

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

DENODO