Latest Activity

code

Refreshing remote tables using Scheduler

Hi Team I want to know that how to refresh remote tables from scheduler. I have tried vdp job option but not able to get the output. Also, how to call stored procedure for create remote table in parameterized query option in scheduler. Thanks

code

Returning data with a max date (minus 1) for weekdays only

Hi, How do i amend the following code to execute daily but exclude weekends as the load_date will never have a weekend date. table.load_date = (SELECT addday(max(load_date), -1) AS addday FROM table) This code executes fine, but each Monday it will...

code

Table name at the runtime

Hi We have requirement to dynamically query a table , whose name is stored in another table.. E.g. View 1 has - Table,Date View01012022, 01/01/2022 View02012022,02/01/2022 View03012022,03/01/2022 First query View1 to get Table name .e.g View01012022...

code

Base view issue with MongoDB custom datsource

HI Team, I'm using Denodo 7.0. Created a MongoDB connection with custom datasource. Had a requirement to create a base view by selecting few fields from MongoDB collection. suppose collection 'abc' having 10 fields in it and we need to create base vi...

code

Read only access in Scheduler

Hi In Scheduler is it possible to only provide view permission without execute access to users on particular project. The "Read access" current allows user to execute every job in the project Thanks

code

Split function in Denodo does not work! (second way) Regex for complex string in Denodo

I am basically trying to split the following string in Denodo and trying to create new columns in the database for each value. my_string = ABLMNC_154342_O_UW_UA-UCOU_SMC The problem i am facing is when i split the string, Denodo creates an arra...

code

scheduler job dependency set without adding cron expression in trigger section.

we need to set the job dependecy without adding cron expression in scheduler as the job is going to start with dependency via scheduler api using other tools.

code

How Caching Works with Denodo?

Hi, How Denodo Cache the data when fetching it from Data Source? What's the Space it consume while caching? What's the retention period of Cache, when it flushes the Cache? Can we define the data that needs to be fully cache, partial cache or no cach...

code

Base View schema doesn't get updated automatically if the payload changes

Hello, With the JSON data source, if I have a base view created initially; which is created by Denodo based on the JSON response payload it receives at the time of view creation, the schema of the created view is decided at this point. Now in future,...

code

Import Roles from LDAP: Does it allow for nested groups?

Hi, I have imported a role from my LDAP server to use within Denodo. However, the LDAP group I imported has another group in it. Does Denodo allow for nested LDAP groups to be used within Denodo? Or do I have to also import the sub-group, too? Tha...