Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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

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

Heap Space error while importing .jar
answered 09-06-2020 02:29:36 -0400

Hi, While trying to import the jars to install the denodo customwrapper, I obtain the error "Java Heap Space". How can I solve this? Regards

Answers: 1

extension Java Heap Space custom wrapper