Latest Activity

code

How to use group_concat and order by functions for same column in denodo.

Hi , We are converting below string aggregation and within group (order by ) function to run in denodo. For that we have used group_concat function , If we use group_concat function for particular column then we are not able use order by function . s...

code

EXTERNAL DB DATA LINEAGE

Hi everyone, I would know if there's a way to retrieve the data lineage of views when you use an external DB for the data catalog metadata. If it is not possible, there's at least a fast and easy way to create and store a view with these information...

code

multiple ec2 instances

Hi Team, Denodo 8.0 Approach 1- Ec2 instance 1: VDP Ec2 instance 2: Scheduler Ec2 instance 3: DC Approach 2- Ec2 instance 1: VDP, Scheduler, DC what are the pros and cons of both approaches ? Thanks

code

create view using psycopg2

trying to create view in denodo but getting error : 'dict' object has no attribute 'name' I tried to create using cloud function but not working sample code: denodoserver_name = "xxxx" denodoserver_odbc_port = "9996" denodoserver_database = "xxxx" de...

code

Denodo JDBC Driver Issue

We are trying to connect Denodo with Tableau and Databricks with JDBC driver "denodo-vdp-jdbcdriver-8.0-update-20220815" and also the previous version of driver. Our current version of Denodo Installation is also the same "Denodo 8.0-20220815". But whi...

code

"Regular" users see "No Application Available" under Solution Manager.

What is the minimum role/privilege grants to allow a "regular" user to have the option to see and run Data Catalog or Design Studio from Solution Manager? Current users cannot choose any of these, but can go directly to the URL of these 2 applications.

code

Reg Expression Check in Denodo

Hi Gurus, Looking for help to find the regular expression for finding - Email Addres cannot contain more than 3 or less than 2 alpha characters after the last '.' I have tried len(substr(cont_detail_dscr , position('^^^' in REGEXP(cont_detail_dscr, '...

code

What role grant allows the VQL Shell option to appear under the Query dropdown in Data Catalog?

For users with an admin role the Data Catalog application allows you to run a VQL Shell under the Query dropdown. What is the minimum role/privilege grants to allow a "regular" user to be able to see that and run a VQL Shell query?

code

Identify all derived views using a specific function

We have a scenario where we are running into an IDMC bug that is loading all null values (for string columns) as blanks and 0 (for numeric columns). and wants to identify all derived views using functions handling nulls. Is there a way we can identify ...

code

how to prevent changed column names in baseViews from adding "_0"

I have several SQL Server tables where there are column names with spaces. The datasource shows the spaces, but the baseViews column names are created with no spaces and append '_0' to the column names. What configuration or setting can prevent the...

VQL