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

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.

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?
answered 12-06-2018 12:50:33 -0400

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Answers: 1

Parameterize slow query Parameter derived view Tableau

Denodo Model Bridge --> add-on license?
answered 12-06-2018 12:11:02 -0400

Hello, Does using Denodo Model Bridge require an add-on cost license? or is it available as a free tool with the existing Denodo license.

Answers: 1

Denodo Model Bridge

Partial Cache not working
answered 12-06-2018 09:20:31 -0400

I have created a derived view ('client') on the top of a Excel and partial cache mode is on. Now I am trying to check how partial cache works.Initially I have around 10 rows. I have also created a base view on the top of cache database. I am executing ...

Answers: 2

Partial cache with different where conditions Cache

Denodo Scheduler jobs Export issues
answered 12-06-2018 04:25:53 -0400

Hi Team, need your help on below question. I have a project name Its_dev under this project, we have few jobs like Project name: lts_dev(under this project, we have few jobs) job name 1: ABC Job name 2: CDE when i deployed first time into Prod environm...

Answers: 1

How to drop and re-create indexes, when updating Cache using BULK LOAD API nightly via scheduler
answered 12-06-2018 04:24:51 -0400

Hi, We have a scheduelr that updates the cahce of a very very large table around 120 million records on nighlty basis, using BULK LOAD API. With BULK load it expects to drop and recreate indexes, how do we achive this??

Answers: 1
Related to: Cache database size estimate

Cahce Index

VQL to Find List of Users that Belong to a Denodo Role
answered 11-06-2018 18:00:49 -0400

Denodo VDP 6.0 Hi, Can you please let me know a VQL query to find the list of users that belong to a role? I want to write a shell script with embedded VQL that will find the users in a role and add / remove members to the role. Regards, Subrata

Answers: 1

Roles Users

How to update admin pwd in Solution manager
answered 11-06-2018 13:35:19 -0400

How to update defualt admin pwd in Solution manager?

Answers: 1

solution manager install

Reg: About Denodo Tool:-
answered 11-06-2018 08:34:06 -0400

Hi Team. Good morning!!! I have a quick question Reg : Denodo Tool. So far I have been doing different type of scenarios in Denodo Tool whatever I did in sql before. But I didn't understand Why Denodo is called ETL Tool. Coz it has all sql functions ...

Answers: 1

REST Service query - select newest date row
answered 11-06-2018 08:33:23 -0400

We are using Denodo 6.0 on Windows 10 Desktop. We have a question about querying REST web service to narrow down multiple rows to a single row based on a date column. What would be the syntax in the query? In the following example, we'd like to get the...

Answers: 3

Filter Denodo Testing Tool REST Webservice

Allow Denodo Platfrom againt Firewall
answered 08-06-2018 07:41:08 -0400

I have published a REST Service using Denodo Express installed on a cloud server. I am able to access the webservice using web localhost:9090. But I am unable to access the REST service from my desktop using the web URL servername:9090. I have done the...

Answers: 1