Q&A

You must sign in to ask a question. If you do not have an account, you can register here

VDP Server not available due to license restrictions
answered 16-04-2020 17:25:28 -0400

This is my first time installing and trying to use Denodo. In VDP, it shows Virtual DataPort Server as 'not available due to license restrictions.'. What does it mean?

Answers: 1

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