Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

Rounding 2 decimals not working as expected
answered 21-12-2017 04:51:16 -0500

Hi team! I'm looking for a way to ensure we are forcing the decimal number to have 2 decimals, now I'm having problems with those decimals that have only 1 digit. Please, see image in the below link. I'm using the Round function in this way: Round(&l...

Answers: 3

round decimal

Request for Datasource Information
answered 21-12-2017 03:18:48 -0500

Hi Denodo Team How can we pull list of Datasources in below format. Could you pls help me to provide complete query. Datasource Name | Database URI | Username Thanks

Answers: 1

REST API Content-Type : application/octet-stream
answered 20-12-2017 13:31:57 -0500

My output of API is octet-stream . Is there way I can define in the data source

Answers: 1

REST API

Linux based documentation
answered 20-12-2017 06:47:30 -0500

Hi Team, We need to prepare a documentation for the below activities. On prem to AWS migration - red hat linx server. VDAP admin activities ( Installation, user creation and roles, denodo monitor configuration, kerberos configuration , backup ...

Answers: 1

Reading PDF file data in ITPilot
answered 20-12-2017 01:54:51 -0500

I want to perform below list of events in ITPilot Login to mailbox Reading mail Download PDF attachment for every mail Extract values from PDF file Till reading mails all looks good for me. Further, each mail will have one PDF attached whi...

Answers: 1

ITPilot

Exporting ITPilot wrapper output to VDP View
answered 19-12-2017 17:56:59 -0500

I have created wrapper in ITPilot .This is same replicated as explained in ITPilot tutorials https://community.denodo.com/tutorials/browse/webautomation/2patterns-c This wrapper gives list of records in ITPilot result tab. Is there any way to export ...

Answers: 2

ITPilot

what does the parameter VDP/MaxRowsPerQuery is meant for? and how to get rid of this limitation?
answered 19-12-2017 07:15:58 -0500

Hi Team, I noticed one of the parameter in our PROD instance license as below: VDP/ProductName=Virtual DataPort 6.0 VDP/MaxSimultaneousRequests=3 VDP/MaxRowsPerQuery=10000 Can we make changes to these parameters in Denodo.LIC file directly to overco...

Answers: 1

MaxRowsPerQuery

DataSource names and Connections.
answered 19-12-2017 00:57:35 -0500

Hi Do denodo has query to list all the datasource names and its connections? Regards Karthi

Answers: 1

DataSource

Identifying if Cache Maintenance is running
answered 18-12-2017 08:19:41 -0500

I'm going through the process of removing the Cache Maintenance task and replacing with scheduled clean cache calls. Is there a way that I can tell if the current Cache Maintenance task is running? Can I tell when? Since its only configured with time i...

Answers: 1

CALL CLEAN_CACHE_DATABASE Cache

Denodo Rest Service execution issues
answered 18-12-2017 07:50:32 -0500

We have created some views which access data from an API. These views are interdependent. Data from one view (token) acts as an input to make an API call from the second view. All this is working when we are accessing these views as dervied view and re...

Answers: 2

REST