Latest Activity

code

to get the count of all view in single qurey

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

code

MS Access DB --- directly connect to a file on File Server

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

code

Unable to establish Connection: JDBC Driver not found

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

code

Custom Script

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

code

How to configure data catalog as a separate instance?

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

code

Dynamic unpivoting

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

code

Deployment to QA?production from Git

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!

code

Error when importing XtraFuncs extension

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

code

how to automate data catalog sync with VDP

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

code

How to Create Base View in Denodo to a NEO4J data-source?

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