Latest Activity

code

SQL SAP HANA vs VQL Denodo

Hi, I have the below SQL SAP HANA query, how would I interpret this in Denodo? I want to get the time difference in hours between a timestamp constructed from date and time columns in the table. Can you help? SQL SAP HANA : ROUND(SECONDS_BETWEEN(TO_...

code

Challenges in Hybrid Mode

Hey, I am new to Denodo.We are trying to position Denodo as part of Data Platform Porposal. We are trying to migrate an existing platform from on-prem. As per the current thoughts there are two options Target Platform will be a hybrid one - Azure ...

code

Detect deletion changes made by the user

Dear team, I have a database - MyDb and it contains base views and derived views. However, today morning I noticed that all the base views and derived views are deleted. I want to be able to track who deleted the views because lots of efforts were ta...

code

Updating the Denodo Monitor

Recently we have update Denodo Platform 8.0 and Solution Manager 8.0 to Dneodo Update 20240309. We noticed after applying the updating in the Denodo Platform 8.0 that we got a warning message that the update versions are different for the VDP and the D...

code

Finished with error: Error executing sentence: null

Dear all, I am getting this error "Finished with error: Error executing sentence: null" when executing a derived view. The select statement in the view executes perfectly fine. But when the query is created as a view then shows this error. Appreciate...

code

What should be the role in Denodo VDP to be able to 1. Create a tag 2. Alter tag to assign/remove a view from tag

Hi, We are trying to automate and restrict user to add a remove a tag from the view. What are the roles required for teh uesr to be able to do that. WE want to avoid admin role access.

code

create datasource via vql

I am running denodo v8. I want to use vql to set up a simple datasource (via jdbc) to a postgres database. Following the guidance at https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/generating_wrappers_and_data_sources/creating_data_sour...

code

ODBC connection with SSIS Import and Export Wizard

Hi, I was able to create an ODBC connection to Excel and can see all base views and all derived views. Then I tried to connect to the same data source but this time with SSIS Import and Export Wizard. The connection is successful but I can only see bas...

code

Querying from Custom Policy

I have created a custom policy. I understand that the fields and other information about the live executing query can be extracted using the context object. However, what is the appropriate way to query other objects in the vdb in order to bring data r...

code

dEVELOPER

How to create a data source in denodo