Q&A

How to configure the Json data source for VDP-Data Catalog - Synchronize?
answered 15-12-2020 21:43:31 -0500

Hi Team, I am refering link "https://community.denodo.com/answers/question/details?questionId=9060g0000004FVuAAM&title=Data+Catalog+-+Synchronize+comments" for the Data Catalog - VDP - Code Synchronize. I am trying to create JSON data source calls ...

Answers: 9

Synchronize Data Catalog json

cache error with the fresh configuration of cache
answered 15-12-2020 07:18:25 -0500

getting an error after making a fresh connection and cache configuration Error modifying view: There was an error inserting a new row in the table 'vdb_cache_names' of the cache database. : The table does not comply with the requirements by an externa...

Answers: 1

Cache Error

Driver not found
answered 15-12-2020 07:08:57 -0500

Hi, after follwoing the steps in the guide (https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Azure%20SQL%20Data%20Warehouse%20from%20Denodo?category=Data+Sources) I always get the same error message:"Unable to establish connecti...

Answers: 2

Azure Driver Azure SQL DB

Is it possible to show a dummy record in denodo when no data is present in the table .
answered 15-12-2020 05:58:39 -0500

Hi, Is it possible to show a dummy record in denodo when no data is present in the table . I need to show 'Dummy' values in all the columns when no records are found in the source. is it possibble to do that. Regards

Answers: 1

oracle "date" column convert to "timestamp" column in Denodo
answered 15-12-2020 05:45:51 -0500

Hi team, I have view sourced from oracle, which contains date type column, when created this view, denodo converted the date column to "timestamp" automatically, and when tried to convert it to "localdate", the error is showing "the field has an incomp...

Answers: 1

date oracle timestamp

Having clause missing from Data Cataloge 7
answered 14-12-2020 17:33:18 -0500

As per the reply to this question - https://community.denodo.com/answers/question/details?questionId=9060g0000004FLLAA2&title=Denodo+Data+Catalog%3A+Having+Clause My question - since Denodo 8 is now GA, do we have HAVING clause available in its da...

Answers: 1

Denodo data catalog

is it possible to show runtime filter in one of the columns in denodo API
answered 14-12-2020 13:57:58 -0500

is it possible to show runtime filter in one of the columns in denodo API

Answers: 1

How to disallow some HTTP methods while publishing a RESTful service over a view
answered 14-12-2020 08:23:35 -0500

I am using Denodo 7 and exposed an updateable derived view via a REST web service. The swagger documentation generated automatically shows the syntax of invoking this service for PUT, DELETE, and POST methods also. I just need to provide GET method on ...

Answers: 1

REST API

Refresh metadata och a derived view
answered 14-12-2020 07:37:12 -0500

When the name or a column of a derived view is changed (not added or deleted) this change need to be propagated to parent derived views. The only option I see now is to do this manually. Is there other options to propagate changes?

Answers: 1

Where is the error log file when using custom connector
answered 14-12-2020 06:39:09 -0500

Where is the error log file when creating base view from a data source from a newly uploaded custom connector? Error: Error loading data source ... Denodo 7.0

Answers: 1

Custom Connector