Q&A

to_char equivalent
answered 23-12-2020 02:30:50 -0500

Hi i want to acheive below in denodo. TO_CHAR(1210.73, '9999.9') Result: ' 1210.7' Where '9999.9' is value coming from my_table column name "format" and 1210.73 is value of my_table column name "o_ips" so basically it is select to_char(o_ips,form...

Answers: 1

Type Conversion to_char

How do I find the denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar file on the support site?
answered 22-12-2020 21:01:06 -0500

I know the denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar file is on the support website because I found another user's question that has that bit of information in it (https://community.denodo.com/answers/question/detai...

Answers: 1

Incremental Cache Cache Denodo Jar

Create folder in shared location
answered 22-12-2020 07:39:41 -0500

Hi Team, I have one requiremnet where I need to create an API inside denodo.That API will take foldername from calling system then it will create folder in project's shared location. Could you please guide how we can create folder using denodo. Than...

Answers: 1

create folder

Cannot add MySql Connector/J using Extensions Manager
answered 22-12-2020 05:19:19 -0500

In Denodo Express 8.0, when following tutoriial using MySql, when I attempt to upload the jar files of the JDBC driver to Virtual DataPort from the wizard of the menu File > Extensions management, Extensions management is 'grayed out'. When I try th...

Answers: 3

How does Full cache work after deployment to other environments?
answered 22-12-2020 05:17:58 -0500

I have enabled a "Full" cache on a Derived view. I would like to deploy this view to Staging and Production. After importing the VQL and Properties files (deployment) in Staging and Production, do I need to manually go to "Execution Panel" -> chec...

Answers: 1

Cache

We have noticed this issue also found an issue with VCS pull also after this
answered 22-12-2020 03:51:21 -0500

After the update when we saw unresolved views in the database, we tried to Commit and push the changes, But it was asking for a pull before pushing. So I tried performing pull on one of our databases which was having 13K + views in it. When I performed...

Answers: 1
Related to: Defect Detected in the Denodo Platform update denodo-v70-update-20201116: VCS integration

JSON Data Sources Pagination Field - Help Text is Inconsistent with Validation Rules. -- Is it mandatory or not?
answered 21-12-2020 10:08:18 -0500

For JSON data sources retrieved via HTTP, the help text for "Parameter in URL for page size" and "Page size" for token continuation pagination indicates that they are "(Optional)", but when omitted, I can't save because a field validation tool tip pops...

Answers: 1

design studio UI issue JSON Data Source HTTP

I was trying to install denodo 8.0
answered 21-12-2020 06:27:07 -0500

while i got an error stating some .bat files are missing and 10-15 same type of messages occurred can anyone help me with this. I tried installation through Admin. Is there any pre requisite software that needs to be installed.

Answers: 2

Installation Error Denodo Installation

import ERROR:error creating new data source: Invalid encrypted value
answered 21-12-2020 05:39:29 -0500

trying to migrate from denodo 7 to denodo 8 and getting the error above when trying to import the metadata file and resource file

Answers: 1

migration

Download data from API link directly
answered 21-12-2020 05:26:24 -0500

I have launched API link with required data. how to download the data from API into csv/excel file

Answers: 1

#Post #webservice #Json #API #Insert API