Latest Activity

code

Denodo Solution manager roles

Hi Denodo experts, Scenario below: In the Denodo Dev and Stage environments we have a developer called db_1_admin who is an admin on a specific Denodo db called db_1. In the Solution manager, we have provided the stage promotion admin role. Because of ...

code

Hiding columns that users cannot execute

I have implemented column level security on a view. As expected when the restricted uers executes select * from the view they get an error message that says that they do not have privileges on certain columns. However, the user can see the columns ...

code

LEAD function doesn't work in Denodo 8

Hi there, when I tried to use LEAD function in Denodo 8, the color doesn't change and the error shows the Function LEAD is not executable. From the documentation, the LEAD function is available in Denodo. What I have missed? Thank you!

code

Connecting to VDP with EF/ADO.Net

Hi, We want to use Entity Framework to connect to Denodo VDP Server. The documentation at https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/access_through_an_ado.net_data_provider/access_through_an_ado.net_data_provider shows that a...

code

MongoDB Atlas (through AWS)

Hello, I'm trying to connect a MongoDB Atlas cluster from Denodo through the mongodb-customwrapper. Reading the user manual about this custom wrapper, it seems to me that ony clusters "based" on Azure can connect to Denodo. It is correct? I'm using a...

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.