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.

Asking about connecting Denodo to remote databases.
answered 17-04-2019 16:05:07 -0400

Hi Denodo team, Yesterday, I started to use Denodo Express for my study. When I went through the tutorial, I realized that I could not find a menu in Denodo Express that allow me to connect to remote databases. Here is the scenario that I am trying ...

Answers: 1

Connecting to remote databases

Calculate Elapsed Timestamp
answered 17-04-2019 13:42:04 -0400

Hi, I need to get the elapsed time between two timestamps, for example 2019-03-31 23:49:59 - 2019-04-01 00:01:58 ?

Answers: 1

Databricks as MPP scaling cluster
answered 17-04-2019 11:46:46 -0400

Has anyone connected denodo to a databricks cluster for MPP scaling? I'd like to know the gotchas before I make the attempt myself.

Answers: 3

databricks mpp

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