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

Query Permissions by Object
answered 15-11-2017 02:32:50 -0500

Is there a way to query Denodo's catalog to return a list of roles or users who have permissions on an object?

Answers: 2

VQL Views Permissions

Same wrapper is being assigned
answered 14-11-2017 11:36:44 -0500

Hi Experts, I have table which is available in multiple sources (I mean exact same name in different db's), I noticed same wrapper is being used for both the tables. Is there a way to avoid happening this ? and what are all downsides with this ? Tha...

Answers: 6

Wrapper

'redirect_uri_mismatch' error
answered 14-11-2017 11:00:29 -0500

After clicking on "Generate the authentication URL" I am getting an 'redirect_uri_mismatch' error. I am leaving redirect_uri as default. Is the problem because of that?

Answers: 6
Related to: How To Integrate the Google Drive API in Denodo

oauth Google Drive API redirect_uri_mismatch

Denodo base views not accessible
answered 14-11-2017 04:30:51 -0500

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Answers: 1

Missing Base view

Views not accessible
answered 14-11-2017 04:27:26 -0500

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Answers: 1

Missing Base view

Denodo DataSource Class
answered 10-11-2017 14:41:29 -0500

We are trying to connect to Denodo through a JDBC client. What is the data source class name that should be used to connect ?

Answers: 2

Caching with DB2
answered 10-11-2017 07:27:59 -0500

I tried to Join a DB2-View and a View that is cached in DB2. The both Tables are in the same DB2-Database. I hoped that denodo Pushed the Join in the Database. On the Execution Plan I can see that the two Tables are selected and the join is done in de...

Answers: 3

Request for first Sunday of every Quarter
answered 10-11-2017 07:20:51 -0500

Hi , Could anyone help me with the expression to get the first Sunday of every quarter and +7 days from that date? Thanks.

Answers: 1

how to switch to different schema in Denodo
answered 10-11-2017 06:59:12 -0500

Hi Team, Please help... how to switch to different schema in Denodo. below is the scenario: I am connection Oracle Database(JDBC connection), once i connect..I will see below schemas and all schemas have same tables and columns stracture. UD1234(DB nam...

Answers: 1

Filter on a Rank function
answered 10-11-2017 05:17:08 -0500

Hi team! I'm facing a common scenario using the Rank function and need some help. Below is the sentence I'm using, basicaly a Rank function with a Partition and Order by conditions: rank() OVER ( PARTITION BY xx_fa_deprn_summary.asset_id, xx_fa_deprn...

Answers: 3

RANK Function #Analytic function