Q&A

High Volume Data extraction from Denodo 8 - 50 plus million rows (approximately data size is 10 plus GB) per table. We have close to 200 such tables
answered 08-02-2021 06:05:00 -0500

Hi, We are currently using Denodo 8 in our env. We have tables with more 50 Million rows on an average that needs to be exposed via Denodo. What is the best approach to do this. 1) Create a webservice on top of the Denodo View and expose as an API wit...

Answers: 1

Data extraction from Denodo

on demand course
answered 08-02-2021 03:39:56 -0500

hi, I have registered for on demand course. but not getting how to start the courses. the email says get the app. there are no other links which can be open in laptop and I can watch training videos. Please help! Thanks in advance.

Answers: 1

Authorization in Solution Manager 7.0
answered 05-02-2021 06:38:46 -0500

Hi Team, Lately we started using solution manager 7.0. We had a requirement as follows: As per the current security architecture in solution manager, it manages licenses for 2 applications say app1 and app2. Currently app1 manages adding vdp instances...

Answers: 1

#solutionmanager7.0 #authorization #solutionmanager

Sales Engineering Toolkit from partner portal has not all dependencies installed that are required for the developing modules
answered 05-02-2021 05:21:29 -0500

Hi, I have successfully installed the Toolkit from the partner portal. Now I want to get through the module 'Data Virtualization Developer'. I started with the first lesson, where I need access to the Virtual DataPort Admin Tool. But apparently thi...

Answers: 1

Sales Engineering Toolkit Partner Portal Virtual DataPort Admin Tool Data Virtualization Developer

Query limited to 10000 rows
answered 04-02-2021 00:56:00 -0500

Hi, I’m making tests on data file load using Denodo Express 8.0 for Windows 64 bits. I have a csv file with 11870 lines (1 header and 11869 records). I made a data source on this file and a base view on the data source. When i make the query "SELECT...

Answers: 1

ROW_LIMIT_REACHED

RIGHTPAD(project_key, 3) function returning error Function 'rightpad' with arity 2 not found
answered 04-02-2021 00:25:39 -0500

Hi, I have strings like this bvq7527.i6v6f8.0ppnf4l967ussr48re21g in project_key field and I want to get the last 3 characters for example 21g, so when I tried to run select rightpad(project_key, 3) from iisdq.iv_sl_xmeta_project_dim in the VQL, I'm g...

Answers: 3

How to get dynamic query from UI to denodo API
answered 03-02-2021 07:01:48 -0500

Hi Team, I have a requirement from front end where they will build the select query dynamically in UI based on some parameters like studentID > 10 then that condition should convert into a select * from viewname where studentID > 10 and send tha...

Answers: 1

HTTP path types
answered 03-02-2021 06:25:44 -0500

Hi Team, I'm using Denodo 7.0 version and followed below link to find the edit http connection tab to configure my REST API as GET/POST/PUT and the required input parameters. can you help with this issue. https://community.denodo.com/docs/html/browse/...

Answers: 1

#Rest API #HTTP Paths

Why VCS operations not enabled after migrating denodo 7.0 to 8.0? Denodo 7.0 has this enabled.
answered 02-02-2021 16:18:19 -0500

Denodo 7 has VCS enabled for databases but after migrating 7 to 8 and using design studio for 8, vcs option is greyed out and says vcs is not enabled.

Answers: 1

Session Timeout Configuration
answered 02-02-2021 07:41:22 -0500

Hi everyone, is there a way to configure Session Timeout (E.g. Set Session Timeout to 30 mins) for Denodo?

Answers: 1

session