Home / Q&A / All Questions

Q&A

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

Video not clear
answered 12-08-2021 08:19:38 -0400

Vedio is not very clear.

Answers: 1
Related to: How to connect to Azure Data Lake Storage from Denodo Platform

How to read Input parameters from HANA Calculated View in Denodo
answered 12-08-2021 00:00:47 -0400

Hello All, I am new to Denodo and we have a requirement to build Denodo API on top of HANA calculated view which is parameterised. When I selected the calculated view and created base query on top of it, I did not see any input parameters like we woul...

Answers: 1

How to apply text function on field that is used for search method
answered 11-08-2021 19:25:11 -0400

Hello, I want to apply a text function to a field that is used as query parameter for a base view. The reason for that is because we receive some input parameters (for example a number) and I need to add a prefix. If I receive "12345" I need to add "c...

Answers: 1

Denodo 7 search methods

Json array in data set - joining back to original data --- losing records when select * is used
answered 11-08-2021 06:58:14 -0400

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

Answers: 2

select query flatten ARRAY missing records JSON join

Denodo access cobol file
answered 11-08-2021 06:01:09 -0400

Hey , please I want to ask if I have cobol copybook file and cobol data file .. is there is way to make denodo read these files and show this data file as relational table in denodo?

Answers: 1

#Source Data

Can SAP Analytics Cloud use Denodo as a Datasource?
answered 11-08-2021 01:51:05 -0400

SAP SAC is one of our main reporting front-end tool. Would like to know if Denodo which contains modeled data from multiple sources can be a datasource to SAP Analytics Cloud(SAC).

Answers: 1

SAP SAC

sort response based on specific order
answered 10-08-2021 18:41:28 -0400

Hi Team, I am developing a denodo odata api by passing filters as entity_id eq 123 or entity_id eq 234 or entity_id eq 124. The response order is different. If I want the response in same order(123, 234,124). Any solution?

Answers: 1

ODATA

Issue while starting Denodo solution manager 8.0
answered 10-08-2021 18:14:08 -0400

Hi team, I have installed solution manager 8.0 in our production linux host today using the install.xml file generated which was explained in unattended installation of olution manager 8.0. License file is copied to the conf folder. But when I start t...

Answers: 3

#DenodoSolutionManager8.0

com.denodo.solutionmanager.exceptions.ValidationException: Cannot load driver class: oracle.jdbc.OracleDriver
answered 10-08-2021 17:58:18 -0400

Hi Team, i tried to create 'solution manager database' as mentioned in the below link & got error as 'Cannot load driver class: oracle.jdbc.OracleDriver' https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/configur...

Answers: 2

Format Odd TEXT Date to Timestamp
answered 10-08-2021 17:57:31 -0400

I have a field called date that is coming in as text as the following format and I am having trouble converting it to a valid time stamp: 9 - Sep - 2019 19:35 Can anyone help with the formatting of the function?

Answers: 4

Date Conversion Date time stamp timestamp