Q&A

Need some more clarification Please
answered 22-10-2018 11:19:31 -0400

Hi Denodo Team, https://community.denodo.com/answers/question/details?questionId=9060g0000000BOWAA2&title=Parallel+Data+accessing+and+Data+refresh+Jobs I am really dispoint with you answer, why beacuse my question is different your answer is diffre...

Answers: 1

Use VQL to change user id and password on Sharepoint Base Views
answered 22-10-2018 06:00:01 -0400

I use Custom data source OData2 to connect to Sharepoint. From this Custom Data source, I defined many Base Views. Each Base View represents one Sharepoint List (i.e., Entity Collection). The username and password is stored in each Base View. So if I h...

Answers: 1

sharepoint vql password change

issue in accessing derived views in Alteryx
answered 19-10-2018 16:17:06 -0400

Hi, I have provided access for a derived view from denodo to Alteryx. The user is able to access the derived view from SQL editor in Alteryx. My question here is Can I view the list of derived views in the rightside navigation panel in the Visual Que...

Answers: 2

access ODBC Alteryx derived view alteryx

JSON POST Multiple Records
answered 19-10-2018 11:05:42 -0400

Hi - We have requirement to POST the records thru API which we can achive thru interploation variable and which executes one by one and we need to imporve the performance. I'm Wondering, Is there way can we create the JSON from the whole dataset and ex...

Answers: 1

Parallel Data accessing and Data refresh Jobs
answered 17-10-2018 12:09:29 -0400

Hi Team, we want to understand more how denodo works in the below senario. we a have dervied view "emp" which was cached in DB and published into REST services. cache was refreshing by denodo scheduler job and job will take 5 to 10 min to refresh\load...

Answers: 3

Denodo Scheduler Job is taking more Time
answered 17-10-2018 11:59:23 -0400

Hi Team, One more question here, I have a job in Denodo scheduler its runs every 30 min once from 7 AM to 7 PM in weekdays, here is my question, what happen if my job takes longer time. means. My job was started at 7 am and still running..still 7:30. b...

Answers: 1

USESSAUD [JDBC WRAPPER] [ERROR] Received exception with message 'Java heap space'
answered 16-10-2018 17:51:03 -0400

Even I have increased the java heap size to 6GB on denodo but still same error. ERROR:- Finished with error: Error executing query. Total time 4.193 seconds. USESSAUD [BASE] [ERROR] USESSAUD [JDBC WRAPPER] [ERROR] Received exception with message 'Jav...

Answers: 1
Related to: JVM Memory Settings Configuration

'Java heap space'

V6 to V7 Import
answered 16-10-2018 17:50:26 -0400

When we import the V6 (20180628 update) jar files complied in Java 7, how would they impact when importing in V7. Why does date(deprecated) show even after the below setting before import SET 'com.denodo.vdb.catalog.exportMigrationCompatibility' = '...

Answers: 1

How to access azure Denodo from my local Denodo ?
answered 16-10-2018 05:26:09 -0400

was trying to connect azure denodo from my local denodo(windows) but i could not connect to it. So is there any other ways or bridge to access these denodos ?

Answers: 2

DENODO Access azure

Hadoop Query Optimization
answered 16-10-2018 04:25:14 -0400

Hi team, Currently I am working on PoC to merge data from HortonWorks, RDBMS and SAP to deliver business reports. Do you have any performance optimization checklist\recommendation specific to Hadoop (Denodo 6.x)? I did check in Partner Portal as well...

Answers: 1