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.

in selection view, is there any way that input parameter can accept values from subquery rather direct assignment
answered 10-01-2020 19:26:28 -0500

in selection view, is there any way that input view parameter can accept values from subquery rather direct assignment of values. if i assign values through sun query like below SELECT GETDAYSBETWEEN(in_from_effective_date, in_to_effective_date), p_p...

Answers: 1

Parameter View Parameter entry selection view

Issues with "Denodo Email Exported Files Custom Handler" on Denodo Scheduler.
answered 10-01-2020 06:07:17 -0500

Hi Team, I have configured "email export files" on Denodo Scheduler as given in the document link "https://community.denodo.com/docs/html/document/denodoconnects/7.0/Custom%20Handler%20Email%20Exported%20Files%20-%20User%20Manual". But I am facing is...

Answers: 1

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 09-01-2020 14:37:07 -0500

Hi Team, We use AWS RDS for Denodo Cache. We have upgraded RDS mysql version from 5.6.41 to 8.0.16. When trying to connect from Denodo VDP to RDS, it is throwing below error. Unable to establish connection: Communications link failure The last packe...

Answers: 1

Cache

querying very large data sets in denodo?
answered 09-01-2020 06:06:21 -0500

if I want to build a machine learning model using Apache Spark that accesses terabytes of data in denodo, is there a way to access the data using a more performant method than jdbc, such as hdfs?

Answers: 1

"Denodo Email Exported Files Custom Handler" Plugin For Scheduler
answered 08-01-2020 13:29:17 -0500

Hi Team, Can I get a link from where I can download "Denodo Email Exported Files Custom Handler" Plugin to run it on denodo scheduler.

Answers: 1

querying unstructured data with denodo
answered 08-01-2020 07:41:06 -0500

I have watched the webinar here, which shows how to use structued data for building ML/AI models - https://www.denodo.com/en/webinar/advanced-analytics-and-machine-learning-data-virtualization Some models such as neural nets require images (unstructur...

Answers: 1

SSL error in SQL server
answered 07-01-2020 13:42:13 -0500

Hi Team, Denodo 6.0 Database Adapter : MS SQL server 2012 (MS Driver) Driver Class Path : sqljdbc4.jar Driver Class : com.microsoft.sqlserver.jdbc.SQLServerDriver Error: Unable to establish connection: The driver could not establish a secure connecti...

Answers: 13

SSL

Cannot connect to VDP
answered 07-01-2020 12:09:24 -0500

Hi, I am getting timeout issue when connecting to VDP. Server is up and running. 106198 [AWT-EventQueue-0] ERROR 2020-01-07T14:43:03.379 com.denodo.vdb.admin.gui.components.connection.ConnectionPanel [] - Connection error:com.denodo.vdb.admin.model...

Answers: 1

Connection issue to VDP

how can we ensure in a join /subquery a query passed to underlying source first then another one in a same session
answered 06-01-2020 17:40:44 -0500

HI , usually when we perform a join in two base views or use a subquery in denodo. it creates two different parallel connection to get data from underlying source. can we ensure that both of queries on join run in same session and one after another. be...

Answers: 1

query execution VDP query optimisation

Query regd. Associations
answered 06-01-2020 15:24:58 -0500

Hi All, I had stuck with a case that when i hit the associations rest service to get the details, am getting only table names in response but not the mapping details between those tables.

Answers: 3

associations Association