Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Diagnostic & Monotoring Tool Query stuck
answered 06-02-2020 07:26:40 -0500

Hi, I have a query from 29 January supposedly running in Diagnostic & Monotoring Tool today is the 5th of February, even though the query doesn't really seem to be executing since the number of rows isn't going higher, the CPU usage seems to be at...

Answers: 1

Why can I not see any Revision Elements in SMAT ?
answered 06-02-2020 07:20:06 -0500

When using SMAT to create a new revision when I click on the Revision Element tab I dont get any elements displayed

Answers: 1

sspi continuation error the logon attempt Denodo 8009030c
answered 06-02-2020 06:36:36 -0500

Hello, A user is trying to connect to power BI using ODBC driver and while trying to connect she is getting the error as "ODBC: Error [08001] sspi continuation error the logon attempt failed Denodo 8009030c". There is no issue with the network trying ...

Answers: 1

#powerBI connection #Denodo-PowerBI EXCEL ODBC Driver DENODO

Queue for failed HTTP Posts
answered 06-02-2020 03:29:37 -0500

Hello pals, I'm trying to solve the following problem: I want to read and insert information on a database that is not always up. The full cache approach will solve the read problem. On the other hand, I have been looking for a queue-like solution, ...

Answers: 1

#Cache #Compression #HTTP #Post #Rest_API #webservice

View statistics questions
answered 06-02-2020 00:08:36 -0500

I recently inherited Denodo admin duties and am investigating a scheduled job which is failing. The job gathers a list of all base tables in Denodo, then runs the following VQL: CALL GENERATE_SMART_STATS_FOR_FIELDS('SMART_THEN_ATSOURCE_THROUGH_VDP','B...

Answers: 5

generate_stats search methods VDP resultset Statistics timeout

Sort Merge Execution Strategy Slow Execution Time
answered 05-02-2020 08:23:11 -0500

I currently have a derived view, say D1, that is a join between another derived view, D2, and a base view, B1. The join has two conditions: D2.username = B1.username AND D2.date = B1.date. In the joined view D1, I have a where clause stating that D2...

Answers: 1

Downloadable Version for Mac OS Sign SierraD
answered 05-02-2020 07:13:20 -0500

Hi All, Please is there a version for Mac OS High Sierra?

Answers: 1

Restricting "Create view" and "Write" privilege to a view
answered 05-02-2020 07:07:41 -0500

Hi all, Is it possible to have a role with Connect and Execute/Metadata privileges only (read-only) + Create view and Write privileges on a single view from the virtual database? The use case is a view that dynamically create a base view through a De...

Answers: 1

privileges

Parameter push-down issue
answered 05-02-2020 06:35:16 -0500

I am facing an issue when using the parameter in where condition of the top-level views. The query is hierarchical and has five levels. I created a parameter for the top-level view for a key element "key_id" that is used to join several tables. Then...

Answers: 2

parameter views branches View Parameter entry

Granting access to virtual database without access to VDP
answered 05-02-2020 05:52:27 -0500

Hi, I would like to know if it is possible to grant read access to a virtual database to an user without granting him access to the Virtual Dataport administration tool? i.e. the user can execute view from a client tool as Excel, but cannot directly ...

Answers: 1

privileges Access and Role