Q&A

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

SSL configuration in Denodo 8 (VDP and solution manager)
answered 06-08-2021 18:19:20 -0400

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

Answers: 1

Denodomigration #Denodo8 solutionmanager8 #SSL

Fetch database from Denodo through Airflow
answered 06-08-2021 16:15:26 -0400

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

Answers: 1

Airflow Denodo Docker

Reason: Could not initialize class com.denodo.vdp.jdbc.Driver on PCF
answered 05-08-2021 17:51:03 -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 But we didn't face same issue in our local development which uses oraclejdk is Denodo...

Answers: 1

Denodo vdp jdbc driver

I am configuring OAUTH2 and LDAP, which is failing. how can i troubleshoot ? where is a log file and which log file to see ?
answered 05-08-2021 15:33:00 -0400

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

Answers: 1

Copying database contents.
answered 05-08-2021 13:19:19 -0400

Hi , May I know how can I replicate one databse with all of it's contents (base views,interfaces etc ) into another dummy databse in same instance ? E.g. I have prod_db and I want to copy all of it's contents to prod_db_copy databse . TIA SJ

Answers: 1