Latest Activity

code

Cache column name change

Hello Team, As we have a view for cache column "GET_CACHE_COLUMNS " here we can get the view and cache column mapping. My question is the cache columns are like field_1,field_2... Is there any setting or something were we can populate the view column ...

code

Pass timestamp to interface

I have a base view and an interface for the base view. In both the base view and interface one of the columns, ReportingDate, is defined as a timestamp. Using ODATA, I am able to invoke the endpoint and get back results. I can also add a filter conditi...

code

Enabling SSL/TLS in Denodo 8.0

Hi Team, I am in middle of Denodo 7.0 to Denodo 8.0 migration. We have to enable SSL/TLS in all modules of Denodo. I am refering to the below link in the pre upgradation tasks. https://community.denodo.com/docs/html/browse/8.0/en//platform/upgrade/pre...

code

Error editing resource manager rule: field not found 'roles' in view with schema

Hi All, When trying to create a rule in resource manager using roles.value condition getting error like below: Error editing resource manager rule: field not found 'roles' in view with schema Same seems to work in dev environment but not in UAT.

code

Split Comma separated string to columns

Hello I am trying to split a comma separated string to multiple columns . I am not able to find an easy method to do it using the available functions. Essentially I have a field called carmodel in the datawarehouse.It has multiple model separated by a...

code

Connecting Denodo to AWS Athena or AWS DynamoDB

Hi, Has anyone be able to connect to AWS Athena or AWS DynamoDB? There is already a question about connecting to Athena, but it is from May 2017. I am open to using third party drivers (CData, Simba etc.) if generic drivers will not work. Thanks!

code

pivot dynamically based on values?

Is there a way to dynamically create the headers for the pivot based on the values in the data? for example if I have a field that has a mapping type that can either be "sector" or "region" and then have a value by person. and end up with a cross tab t...

Related to: How to Pivot and Unpivot views

code

getElementDatabase() not working for Denodo 8.0/ Java 11

I'm creating a custom policy but getting an error when trying to use the Denodo method getElementDatabase(); The other methods DO work from my library imports (getQuery(), getElementName(), getCurrentUserName()) - but NOT getElementDatabase(). I was g...

code

Unable to connect to Denodo Open Sandbox

I am unabel to connect to Denodo Open Sandbox. I am using Denodo 8 Express. Your Sandbox URI is: //sandbox.open.denodo.com:9999/vdb_p8yhdf Getting below error. Connection Error : Check the host name and port number are correct, and thet client an...