Latest Activity

code

RBAC using Stored Procedures

Hihi, I’ve tried to implement a modular RBAC via stored procedures as shown in the code below. While the GRANT statements seem to work, the REVOKE statements on views do not. Could you please assist with this issue? Additionally, I would like to ext...

Custom stored procedure Access and Role

code

Stored Procedure Issue

So you know how when you want to insert variable in python is f"{variable_name}" For denodo I am unable to do so for the execute statement in custom stored procedures For instance the execute statements below would not work. What is the proper way of ...

Custom stored procedure

code

Denodo stored procedure with input parameters to execute vcs(dvcscommit) command:

When i execute below stored procedure: (view_path IN VARCHAR, commit_message IN VARCHAR) AS ( param1 VARCHAR; param2 VARCHAR; ) BEGIN EXECUTE 'connect database poc'; EXECUTE 'dvcscommit ''@param1'' LOGMESSAGE ''@param2''' PARAMETERS ( param1, param2 )...

automate git Denodo stored procedure Custom stored procedure dvcscommit Cursors Denodo 8.0 VQL Stored Procedure Error dvcs automate vcs

code

Can Denodo VQL send emails?

I created a view that tists the metagroups (roles) that have been imported into Denodo. I'd like to send an email to these metagroups whenever there is an expected outage (when upgrading), or when a Denodo restored to service when it unexpectedly goes ...

VQL Custom stored procedure email

code

Custom Stored Procedure get credentials of the caller

Hello, the username of the caller can be extracted via environment.getDatabaseProperty("CURRENT_USER"); Is there any similar way to get the credentials of the user. I would need them to call the Data Catalog via REST Requests. Thanks in advance

Custom stored procedure

code

Custom Script

How can i achieve this.. I am having couple of tables T1 with column C1, C2, and C3 T2 with column D1, D2, and D3 I need to look into a table T1 based on where condition (where C1 = 'ABC') and check if column C3 having value. - If so i need to pick...

Custom stored procedure custom script Stored Procedure

code

Data shows as NULL for my Custom Stored Procedure output

My custom stored procedure seems to be performing all the tasks but displays the results on the VDP administration tool failing with the below error from the vdp.log file: 6106888826 [Access(1692)-244-02.00-mojodb.customscorer810] ERROR 2021-08-11T13:...

Custom stored procedure

code

Denodo doesn't recognize local file within stored procedure

I have denodo platform 8.0 running on EC2 installed using cloudformation template as per the installation guide by Denodo. I am trying to create a custom stored proc which has to read a license file (locally saved inside /opt/denodo/denodo-platform8.0/...

Logging Custom stored procedure ERROR_HANDLING Custom Functions License File Denodo Jar

code

How to obtain the input parameters of the custom stored procedure in the overridden initalize() method?

We want to execute some refresh vql command and get back the response through jdbc connection. Is it possible to obtain the input parameters in the initalize() method like we do in the doCall() And how do we extract and return the response of said vql...

Related to: Executing VQL statements from a stored procedure

Custom stored procedure JDBC

code

Error while creating a project in Eclipse

Hi I'm trying to create a new project in eclipse after installing the denodo4e software successfully, but its giving me an error saying wizard cannot be started. Please help me on this as my teams development activities are getting delayed because of...

Denodo stored procedure Custom stored procedure