Denodo community Q&A RSS feed

Remote Table Issue

Wed, 03 Dec 2025 13:40:06 GMT

Hi , I am unable to create remote table in MySQL database ,my source table is in Azure SQL and want target database as MySQL ,please assist. Error : Cannot invoke "com.denodo.vdb.vdbinterface.common.clientResult.vo.descriptions.view.TableFieldVO.getFieldName()" because "tableField" is null Step 1 of 3: Created remote table 'xxxx' successfully. Step 2 of 3: Inserted 1234580 rows into remote table 'xxx'. Step 3 of 3: Cannot invoke "com.denodo.vdb.vdbinterface.common.clientResult.vo.descriptions.view.TableFieldVO.getFieldName()" because "tableField" is null Also please suggest if we can use remote table alongwith data movement option ?and also when to use cache and when to use remote table ?

Data-Movement

Tue, 02 Dec 2025 11:45:10 GMT

Hi , Before applying data movement do I need to calculate number of rows in each table and then determine large and small table ? Also data movement works by moving data from smaller table to larger table data source so in that scenario in order to enable data movement should I enable data movement option under small table or larger table under 'Options' tab of derived view ? Can data movement be applied on joining of more than two tables ?

java.sql.SQLException: For input string: "2025-11-18" on Data Catalog

Mon, 01 Dec 2025 12:19:50 GMT

Hi, I am encountering the following error while exporting results to Excel/CSV from Data Catalog when passing a date to the localdate parameter with the value '2025-11-18': `java.sql.SQLException: For input string: "2025-11-18".` However, I am able to download the same view without any issues from Design Studio. Kindly suggest a solution to resolve this error in Data Catalog.

errorhandling

Sun, 30 Nov 2025 08:42:16 GMT

Hi , How to do error handling in Denodo 8 when one of the source either JDBC or API fails and gives error.

simple question regarding certification

Sat, 29 Nov 2025 00:14:20 GMT

simple question regarding certification

custom Denodo File System Custom Wrapper - base view

Mon, 24 Nov 2025 14:41:59 GMT

Hi, I created a custom datasource using the following JAR: denodo-filesystem-customwrapper. I would like to create a base view, but I need some help. When defining the search method, I see that the constraints require parentfolder = and recursive = . I�??m not sure what values I should provide for these parameters. Could you please guide me on what they represent and how to set them correctly? Also, is it possible to use just the filename as a filter? Thanks!

Inconsistent Date & Number Formatting Between Design Studio and Data Catalog

Fri, 21 Nov 2025 12:26:17 GMT

Hi folks, We are currently facing the following two issues: **1. Date Format** We need guidance on configuring a consistent date format for all date_time columns. Our requirement is to display dates in the format **yyyy-MM-dd** across both Design Studio and the Data Catalog. At the moment, the same view displays different date formats in each tool. Additionally, if a timestamp column has a time component of **00:00:00**, we want it to display only the date (**yyyy-MM-dd**) instead of the full timestamp. Please guide us on how to configure this at a global or view level to avoid setting the format for each column individually. **2. Double Data Type (Decimal Digit Issue)** Our base tables contain several columns with the double data type. Most of these values do not have decimal digits. Design Studio shows them correctly, but the Data Catalog displays them with a trailing decimal�??for example, **564.0 instead of 564**. Although casting to int removes the decimal point, we have many such columns and applying this transformation manually to each one is not feasible. Kindly suggest a better, centralized configuration or approach to handle this formatting consistently across all views.

What version of Denodo 9.x supports GIT integration?

Fri, 14 Nov 2025 15:45:10 GMT

We are using Denodo 9.3 and want to know what version of Denodo supports GIT integration? We are using Azure Devops on prem. A lot of the documentation I find references the older tools from Denodo 8.0.

Denodo Rest API's security testing vulnerabilities

Tue, 11 Nov 2025 14:24:21 GMT

Hi Team, We are using the Denodo Rest API's to query the data via Kong gateway to securly transfer data to external vendor.As part standard API security testing using Invicti tool we found couple of vulnerabilities for these API's. 1.Misconfigured Access-Control-Allow-Origin Header 2.Missing X-Content-Type-Options Header 3.HTTP Strict Transport Security (HSTS) Errors and Warnings As pe these vulnerabilities , tool suggested few changes in app/web server config xml files but out team unable to fidn the these config files. Could you hlep to fix where is the webs erver config files to update. eg: tool suggested IIS7 X-Content-Type-Options: nosniff Strict-Transport-Security: max-age=31536000; includeSubDomains; preload Thanks in Advance. Regards venkata Gopireddy

Denodo 9 VDP Client

Sat, 08 Nov 2025 15:33:42 GMT

Does denodo 9 has VDP client, can it be installed on Win11 system?