Q&A

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

Create a rank in a view
answered 10-08-2021 17:28:09 -0400

Hi, I have a view created from delimited file with fields bd, date, count and i need create a rank by bd and date. I try ROWNUMBER() OVER ( PARTITION BY ORDER BY _ ) and RANK() OVER ( PARTITION BY ORDER BY ) but it´s nos work. I try case bd when 1 th...

Answers: 1

Rownum() Over & Rank() Over

Condition based Join of 3 tables
answered 10-08-2021 13:41:59 -0400

I am having 3 tables - A, B, C. I need 4 kinds of output Case 1 : If condition 1 and 2 both not satisfied : Sel from A Case 2 : If condition 1 satisfies : Sel A. from A Inner Join B Case 3 : If condition 2 satisfies : sel A. from A Inner Join C Case ...

Answers: 2

join CASE switch

Reason: Could not initialize class com.denodo.vdp.jdbc.Driver” Softwares used:Denodo 7+JAVA 8+PCF-deployed using java build back 4_14(OpenJDK)
answered 09-08-2021 07:54:12 -0400

Get error “Reason: Could not initialize class com.denodo.vdp.jdbc.Driver” when publishing app on PCF(pivotal cloud foundry) using Java build pack 4 _14 uses openJDK Softwares used:Denodo 7+JAVA 8+PCF-deployed using java build back 4_14(OpenJDK) But w...

Answers: 1

Denodo vdp jdbc driver

Save execution result window is too small
answered 09-08-2021 05:11:05 -0400

Its very difficult to scroll in the save execution result window. Please fix it.

Answers: 1

Still Unable to establish connection
answered 09-08-2021 00:33:17 -0400

I am using Denodo 7 and have followed these instructions and get the following error when I try to test the connection (and, yes, we do use integrated authentication for connecting to our SQL Server databases): Unable to establish connection: This dri...

Answers: 5
Related to: Accessing MS SQL Server using Windows Authentication