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

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