Q&A

to get the count of all view in single qurey
answered 29-09-2021 09:21:12 -0400

Hi team, Is any possible way to get the count of records from the views in one folder, without implementing store procedures. Thank you

Answers: 1

MS Access DB --- directly connect to a file on File Server
answered 29-09-2021 07:08:51 -0400

We have an access DB that is accessible via our File Server and a network location. I am trying to figure out what custom wrapper or jar file is required to get this to working. This is for MS Access 365. I have read through many of the community en...

Answers: 1

MS Access Connection jar

Unable to establish Connection: JDBC Driver not found
answered 29-09-2021 06:49:28 -0400

Hello Team , Am trying to create a JDBC Data source in denodo design studio, in denodo community they have mentoned to add jdbc driver in this path File>Extention Management>Libraries ,however when i navigated to the path ,there is no such tab a...

Answers: 1

JDBC Driver Test Connection

Custom Script
answered 29-09-2021 03:29:08 -0400

How can i achieve this.. I am having couple of tables T1 with column C1, C2, and C3 T2 with column D1, D2, and D3 I need to look into a table T1 based on where condition (where C1 = 'ABC') and check if column C3 having value. - If so i need to pick...

Answers: 1

Custom stored procedure custom script Stored Procedure

How to configure data catalog as a separate instance?
answered 28-09-2021 04:46:13 -0400

Hi Team, Is it possible to run data catalog as a seperate instance on different VM than VDP server? I could not find where in data catalog we should be configuring the VDP server addess. By default the Data catalog looks for VDP server on localhost, w...

Answers: 4

High Availbility cluster architecture Data Catalog

Dynamic unpivoting
answered 28-09-2021 04:29:52 -0400

Hi Team, I am working on Denodo 8.0 and need your suggestion with dynamic unpivoting. Whats the best way to handle this unpivoting dynamically scenario? The IDs and date range can change. There can be various IDs in the rows and Dates in the column...

Answers: 1

#unpivot

Deployment to QA?production from Git
answered 28-09-2021 04:25:59 -0400

Hi, I am working on Denodo 8.0 and want to check how to deploy the code to QA/prod environment from dev using Github? Thanks!

Answers: 3

Error when importing XtraFuncs extension
answered 27-09-2021 12:12:36 -0400

Hi, I am working on denodo 8.0. The use case i am working on is there are 84 columns with dates for each month for a given metric value in a row. I am planning to unpivot the date usign the Unpivot function. For this, I am trying to install the exte...

Answers: 1

how to automate data catalog sync with VDP
answered 27-09-2021 03:34:20 -0400

I want to automate data catalog sync with VDP as we have to do it manually everytime we make changes in the design studio .For this we also tired to do it in solution manager but still we are not able to see the changes . We also tried to create rest A...

Answers: 1

Data Catalog sync to VDP Data Catalog

How to Create Base View in Denodo to a NEO4J data-source?
answered 27-09-2021 01:16:38 -0400

Hi All, I know that a very similar question was asked before, but my problem is not connecting Denodo with Neo4j, I could connect the tools using the corresponding Driver, placing it in the folder "<DENODO_HOME> \ lib \ extensions \ jdbc-drivers...

Answers: 7

Neo4j Create Base View Connection JDBC