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.

How to grant privileges
answered 29-06-2020 10:38:05 -0400

i was executing the grabt privilege command on the VQL.it says error in the query. How to grant privileges in denodo VDP..and also can i set privileges in express version..i can see the option for user/role management is disabled under administration ...

Answers: 1

Returning an existing compound type from executeReturnType
answered 29-06-2020 09:43:17 -0400

I have a bunch of complex compound types defined via CREATE TYPE syntax. Can I use them as a custom function return type, that is, return this type from executeReturnType()? E.g. something like this: @CustomExecutorReturnType public CustomRecordTy...

Answers: 1

Custom Functions Compound Types

Error: Invalid number format for port number
answered 29-06-2020 09:14:55 -0400

I'm trying to make the DEN70EDUD1001VID01 - Data Sources. JDBC module and i am unable to establish connection. Here is the message : Unable to establish connection : invalid number format for port number. I need help, Thanks

Answers: 3

Parameterized View
answered 29-06-2020 07:30:40 -0400

Hi, I have two different data souce connected in Denodo (one is Netezza and one is Oracle). I have created one baseviews in both the sources using query.(i.e. net_baseview and orc_baseview) net_baseview has some paramteres (start date and end date an...

Answers: 1

Paramaterised Query

Unable to see views in Tableau
answered 29-06-2020 07:20:40 -0400

I am using denodoexpress version 7. I have made a successful connection through tableau..but i cannot see any tables under the database. What could be the reason? Also can i connect tableau with denodo express version?

Answers: 1

Authentification Error
answered 29-06-2020 06:58:49 -0400

I am unable to connect VDP tool, facing authentication error: Local authentification with domain not supported.

Answers: 1

Denodo active - passive HA env
answered 29-06-2020 06:40:49 -0400

Hi, We are using denodo 7 with latest update 20201003. We have got one production server which is in use but need to add another server to create active-passive HA scenario. Can you please explain the step by step process? will it require any downtim...

Answers: 1

Incremental Cache Stored Procedure times out after 80 seconds
answered 29-06-2020 06:16:49 -0400

We are running the incremental cache stored procedure to insert/update records since the @LASTCACHEREFRESH. The procedure continues to fail with a generic error 'Finished with error: ERROR executing query update of cache [Rows updated in cache: 0].'. ...

Answers: 2

Incremental Cache Cache

Where is the incremental cache jar located in the Denodo program files?
answered 29-06-2020 06:07:22 -0400

The instructions to setup an incremental cache reference the .jar denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar. Where is this jar located? I cannot find it anywhere in our program files for our installation of Denodo 7...

Answers: 2

Cache

Metadata repository and cache repository on same derby instance or different ?
answered 29-06-2020 04:44:31 -0400

I understand Denodo uses Apache Derby (by default) to maintian caches, to maintain its own metadata and also to store metadata for diagnostic & monitoring tool. The question is, to store these three kinds of data, does it use the same instance of D...

Answers: 1

metadata repository