Latest Activity

code

Aggregate data via restful web service

I've seen this question asked a couple of times but last answered in 2017. Is there now a way to aggregate (e.g. sum) data via the restful web service? E.g. '...$groupby=category&$select=category,sumValue&$format=json'

code

Can denodo Support to recursive queries ?

Hi Experts, We have below requiremnet : Transaction records are available in multiple source systems and recursive query is needed to create unified transaction record. Hence There are multiple scenarios besides this where recursive feature is needed...

code

Setting up links, the link does not work without ?auth=login#/

Hello. In Denodo, it is possible to access each component directly through the vdp server, bypassing the solution manager. I use links where at the end is ?auth=login#/ eg :9090/denodo-design-studio/?auth=login#/ Is it possible to configure login witho...

code

JDBC source refresh

Is there any way to do JDBC SOURCE refresh in base views for updating the database name and connection details. We are using Azure SQL database.

code

refreshing remote tables

I have tried refreshing the remote table using scheduler>job>vdp In parameterized query, I used REFRESH <remote table base view> command. But it was not working.It is showing as complete but no rows were refreshed. Also, not able to save t...

code

Sourec refresh

We have created JDBC data source and base views and derived views on top it it. But there has come a need to update the server details and database name for which data source needs to be modified. after modifying the data source and trying to source re...

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