Latest Activity

code

Finding a folder in GET_VIEWS() with a partial name

Hi all, How do I find a view in a folder based on a partial name of the folder? For example: SELECT name FROM GET_VIEWS WHERE input_database_name = 'database' AND folder='/%derived%' Some of my databases have views stored in say: Derived Views ...

code

SSH Custom wrapper

Hello, How do I create custom ssh data source? I want execute a script as a baseview. https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20SSH%20Custom%20Wrapper%20-%20User%20Manual In above community site link, does not ta...

code

Cache tables storing multiple cache records

Refers to Denodo 7. One of my cache tables stores multiple caches, although it is set up to invalidate all rows. Only when calling 'clean_cache_database' the invalid rows are being removed and the table gets cleared. Other very similar cache tables nev...

code

Follow-up Dataiku Denodo Connection Question

I have a follow up question regarding the responseI received below: In order to access Denodo from Dataiku, I will follow the below steps: As a first step, I will copy the Denodo JDBC driver denodo-vdp-jdbcdriver.jar residing in the folder <DENODO...

code

Dataiku Connection to Denodo

A business user wants to use Denodo as a data source for Dataiku. How do I set up a connection to allow Dataiku to access Denodo?

code

About Log4J zero-day vulnerability

Greetings here. I've been trying to find whether or not Denodo is affected by CVE-2021-44228 https://nvd.nist.gov/vuln/detail/CVE-2021-44228 but i could not find anything. Can anybody here please confirm if that's the case, if you are looking into it ...

code

How to pass the API key to this API

Hi, I am working on pulling the data from followign API and i need help in how to pass in the API key in the URL? URL https://mymarketnews.ams.usda.gov/mymarketnews-api/authentication I am using this URL in the JSON data source and aslo using the API...

code

Using OFFSET, FETCH, and LIMIT in an Integration View

I am trying to limit the volume returned by a view for testing purposes. I have tried using FETCH or LIMIT. Let's say I have a dataset that has groups A, B, and C and I only want to return two records for each group (I don't care which two- I'm only co...

code

Getting Year Value : 1 through getyear function for date field in HANA where the date field is null.

We created a denodo view on top of HANA view where we tried to use getyear function for a date field. That field is also getting null values and also date values. For date values the year is properly displayed but for date values which are null it is d...

code

OAuth2 in RESTful services

Is OAuth2 authentication supported for RESTful services as like its available for GraphQL? We have some extened querying requirements which GraphQL (for which we use OAuth2) doesn't seem to support. But RESTful services as per documentation support on...