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.

WHEREEXPRESSION using a Subquery as a value
answered 16-04-2020 09:24:10 -0400

We are working with an JSON REST API using a WHEREEXPRESSION in the Post Body and have run into an issue when using a Subquery. Here's an example of our issue. We are able to successfully return data from the Denodo view using the WHEREEXPRESSION: se...

Answers: 1

API WHEREEXPRESSION

ElasticSeach 7.6.2
answered 16-04-2020 04:23:18 -0400

Hi, Is there Denodo v7 JDBC driver for ElasticSearch 7.6 ? I see only es v6.7 and v6.4 Thank you, José

Answers: 2

elasticsearch

SqlAlchemy
answered 15-04-2020 13:19:11 -0400

Hello, Thank you for explain that, that's very usefull. Is it possible to use SqlAlchemy instead of those connectors ? If yes can you have a document wich explain that ? Yesterday i tried to do that but it's not work. Thx.

Answers: 1
Related to: How to connect to Denodo from Python - a starter for Data Scientists

Denodo data catalog SQLAlchemy Python

There are 3 columns in the Denodo view SCHEMA- Field name, Field Type & Description. I am trying to access/view “Description” column .how to update/modify the desc field for 20/30 columns. is there a way to update or import .please let me know
answered 14-04-2020 19:38:05 -0400

There are 3 columns in the Denodo derived view SCHEMA- Field name, Field Type & Description. I am trying to access/view “Description” column .how to update/modify the desc field for 20/30 columns. is there a way to update or import .please let me know

Answers: 1

Denodo view

FedRAMP Compliance
answered 14-04-2020 16:28:21 -0400

Is Denodo FedRAMP compliant? If No, are there plans to do so in future? Are there US Government Agencies (Federal or State) using Denodo? I ask these because I plan to work with few government solution providers to push this product. Also, who are De...

Answers: 1

FedRAMP

DB2 - firstdayofmonth with an Analytical function
answered 14-04-2020 15:25:18 -0400

Database: DB2 I created a view with a date compare in the where clause field1 >= addmonth(firstdayofmonth(current_date()), -2) Then used an analytical function in the same view row_number() OVER ( PARTITION BY field2, field3 ORDER BY field4 DES...

Answers: 1

DB2

DB2 - WITH UR
answered 14-04-2020 15:13:08 -0400

Database: DB2 We are having a performance issue with a query and our DBA suggested to use "With UR" clause at the end of the query. At this time, the view in Denodo is built using the UI and I am not able to add this in where clause and I don't see an...

Answers: 2

DB2

How to install Denodo Model Bridge ? Does it require separate license ? We use Denodo VDP V7.0 Update 20190903.
answered 14-04-2020 14:54:26 -0400

How to install Denodo Model Bridge ? Does it require separate license ? We use Denodo VDP V7.0 Update 20190903.

Answers: 1

JDBC REDIS connector
answered 14-04-2020 14:27:41 -0400

Hi, Is there a JDBC REDIS connector available ? (https://redis.io/) Anyone tested JDBC REDIS for Deneodo Cache ? Thanks, José

Answers: 1

REDIS

Fail to Browse web pages using itpilot
answered 14-04-2020 13:45:30 -0400

Hi, I try to open browser at itpilot but I got this error ERROR 2020-04-13T13:55:15.464 com.denodo.itp.admin.model.specgenerator.browser.socket.BrowserCreatorSocketImpl [] - createLocalBrowser: Error while creating browser com.denodo.itp.admin.model.sp...

Answers: 1

ipilot