Latest Activity

code

ORACLE TO VQL

I need to converter this TO_CHAR(9999, 'fm00000') for a vql. Is that possible? Thank you. Regards

code

require guidance on creating new views in Denodo

require guidance on creating new views in Denodo. We are aggregating data from old and new version of RAMOS (basically from two databases) into one source domain and building views on top of that for our downstream systems to consume. Can you suggest t...

code

remote table

https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/remote_tables/remote_tables Question 1: does Denodo express 8.0 has this remote table feature. Question 2: in licensed version of Denodo 8.0, can remote table fetaure write data to AWS S...

code

Unable to connect to vdp services with CSRF token validation errors

denodo 06:24:27.43 INFO ==> Starting Design Studio [SSO] 6320 [RMI TCP Connection(2)-127.0.0.1] INFO 2024-04-10T06:24:35.307 com.denodo.webapp.security.sso.DenodoSSOWebApplication [] - Starting DenodoSSOWebApplication v8.0.7 using Java 11.0.8 on d...

code

first of current year

how do I pull first of current year and forward? for example, when the date is currently 1/1/24 to 12/31/24, I always want to get results from 1/1/2024 and forward.

code

Unexpected error creating a connection

hi team, When attempting to connect to the data source, we encountered an error. Could you please advise on the potential issue and provide a solution? Unexpected error creating a connection: Failed to authenticate the user ctris-prod.rps-co-sqldw@gsk....

code

Allow logging all received requests in the Scheduler REST API.

As mentioned in the enhancement #78114, we can now add logger to all received requests in the Scheduler Rest API. How can we configure this functionality ? And for the logs, are they stored in files ? Thanks

code

UDF ReadBinary

Hello Denodo, I'm currently facing a blocker while attempting to migrate a User-defined function from SQL Server to Denodo. I'm unsure how to convert the script into Denodo-compatible format. I've tried following the guidance provided here: https://co...

UDF
code

Unable to deploy REST web service

Hello, I am working on creating a REST Web Service and am trying to deploy the web service but I am getting the error: "web service was not successfully deployed by the web container". We did review the vdp.log file and didn't find additional informat...

code

How to deal with BLOB in Denodo?

Hello Team, I have a situation that I imported a base view from SAP table. But there is a column which data type is RAW in SAP. After creating base view in Denodo, the type of such column convert to BLOB. If I use cast('text',column) when creating deri...