Denodo community Q&A RSS feedLatest Denodo community answered questionsNeed the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau2024-10-03T13:16:46Z2024-10-03T13:16:46ZNeed the denodo-v80-update-20240926 compatibility matrix with Power Bi, Alteryx, Tableau2024-10-03T13:16:46ZRe-register for expired course2024-10-02T08:17:05Z2024-10-02T08:17:05ZHi. I am trying to access this course https://community.denodo.com/training/course/8.0/Advanced%20Configuration%20of%20Denodo%20View.
The course has expired however I wish to re-register.
The option is not available to re-register for this course, only a link to Launch Course in LMS which does not work as it has expired.
Please could you help?
Thanks, Gareth2024-10-02T08:17:05Zcan i install denodo with postgresql version 162024-10-01T08:21:44Z2024-10-01T08:21:44Zcan 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 thanks2024-10-01T08:21:44Zusing an expression in Denodo2024-09-28T06:00:28Z2024-09-28T06:00:28ZI'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:28ZData Movement Proving2024-09-27T03:38:54Z2024-09-27T03:38:54ZHi. 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:54ZJDBC Connection Error - #sql6631_3dd5e99_1a' is full2024-09-26T19:50:19Z2024-09-26T19:50:19ZHi,
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:19ZAlter view on a different database in scheduler job2024-09-26T12:42:09Z2024-09-26T12:42:09ZHello,
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.
Thanks2024-09-26T12:42:09ZProblems with Cloud Storage and Denodo â?? Any Advice?2024-09-26T08:32:45Z2024-09-26T08:32:45ZHello 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:45Ztypos and errors in systemd scripts2024-09-25T16:29:18Z2024-09-25T16:29:18ZHi,
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 regards2024-09-25T16:29:18ZPBI - Refresh error message2024-09-24T19:35:19Z2024-09-24T19:35:19Zi 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