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.

Microsoft vs Denodo
asked 17-04-2019 07:29:26 -0400

How does Denodo Data Virtualization compare with Microsoft Sql Server 2019 Data virtualization?

Answers: 0

JDBC Connection to SQL Server Express - URI
answered 16-04-2019 19:04:55 -0400

Running Denodo Express VDP on my laptop. Got SQL Express installed and loaded with AdventureWorks DW 2014 data. What would be the URI if this is the case? I am trying to connect via JDBC using the following URI: jdbc:jtds:sqlserver://IA-EME/SQLEXPRESS...

Answers: 1

SQL Server

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

Unable to connect to Denodo Express running on AWS Linux instance through VDP Admin tool on my personal machine.
answered 16-04-2019 11:16:13 -0400

I installed Denodo 7.0 express on AWS Linux instance and later started the VQL Server service successfully. Later I installed Denodo express on my personal machine and then launched the VDP Admin tool. I mentioned the default username and password and ...

Answers: 2
Related to: Ports needed by the VDP Server

Access Denodo Express

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