Q&A

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

Problem with pagination for JSON HTTP datasource
answered 27-10-2022 15:32:23 -0400

I have a JSON HTTP datasource that returns data that looks like this: { "pagination": { "pageNumber": "3", "pageSize": "100", "totalAvailable": "251" }, "datasources": { "datasource": [ {"name": ...

Answers: 1

Pagination JSON Data Source

Denodo VDP server memory utilization is constantly high
answered 27-10-2022 09:10:24 -0400

Using the latest Denodo 8.0 with August patch. We have recently tweaked the file-max parameter to increase the swap file size in Denodo VDP server(linux) after facing the 'Too many open files' error. The soft limit is set as 1024 and hard limit is set...

Answers: 3

Denovo VDP

git clone issue
answered 27-10-2022 07:44:15 -0400

Hi All, We have our denodo platform node behind a proxy server and have configured the proxy in both denodo and git. We can only use the HTTPS and no SSH. I am getting an error in vdp server log- 552108 [DNI(7)-XXX.XXX.XX.XX-4] ERROR 2022-10-19T09:36...

Answers: 3

proxy vqlserver jgit gitlab https

no module named 'kronos' in ubuntu
answered 27-10-2022 06:41:48 -0400

I'm using AWS (ubuntu instance) and django. In ubuntu, I did sudo pip install django-kronos. But, When sudo python3 manage.py runserr --settings=health.settings Import Error: No module named 'kronos'happens. Kronos works well in locals. Why I get t...

Answers: 2

AWS

Can I perform periodic updates of the base view definition?
answered 26-10-2022 18:11:00 -0400

Hi, I created base views from SharePoint List Data Sources using OData. As data source definitions are modified from time to time, I would like to poll them periodically and update their definitions. Is there some VQL statement to update base view defi...

Answers: 1

OData Source refresh Baseview Base View configuration

How to - Store encrypted VCS user's password in vdp config?
answered 26-10-2022 04:42:58 -0400

Hi, Is there a way to encrypt a VCS user's password before storing them in the $DENODO_HOME/conf/vdp/VDBConfiguration.properties? I can see that there is a configuration setting of storing encrypted password in the config file com.denodo.vdb.vdbinte...

Answers: 2

git encrypt_password.bat VCS config Devops encrypt_password.sh Virtual DataPort

Connecting Denodo views with parameters to Power BI
answered 26-10-2022 03:09:05 -0400

Connecting Denodo views with parameters to Power BI

Answers: 1

Denodo view

Large post request returns error code 500
answered 26-10-2022 02:43:27 -0400

I am trying to make a post request via Postman to insert rows into a data base table that we have connected trough a Denodo API. When trying to insert aprox. 300 000 rows (in one post request), status code 201 is returned and the rows are succesfully i...

Answers: 1

post Json Error

CSV Filename Column
answered 25-10-2022 12:42:25 -0400

I am curious if there is any way to include the filename or part of a filename for CSV files in the base view; something simlar to how the Excel wrapper can provide the sheetname as a column in the base view for an Excel data source. My use case scen...

Answers: 5

CSV

Propagating new columns from Base View till Final View
answered 25-10-2022 04:11:52 -0400

Hi, I have a situation where few new fields were added in the DB from which i created base view (BV1). Now when i click on source refresh, those new fields appear in BV1 but they are not propogating to interface view and any other dervied (selection) ...

Answers: 3

Base view