Latest Activity

code

Why can't a user drop a wrapper ?

We have a group of users that have the permissions to drop and create their own views on their own virtual database. In order to facilitate automation, we provided the users with a base view that generates the VQL to create or replace the view by suppl...

code

Vdp-queries log generation

Hello Team, We are aware that Denodo logs are produced in two directories: DENODO_HOME/logs/vdp and DENODO_HOME/tools/monitor/denodo-monitor/logs (when Denodo Monitor is running). The file "vdp-queries.log" exists in both locations mentioned above. How...

code

Unable to establish connection : IO Error: The Network Adapter could not establish the connection

hi team (Unable to establish connection: IO Error: The Network Adapter could not establish the connection)it shows the previous error when trying to test connection in the training database it is not loading the data from oracle,the database url is jdb...

code

Is there an ISDATE equivalent in Denodo VDP ?

Hello. I'm trying to re-write a DB2 sql query which at some point uses the ISDATE function to validate a text value against a given date pattern , in order to verify that this text field contains a valid date: ADMIN.ISDATE(((LPAD(BTRIM((PRE.DAY)::"VAR...

code

Issue with rolling back transaction from exception in VQL Stored procedure

I am creating a VQL stored procedure, but it is not rolling back when I catch an exception. I am following the example provided here: https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_stored_procedure...

code

VQL STORED PROCEDURE/INTERFACE VIEW

Hi everyone, this is the SP that creates the view interface and it's intended to be created in the indicated database specified in the parameter. How can I do that? [quarta-feira 17:22] Diogo Goncalves - Passio Consulting CREATE OR REPLACE PROCEDURE c...

code

Can you query the cache for invalid or expired rows

Is it possible to query the cache of a view for the invalid or expired rows before you run the cache cleanup?

code

Check for other data sources type

Hello, This is very interesting but unfortunately it doesn't cover all Denodo data sources types. Would it be possible to check other sources such as: JSON WS XML CUSTOM (this includes Excel data sources). DF (delimited files) WWW

Related to: Automating the status check of data sources created in Denodo Virtual Dataport

code

Migrating from SSIS to Denodo

Hi Team, Please note that i am part of Denodo migration from SSIS. Kindly need some support on create a denodo package based on SSIS package. I am starting my new package in production, need some assistance.

code

Denodo server is not starting

Hi team I am unable to start most of the servers it says stopped when i start it(Data catalog and web tool servers) ,how can i fix this issue?