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 November 2018.

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.

Predefined stored procedures GET_JDBC_DATASOURCE_TABLES and LIST_JDBC_DATASOURCE_TABLES not work
answered 16-04-2019 18:51:22 -0400

Hi, The documentation of Denodo 6.0 refers in chapter predefined_stored_procedures, two stored procedures that I am interested in: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stor...

Answers: 1

Collibra Connect | Denodo
answered 15-04-2019 19:00:06 -0400

Need a quick assiatnce on integrating collibra data in Denodo using Collibra Connect. Information given in the below portal is minimal. https://www.collibra.com/data-governance-solutions/data-governance-integration Could you please provide details ...

Answers: 1

Denodo Collibra Connect

Export of result of a view to a txt file
answered 15-04-2019 18:17:46 -0400

there will be some way to export the result of a view to a file using a sql statement, not used scheduler and button save in vdp for example in oracle they use the "spool" in a sentence sql for export data was left pending thanks

Answers: 1

Working with JSON hierarchical data
answered 15-04-2019 17:47:30 -0400

Hi Denodo Team, I am struggling with virtualizing data which is in JSON format (and can only be pulled in JSON format from the API). There are numerous arrays within Registers within arrays. My requirement is that I do not create numerous flattened vi...

Answers: 1

flatten JSON

Why is it recommended that Apache Derby embedded database should NOT be used for storing cache data for production?
answered 15-04-2019 14:17:44 -0400

For almost all of the Denodo articles that talk about caching, we see snippets like this: "... you can configure the cache module to store the cache data in the Apache Derby database embedded in Virtual DataPort. However, we strongly recommend using an...

Answers: 1

Cache

How easily find invalid objects using VQL?
answered 15-04-2019 12:18:29 -0400

How easily find invalid objects using VQL?

Answers: 1

7.0

How do we Install license using Solution Manager Licence
answered 15-04-2019 10:53:55 -0400

Hi Team, How can we install the license to VPD Server using solution Manager . I have solution Manager Licence.

Answers: 5

License File

Flatten query parameters (array of string)
answered 15-04-2019 10:47:14 -0400

Hello, I have a table with an ID of a company and WS for getting an information if the company can be trusted or not. The problem is with the WS. In default, it has parametrized input array of string and returns two arrays of outputs. I used FLATTEN fu...

Answers: 3

flatten ws

getting HTTP error code 403 on creating base view
answered 15-04-2019 08:27:41 -0400

I'm trying to connect s3, following this Amazon S3 REST API section. my s3 is (dummy info below) bucket: denodo-test file:/denodo.txt (no folder) I have IAM account with full access to s3. I could get se file with awscli. on base view creation part,...

Answers: 3
Related to: How to integrate Amazon S3 with the Denodo Platform

AWS S3

Denodo with Spark
answered 15-04-2019 03:19:11 -0400

Hi, I need to connect Denodo with Spark which is on Yarn. How to connect it? This Spark is not Database.

Answers: 1