Need help on connecting to SQL Server Stored Procedures in Denodo and then access it in PowerBI Desktop.
Answers:
1
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 ...
Answers:
1
Do we have any metadata procedure to check running queries in Denodo ?
Answers:
1
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 ...
Answers:
1
how do I escape or otherwise use an Oracle database link in a Create Base View from Query? Example: select * from mytable@dblink
Answers:
1
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...
Answers:
3
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...
Answers:
1
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...
Answers:
1
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...
Answers:
1
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...
Answers:
1