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.

Finished with error: Function 'ifnull' with arity 2 not found
answered 12-03-2018 09:01:29 -0400

This is my query which I am trying to use in VQL Shell "SELECT srno_0, employeeid, firstname, lastname, country, Coalesce ( CASE WHEN Country= "USA" THEN (concat(ifnull(substr(SSN,1,3), ''), '-XX-XXXX')) end, CASE WHEN Country!= "USA" THEN (concat(ifn...

Answers: 1

coalesce CASE

Acess to Virtual DataPort server
answered 12-03-2018 07:26:18 -0400

I can not acess Virtual Data Port Server in denodo express version, with admin pop ups na error "Connection error,connection refused". Someone help please Thanks

Answers: 1

How associations help to choose best execution plan?
answered 12-03-2018 03:51:51 -0400

Hi there, One of the benefits mentioned in the introduction slide from the Linked Data Associations course (DEN60EDU0134) , mentioned that associations are useful because 'They will be used to optimize queries to increase performance by generating bett...

Answers: 1

associations Execution plans

Issue with creating a base view over a web service (onDemand DataVirtualization Course, DEN60EDU0108LAB01 module)
answered 09-03-2018 08:07:53 -0500

WSDL of the web service is available in “http://localhost:8080/services/products-ws?wsdl” *. Authentication: WSS Basic User: product Pwd: pr0duc,t Create three base views over the following Web service operations without stream output: getAllProductD...

Answers: 3

FULL CACHE
answered 09-03-2018 07:56:04 -0500

Hi: I'm trying to use fullcache for a DV compound of a join between a ODBC and JDBC base views, when executing this DV dv_customer_calls without cache the result is 2512 rows, however when updating the DV to Full Cache it restuns 0 rows. Is this the ex...

Answers: 1

Cache

Environment management with Version Control (TFS specifically)
answered 09-03-2018 07:33:16 -0500

The VCS documentation is not all that clear, especially when it comes to environment management. When using VCS with several environments, we see that Denodo checks in a .properties file for each environment, containing only their name and description....

Answers: 1

TFS Environments VCS Properties

Attribute level business metadata
answered 09-03-2018 07:16:21 -0500

We have a external metadata repository with all of our business definitions. We assign a business definition to every field in the database/rest service etc. Is it possible to bulk import field descriptions from external sources? Can it be extended t...

Answers: 1

Metadata

Scheduler Data source change
answered 09-03-2018 07:05:58 -0500

Hi Team, Can you please let us know in which log we can capture any changes made at scheduler data source level ? Thanks

Answers: 1

Export Script for Changed Views(Delta)
answered 09-03-2018 06:48:36 -0500

Hi Team, I know we can have export script written which can take backup of complete virtual databases. I am looking to have a script which will only export Delta for those views or component which got changed after last export was run. Each view shou...

Answers: 1

ODBC Timeout.
answered 09-03-2018 06:19:52 -0500

I created a ODBC connection DSN to Denodo, using the Denodo ODBC driver, that is using a long running query. I had the timeout set and eventhough the query was still returning data, the connection timedout according to the setting. That is not the beha...

Answers: 1

ODBC