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.

Desc role with a rolename having special character(hyphen)
answered 11-06-2020 03:23:00 -0400

Hello, When I am trying to run the describe role statement (Desc role role-name) I get an error as, Syntax error: Exception parsing query near '-' I tried executing the statement (Desc role 'role-name') but got the error as, Syntax error: Exception p...

Answers: 1

Access and Role Roles DESC

admin login
answered 10-06-2020 14:51:23 -0400

Unable to login with admin user to Denodo VDP Administration Tool using RDP. Error- authentication error. The username or password is incorrect. just tried to login with default settings which is working for others but not for me.

Answers: 1

denodo 8.0 beta installation Solution Manager port issue
answered 10-06-2020 13:32:10 -0400

Hi, Post installation of my solution manager whenever we start the port of solution manager as soon as it started running we got error 'Unexpected error'. When we accept the pop msgbox of unexpected error message accept button, the solution manager po...

Answers: 1

Run a job if one column from a CSV file is Y
answered 10-06-2020 08:11:09 -0400

I have a job that cached a base view. And I have a CSV file that is similar to this: origin active SAP N Oracle N DB1 Y DB2 Y DB3 Y I would...

Answers: 1

Job scheduler Conditional Job Run job

Unable to create a base view when my query has group by clause
answered 10-06-2020 04:48:02 -0400

Hello; I am using a query to create a base view in Denodo using the 'create from query' option. My query contains a group by clause and I receive the below error. Error executing sentence: Error executing sentence: com.denodo.util.exceptions.Internal...

Answers: 3

Error executing

how to do the transpose columns to rows as two separate columns
answered 10-06-2020 04:27:10 -0400

Hi All, I have to do transpose data columns to rows like below currently data is showing like this: ID date Q1 Q2 1 01-03-2020 00:00 6 9 2 13-03-2020 00:00 7 8 Expected output: ID date Questions Answers 1 01-03-2020 00:00 Q1 6 2 01-03-2020 00:00 ...

Answers: 1

DENODO COLUMN_DESCRIPTION

Azure SQL DB connectivity with Denodo 7.0
answered 10-06-2020 00:00:39 -0400

Hello Team, I have a requirement where I have to consume tables in Azure SQL DB in Denodo via API. Means we want to use API exposed from SQL DB and using this we need to connect with Denodo. Is this possible and anybody has tried this, if yes, kindly ...

Answers: 1

Azure SQL DB

Trigger a job to run every day at 4am
answered 09-06-2020 11:13:10 -0400

I am having trouble figuring out the format required to use the Cron expression to trigger a cache to be exected every moring at 4am US EST. Can someone provide guidance? It is hard to understand the documentation.

Answers: 2

scheduler daily triggers

Can Denodo connect to Azure SSAS?
answered 09-06-2020 08:07:57 -0400

Can Denodo connect to Azure SSAS? If yes, Do we have in-built drivers for the same or need any external drivers? Is there any documentation on steps to connect Denodo to Azure SSAS?

Answers: 1

Azure SSAS DataSource