Q&A

Connect to SQL Server Stored Procedures in Denodo
answered 03-10-2022 17:59:35 -0400

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

Answers: 1

SQL

Intermittent Failure of Base View with Timeout
answered 03-10-2022 04:39:42 -0400

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

SQL

Running Queries
answered 30-09-2022 08:14:57 -0400

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

Answers: 1

Metadata

Issue Masking JSON data with Denodo
answered 30-09-2022 03:05:12 -0400

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

Data Mask

Create Base View from Query and "@" symbol
answered 30-09-2022 02:39:24 -0400

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

dendoo

specifying the adapter for a jdbc datasource from VQL (as opposed to: from the admin tool)
answered 28-09-2022 20:20:07 -0400

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

JDBC

REST Webservice as DataSource with optional parameters
answered 28-09-2022 08:31:00 -0400

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

REST Parameter REST Webservice JSON Datasource DataSource

create_datetime >= '@LAST_REFRESH_DATE' in incremental cache not delegated to the source
answered 28-09-2022 05:59:32 -0400

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

Delegate Incremental Cache pushdown

Sending parameters to a Denodo REST endpoint in the body of the request
answered 28-09-2022 02:59:11 -0400

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

LIKE is not working as expected
answered 27-09-2022 12:11:48 -0400

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

NOT LIKE REGEXP_LIKE Like