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 import column descriptions from MS SQL Server data sources?
answered 04-04-2019 08:34:26 -0400

Similar to the following article about Oracle: https://community.denodo.com/kb/view/document/How%20to%20import%20column%20descriptions%20from%20Oracle%20data%20sources?category=Data+Sources How does it work for MS SQL server to get the descriptions/c...

Answers: 3

base view fals when select granted on columns subset
answered 04-04-2019 08:01:57 -0400

Hallo Denodo Team I am experimenting with authorizations and permissions. On a mysql database I gave select grant to a user on a subset of a table's columns. I created denodo base views as an "unrestricted" user. When I log into denodo as the "restrict...

Answers: 3

Grant MySQL pass-through

Import base view to other VBD
answered 04-04-2019 07:47:08 -0400

When I try to import a base view of a VBD exported to a VQL to another VBD, I get the error: *Command: CREATE OR REPLACE TABLE bvcccasedefinition I18N pteuro ( caseid: decimal (sourcetyperadix = '10', sourcetypedecimals = '0', sourcetypesize = '22', s...

Answers: 3

How to get list of base views which are created from query?
answered 04-04-2019 07:21:07 -0400

I need to fetch list of all baseviews which are created from query. Kindly suggest how can we get the list in Denodo 6.0

Answers: 3

baseview created from query

Error setting up SVN source control
answered 04-04-2019 07:11:52 -0400

I am getting the following error when trying to create an environment in the VCS Management window: Error creating environment: error creating environment: Error while executing svn status: Cannot run program "svn" (in directory "C:\Denodo\Denodo Plat...

Answers: 6

admin denodo 6.0 VDP VCS SVN

Slf4j dependency conflict changing to "Insufficient resources to execute operation" when trying to connect Dremio as a JDBC datasource
answered 04-04-2019 07:04:38 -0400

Hi, I'm currently running Denodo Platform v7.0 on Windows. I'm attempting to connect Dremio as a JDBC datasource and running into errors when testing the connection. I have added the Dremio JDBC driver .jar file to a new directory in the {DENODO HOME...

Answers: 3

JDBC JDBC Data Sources

denodo express install issue
answered 04-04-2019 05:16:53 -0400

after i installed denodo express on linux and execute denodo_platform.sh, it is returning null on the command prompt. I am not able to open Denodo Platform Control Center. please advice.

Answers: 1

Get refreshed current state Job Information using the Denodo Scheduler Client API
answered 04-04-2019 04:26:30 -0400

In my Java Application, I trigger a Denodo Scheduler Job using the Scheduler Manager Factory, and on the Scheduler WebAdmin I can see that the Job got triggered, and the state changes from NOT_RUNNING to RUNNING. However,the belowschedulerManager.getJ...

Answers: 3

java java code

Analytic function row_number() is not executable when executing it over a subquery
answered 04-04-2019 02:24:01 -0400

Inspite of enabling the Delegate Analytic functions list in source configuration of a Oracle data source the below query is failing with error "Function row_number is not executable". select Department_id, total_sal, row_number() over(partition by 1 o...

Answers: 1

concatenate rows - same column
answered 04-04-2019 02:03:20 -0400

Hello, I am trying to concatenate data from the same column but on different rows for the same record. The column in question is one that contains notes and what I need to do is combine notes. Below is an example of what I am looking to do. TABLE ID S...

Answers: 4

concatenate