Q&A

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

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

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

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

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

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

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

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

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.

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