Home / Q&A / All Questions

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 September 2019.

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.

How to deal with the changes on the Interface View (Implementation)
answered 29-08-2018 14:09:42 -0400

We need to change an attribute type from Array (register) to Nested object in a derived view, which impacted the dependent Interface and then the subsequent REST service. The moment we made this change the interface view model changes and the impleme...

Answers: 1

Interface

Error executing sentence: toIndex = 22
answered 29-08-2018 11:56:47 -0400

Hi Team, Could you let me know what is this error related to ,I am getting this error when I am trying to execute the View which is sourcing data from different source systems.

Answers: 3

Extracting query with the hardcoded values not parameterized.
answered 29-08-2018 05:33:44 -0400

Hi, Currently we are running a query which has a lot of hard coded values. The query in its execution plan shows up like below Select as column1, as column2 from table; parameters = [<parameter1>, <parameter2>] How can I extract a que...

Answers: 1

Parameterize query plan Query Execution plans Parameter

Variables in an FTP path
answered 29-08-2018 04:45:35 -0400

Is there a mechanism in Denodo 6 or 7 to specify a variable in an FTP path?

Answers: 1

FTP

DEN60EDU0104LAB04 - Create ds_support_site data source and import all procedures
answered 28-08-2018 12:39:21 -0400

Hi, I have found myself stuck on this lab in ondemand Data Virtualization Developer Introduction. Specifically: “ds_support_site” data source, create two base views over the stored procedures included in the PKG_SUPPORT_DB package: EDIT: How do I cre...

Answers: 3

ondemand

Create a Comma Seperated List (CSV) as part of query resultsL
answered 28-08-2018 03:55:24 -0400

Is it possible to convert a list of values into a csv string as part of query result? Ex: Customer | Item John | Glove John | Bat Desired output: Customer | Items John | Glove, Bat In SQL Server, i would use syntax like shown in this article. https:...

Answers: 1

VQL CSV

Need Talend performance
answered 28-08-2018 02:29:56 -0400

We have a requirement where we are reading data from three different files and doing joins among these files with different columns in the same job. Each file size is around 25-30 GB. Our system RAM size is just 16GB. Doing joins with tmap. Talend is ...

Answers: 1

Talend

New JDBC Data Source in Scheduler for Redshift database
answered 28-08-2018 02:24:05 -0400

Hi , In Scheduler in Extraction section, when trying to create a new JDBC connection for Redshift database. In the field Database adapter no option for Redshift database selection. Can you help how to achieve the same. Thanks,

Answers: 1

redshift

Denodo Notebook feature
answered 27-08-2018 15:28:22 -0400

I saw Denodo has Notebook feature which are similar to Apache Zeppelin and Jupyter; however, I'm not able to get any information while trying to google it. Can someone tell me if this is only new in version 7 or we can use in version 6 and where I can ...

Answers: 3

Unable to establish connection: Internal error: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
answered 27-08-2018 13:24:35 -0400

I am using Denodo Express with 6.0 version and am trying to create JDBC data source connection for MySQL 5.5 but getting the below error:Unable to establish connection: Internal error: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0 Trying...

Answers: 4