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 November 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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

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

Masking data vs Data Integration or Reporting tool
answered 16-10-2018 03:44:20 -0400

Hi, I wish know how Denodo is masking data during a data query from a Data Integration tool (Informatica, Data Stage, SAS Data Integration, ecc.) and/or Reporting tool (Visual Analytics, Power BI, ecc.) by a normal user. The query execution will be mad...

Answers: 2

Data Mask

View column order metadata
answered 15-10-2018 05:53:36 -0400

I am using Denodo 7, latest update. I'm using get_view_columns() to extract metadata on columns included in views for various purposes. There doesn't seem to be anything that provides the order of the columns in the views. Is this metadata available a...

Answers: 1

metadata column order get_view_columns

Can we browse the relationships between tables using Power BI by Direct querying Denodo
answered 15-10-2018 04:54:06 -0400

Let's we have 1 fact and 10 Dimensions in presentation layer of Denodo and now I am trying to query those 11 tables using Power BI. My Question is Can we create relationships between those tables in Denodo itslef instead of conneting to all those view...

Answers: 1

Help