Latest Activity


Salesforce object name from denodo base view -Stored procedure

Which stored procedure can be used to get the source object name for salesforce baseviews .I cannot use GET_SOURCE_TABLE as it gives the result only for jdbc connections?

Base view Stored Procedure Salesforce


Issue using EXECUTE in vql stored procedure

Hi Denodo Team, I'm using the Denodo Design Studio Version 8.0 20230301 and trying to create a VQL Stored procedure using the EXECUTE command as described in the user manual :

Stored Procedure


input_privilege column Missing in get_elements() store procedure

we have two denodo installation with same version(8.0.20220126) in two different machines. If we call get_elements() store procedure from machine 1, we getting 24 columns in resultset. But when we call the same get_elements() store proc from machine 2,...

Stored Procedure GET_ELEMENTS


Is it possible to connect to Oracle Stored Procedures?

Trying to create base view from an Oracle Stored Procedure... following message appears "Unsupported type PL/SQL RECORD type for database: Oracle Stored Procedures". Anyone has solved this?

Stored Procedure Oracle


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


Create Base View for Oracle Function that returns Table Type

I am trying to create a base view on a Oracle function that returns data type - TABLE Trying this from the normal flow gives error : "Unsupported type TABLE for Database : Oracle Stored Procedure" How can i create this using a "Create Base View from VQ...

VQL VQL Base view Custom Functions Stored Procedure Oracle


Need help creating a Base View from a SQL Server Stored Procedure

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Base view Create Base View Stored Procedure SQL Server


Creating A Base View On Snowflake Stored Proc/ Multiple Statements

Hi, I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs. What I am trying to do is: Run the stored proc Capture the result of the proc The Snowflake statments are like these: -----CALLING ...

snowflake Base view Create Base View Stored Procedure


Create base view from exist stored procedure at teradata source

Hi, please I have stored procedure exist at teradata source and I need to create baseview using this stored procudre , so I tried to make base view by using create from sql query and type call pocedureName() but error appears " [Teradata Database] [Ter...

Base View descrptions Stored Procedure Teradata


Provide access to SINGLE view to MULTIPLE roles

Hello team, As we know, in Denodo we can give a view level access for a role. I have a situation where I need to give access to a SINGLE view to MULTIPLE roles(around 30). The procedure is to select each role, click on edit in the database and give wh...

Denodo stored procedure database assign privilages Base View descrptions Access and Role Stored Procedure VQL Role Role and User Management Roles Users