Q&A

How to access views in denodo from tableau having user as admin
answered 30-06-2020 06:30:03 -0400

i am using denodo express version and i have only one user and that is admin. how can i grant permissions to the databases inside that ussername. i am not able to see any tables under the database name i mention in tableau.

Answers: 1

Port Database
answered 30-06-2020 04:51:11 -0400

The JDBC URI for my oracle database is jdbc:oracle:thin:@host:port:database and when i try to put jdbc:oracle:thin:@host:port:database:1521:xe it doesnt work

Answers: 1

Create base view from Essbase using embedded
answered 30-06-2020 03:40:58 -0400

Hi, I'm trying to create a base view from Essbase 11 using Denodo, however I'm not able to see the Dimensions and measures from the visual mapper view. I can see the cubes but when I click the plus below it spins and then shows nothing but the cube nam...

Answers: 1

#essbase #embedded #MDX

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

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