Latest Activity

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
code

syntax for context variables

I have a base view with a parameter, I cannot seem to select from that base view in a VQL window. CREATE OR REPLACE WRAPPER JDBC bv_createview FOLDER = '/baseviews' DATASOURCENAME=admin.ds_denodo SQLSENTENCE='select creation_vql from GENERATE_VQL_TO_...

code

Download Denodo Express

i need the linke to Download Denodo Express , because this link not working well https://auth.denodo.com/user-management/express-register