Q&A

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'

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

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

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.

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

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

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