Latest Activity
Dear team, I have a database - MyDb and it contains base views and derived views. However, today morning I noticed that all the base views and derived views are deleted. I want to be able to track who deleted the views because lots of efforts were ta...
Does Denodo have a function that is equivalent to the Table.AddIndexColumn Power Query function that one can use in Power BI? See: https://learn.microsoft.com/en-us/powerquery-m/table-addindexcolumn
Hello experts, We have been told that there are several million connections open from Denodo to an FTP datasource/baseview. Where can we view these connections in Denodo? The getsessions() seems to display just the incoming connections/queries. Please...
I have created a selection view in denodo where i have applied some transformations and while executing got the error stating function 'leftpad' cannot be delegated to this database. Redshift is the data source. lpad works in reshift but doesn't work ...
I found something when I tried executing the materialized table. After I create a table with primary key constraint, If I insert a repeated value the server is accepting and inserting two rows with same value even if primary key is specified? Can anyon...
###Connection using JDBC import jaydebeapi hostname = 'server name' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '####' password = '#####' path = '/C:/Users/abc/Desktop/Projects/denodo-vdp-jdbcdriver.jar' url = 'jdbc:vdb://'+hostname+':'+...
Hi, I need to use a case statement in Denodo view parameters. whenever a defaut date is selected (ex: 1900-01-01) it should fetch data based case condition(ex: current_date-1) else it should fetch data by given date. Ex: case when start_date='1900-01...
Hi Team, I need to know is there any generic function available in DENODO for SPLIT function which can be used for any of the views without depending on one single view/function. Example: In Oracle we do have below function which can be used in any o...