Latest Activity

code

Connect to SQL Server Stored Procedures in Denodo

Need help on connecting to SQL Server Stored Procedures in Denodo and then access it in PowerBI Desktop.

SQL
code

Intermittent Failure of Base View with Timeout

We have a view that works sometime, retrieves the selected sql table and delivers, then, at random times, takes over 5min and times out with a failure. The name of the view that fails to complete contains the phrase: perf_updown_capture_chart_5yr. The ...

SQL
code

Running Queries

Do we have any metadata procedure to check running queries in Denodo ?

code

Issue Masking JSON data with Denodo

I am facing issue to mask data where the source is JSON file using Denodo. Which Steps I did : I connected JSON file and create BaseView on that. Then Flatten the BaseView. Then Create Role and Add Privileges on Role Level. Next create User and Assign ...

code

Create Base View from Query and "@" symbol

how do I escape or otherwise use an Oracle database link in a Create Base View from Query? Example: select * from mytable@dblink

code

specifying the adapter for a jdbc datasource from VQL (as opposed to: from the admin tool)

When creating a jdbc datasource via VQL with a driver from lib/extensions/jdbc-drivers-external/... it seems that always the generic adapter is selected. However I want to control the adapter. Is that possible via VQL or in any other way programmatical...

code

REST Webservice as DataSource with optional parameters

I am using a REST Webservice as a Datasource. To get the data, the Webservice GET function takes three Parameters "accountingClientId", "customerId" and "invoiceId". The first two are mandatory, the third is optional. I managed to do this by using ^Exe...

code

create_datetime >= '@LAST_REFRESH_DATE' in incremental cache not delegated to the source

I created a baseview over a cTree Datasource. I then enabled full cache, which works fine. Finally, I would like to enable incremental caching. I set the condition to create_datetime >= '@LAST_REFRESH_DATE' When I run a query, the execution trace sh...

code

Sending parameters to a Denodo REST endpoint in the body of the request

I have created a REST API(GET) in Denodo and want to accept parametrs in the body of the request rather than the URL. Is there any alternative other than to use POST menthod and override it with "X-HTTP-Method-Override: GET"? I'm using Denodo 8.0. Tha...

code

LIKE is not working as expected

I am running this code on a Denodo database, SELECT TRUNC(tran_dttm) as dt, substr(device, 1, 3) AS tech, SUM(out_qty) AS moves FROM database.table WHERE facility IN '****' and device regexp_like '^P.*' AND tran_dttm >= DATE '2020-09-26' AND tran_d...