Q&A

Unable to install Denodo Client version 7
answered 16-04-2020 17:18:02 -0400

Getting the XCOPY error while installing Denodo Client. Kindly assist. FileExecution Error: 'xcopy' is not recognized as an internal or external command, operable program or batch file. Denodo Version :7 Please let me know incase you need any det...

Answers: 1

xcopy Unable to install Denodo Client

Login/Password
answered 16-04-2020 15:57:18 -0400

After the installation complete, I clicked on VDP button on the left and click button start and launch for both Diagnostic & Monitoring Tool and VDP Administration Tool. It then poped up Login and password. I entered admin/admin for both but it giv...

Answers: 1

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