Q&A

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

getting PuTTY X11 proxy: unable to connect to forwarded X server: Network error: Connection refused Can't connect to X11 window server using 'localhost:10.0' as the value of the DISPLAY variable. while unset the value of DISPLAY
answered 10-06-2020 07:46:04 -0400

Please help

Answers: 1

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

Nothing is opening after running ./denodo_platform.sh
answered 09-06-2020 05:24:15 -0400

what to after runnning the command denodo_platform.sh its opening nothing..and no errors are there.

Answers: 1

Cache copy from one environment to another
answered 09-06-2020 02:35:27 -0400

Can we copy the cache table of denodo from one envirnoment to another envirnoment . We are using netezza as the backend. if yes , how this can be achieved.

Answers: 1