Latest Activity

code

Issue with source refresh in base views

Hi I had a source which was then updated with the connection details and credentials. After updating the connection details when i am trying to refresh base views i am getting the following error: ERROR WHILE REFRESHING BASE VIEW Unable to load informa...

code

Connecting MS SQL Server through Denodo Testing tool throws error.

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

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...