Latest Activity

code

Format Odd TEXT Date to Timestamp

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?

code

Create a rank in a view

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...

code

Condition based Join of 3 tables

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 ...

code

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)

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...

code

Save execution result window is too small

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

code

Still Unable to establish connection

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...

Related to: Accessing MS SQL Server using Windows Authentication

code

SSL configuration in Denodo 8 (VDP and solution manager)

Hi Team, I am facing couple of issues while enabling SSL in my VDP and solution manager in Denodo 8 platform. Kindly help me with the answers at the earliest. I updated all the configuration files as described in the link: https://community.denodo....

code

Fetch database from Denodo through Airflow

I am trying to fetch databases from Denodo through Airflow.I have built a docker-compose.yml,dockerfile. I need suggestions as whats the right configuration to put in docker-compose.yaml,dockerfile an Airflow so that denodo is accessible from Airflow

code

Reason: Could not initialize class com.denodo.vdp.jdbc.Driver on PCF

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 But we didn't face same issue in our local development which uses oraclejdk is Denodo...

code

I am configuring OAUTH2 and LDAP, which is failing. how can i troubleshoot ? where is a log file and which log file to see ?

I am configuring OAUTH2 and LDAP, which is failing. how can i troubleshoot ? where is a log file and which log file to see ?