Denodo community Q&A RSS feed

Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau

2024-10-03T13:16:46Z

Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau

can i install denodo with postgresql version 16

2024-10-01T08:21:44Z

can you confirm that i can install denodo entreprise 8 associated witt a postgres sql v 16 I cannot find a compatibility matrix with such detail thanks

using an expression in Denodo

2024-09-28T06:00:28Z

I'm trying to replicate this expression into Denodo : CASE WHEN SUBSTRN(FINANCIAL_ASSOCIATE_ID,1,7) = 'BS:BNK:' THEN SUBSTRN(FINANCIAL_ASSOCIATE_ID,8) ELSE SUBSTRN(FINANCIAL_ASSOCIATE_ID,4) END. Can someone help me with that? I started with this : subs('bv_db_dds_financial_associate."FINANCIAL_ASSOCIATE_ID"', 1, 7)

Data Movement Proving

2024-09-27T03:38:54Z

Hi. So I tried the Data Movement Optimization however it doesn't seem to be that effective in optimizing CPU usage and spends more execution/ query time. Can help with the analysis? I used the DVD rental sample dataset | Attributes | With DM | Without DM | | ----------------------- | ------------ | ----------------- | | Execution Time | 445 ms | 57 ms | | CPU Time | 375 ms | 62 ms | | CPU Usage Avg | 8.42% | 13.84% | | Static Opt Time | 398 ms | 24 ms |

JDBC Connection Error - #sql6631_3dd5e99_1a' is full

2024-09-26T19:50:19Z

Hi, I receive the error as following when running the view: [JDBC ROUTE] [ERROR] Received exception with message 'The table '/var/tmp/#sql6631_3dd5e99_1a' is full'. I connect Denodo to MySQL.Is that something wrong with MySQL database instead? Thanks.

Alter view on a different database in scheduler job

2024-09-26T12:42:09Z

Hello, I'm trying to execute a dynamic alter view using the scheduler in order to simplify the updates of description in my different views. But i have an issue regarding the proper syntax of the "alter view". **this** = "alter view test_alterview_rp_audience_globale_mensuel (alter column annee add (DESCRIPTION = 'Annee de l''audience du site'))" **that** = "alter view test.test_alterview_rp_audience_globale_mensuel (alter column annee add (DESCRIPTION = 'Annee de l''audience du site'))" I work my database called 'test', when i execute **this** in the VQL Shell of the database it works fine. But when i execute it in the scheduler i have this error : "View 'test_alterview_rp_audience_globale_mensuel' not found" If i add 'test' in front of the name of the view like **that** it says this error : "Syntax error: Exception parsing query near '.'" ; which does not make sense since "select * from test.test_alterview_rp_audience_globale_mensuel" works fine. Is there a way to set the name of the database used in the VQL Shell with a command line ? (like use database ... or something else) Or is there a way to set the database in the "Extraction section" of the scheduler job ? I have not find any of these in the documents. Or if someone has another solution for me. Thanks

Problems with Cloud Storage and Denodo �?? Any Advice?

2024-09-26T08:32:45Z

Hello everyone, I'm currently facing challenges with cloud storage when integrating it with the Denodo platform. The primary issues revolve around data accessibility, performance bottlenecks, and synchronization between the cloud storage and Denodo. Specifically, I would like to know: Performance Tuning: What configurations or best practices can be applied to enhance performance when using Denodo with cloud storage? Data Accessibility: How can I ensure smooth and quick access to data stored in the cloud while using Denodo? Are there particular setups or approaches that help in this regard? Synchronization Issues: What steps can I take to address any potential synchronization problems between Denodo and the cloud storage? Are there tools or methods that can help streamline this process? Integration Strategies: Are there recommended strategies or industry best practices for effectively integrating Denodo with cloud storage solutions? I would greatly appreciate any insights, tips, or experiences that others have had with Denodo in a [cloud storage](https://www.lenovo.com/gb/en/d/cloud-storage/) context. Your advice will be invaluable in helping me resolve these challenges! Thank you!

typos and errors in systemd scripts

2024-09-25T16:29:18Z

Hi, I noticed some typos and errors in the vqlserver script for systemd: * DENODO_SERVICE="DENODO_APP=Denodo VDP Server" should be DENODO_SERVICE="Denodo VDP Server" without DENODO_APP= * DENODO_PID_CHECK_PATTERN=â�?��DENODO_APP=Denodo VDP Serverâ�?�� should be DENODO_PID_CHECK_PATTERN="DENODO_APP=Denodo VDP Server" please, notice the character for double quotes * if [[ -n "$pid" ]] && [[ -r /proc/$pid/cmdline ]] && xargs -0 printf '%s\n' < /proc/$pid/cmdline | /bin/grep -q "$DENODO_PID_CHECK_PATTERN"; then should be if [[ -n "$pid" ]] && [[ -r /proc/$pid/cmdline ]] && xargs -0 printf '%s\n' < /proc/$pidf/cmdline | /bin/grep -q "$DENODO_PID_CHECK_PATTERN"; then also inside schedulerserver and schedulerindexserver Thanks to the author of the scripts for his useful work and Best regards

PBI - Refresh error message

2024-09-24T19:35:19Z

i got an error message when using PBI to refresh a report. This is the first time trying this. I used my usual company email and sign-on password, which i hope is the same password for Denodo at this company. However, it appears that it might be access to specfic databases. i got an error message when using PBI to refresh a report. This is the first time trying this. I used my usual email and sign-on password, which i hope is the same password for Denodo. error 1: fv_std_insurance_dp_counterparty ODBC: ERROR [08001] could not transalte host name "den9001-vm.XXX.ca" to address: Unknown host. where XXX is my comany name. (how do i copy in a screenshot in jpg ?)

Advancement Operations Data Services

2024-09-24T17:45:10Z

Is a tag a relabel in Denodo? If so, can a column be easily renamed?