Latest Activity

code

PL\VQL

Hello Everyone, I'm currently exploring the capabilities of Denodo, and I'm particularly interested in the use of PL/VQL. I've checked the official documentation, but I have a few questions and would appreciate any insights or guidance you can provide...

Denodo stored procedure

code

Can I return join conditions and filter conditions programmatically?

For example, I can use a predefined stored procedure such as column dependencies to get a field calculation expression. Are there are any stored procedures that provide access to the join conditions and where clause conditions in the dependencies of a ...

Denodo stored procedure Filter data lineage join

code

Is there a way to create Stored Procedure in Denodo from SQL Server Parameterized Stored Procedure

Is there a way to create Stored Procedure in Denodo from SQL Server Parameterized Stored Procedure ?

Denodo stored procedure

code

How to get direct view dependencies ?

Hi We are currently using the denodo stored procedure viewdependencies() to obtain the dependencies of a view. However, our requirement is to obtain the list of views from database A, having direct dependencies in database B. By "Direct" dependencies...

Denodo stored procedure

code

Getting a stored procedure via VQL

Is there a way to get the stored procedure for a view / table created in Denodo via VQL? For example, I have a view called 'p_raw_data' that is created using the following procedure: CREATE OR REPLACE VIEW p_raw_data FOLDER = '/0. raw data' AS SELECT ...

VQL Denodo stored procedure

code

How to search for / list in Denodo columns (of a view) that make use of a certain function?

How can I search for / list in Denodo all columns (of a view) that make us of a certain function? For example, I would like to list all columns that make use of "getdaysbetween"?

Denodo stored procedure Metadata Catalog

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

code

Create view from the predefined Denodo stored procedures

How do you create a base view from the predefined/out-of-the-box Denodo stored procedures? I do not see them listed in the element tree although I am able to return results as well as list the procedures via the VQL shell query.

Denodo stored procedure

code

List Procedure Jar Dependencies

Hi I am looking for denodo metadata views which can give relationship of user defiened stored procedures and Jars with version. I have used the "LIST JARS" catalog function. This function returns the JAR name and stored procedure or functions of that ...

metadata store Denodo stored procedure Stored Procedures

code

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