Denodo community Q&A RSS feed Latest Denodo community answered questions Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau 2024-10-03T13:16:46Z 2024-10-03T13:16:46Z Need the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau 2024-10-03T13:16:46Z can i install denodo with postgresql version 16 2024-10-01T08:21:44Z 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 2024-10-01T08:21:44Z using an expression in Denodo 2024-09-28T06:00:28Z 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) 2024-09-28T06:00:28Z Data Movement Proving 2024-09-27T03:38:54Z 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 | 2024-09-27T03:38:54Z JDBC Connection Error - #sql6631_3dd5e99_1a' is full 2024-09-26T19:50:19Z 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. 2024-09-26T19:50:19Z Alter view on a different database in scheduler job 2024-09-26T12:42:09Z 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 2024-09-26T12:42:09Z Problems with Cloud Storage and Denodo â?? Any Advice? 2024-09-26T08:32:45Z 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! 2024-09-26T08:32:45Z typos and errors in systemd scripts 2024-09-25T16:29:18Z 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 2024-09-25T16:29:18Z PBI - Refresh error message 2024-09-24T19:35:19Z 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 ?) 2024-09-24T19:35:19Z Advancement Operations Data Services 2024-09-24T17:45:10Z 2024-09-24T17:45:10Z Is a tag a relabel in Denodo? If so, can a column be easily renamed? 2024-09-24T17:45:10Z