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.

Help with running Denodo in a docker container
answered 31-01-2018 04:03:01 -0500

I have sucessfully installed Denodo_Express6.0 in a docker container with vqlserver running. I am stuck on an issue that when I run the container with exposing the following ports I get a connection refused from my local machine. EXPOSE 9999 EXPOSE 999...

Answers: 1

Join type mismatch
answered 30-01-2018 17:07:59 -0500

We have an issue with database tables having different primary key types (numeric / character). There is a performance hit on the database side when these occur. is there any way for denodo to help identify when a type mismatch occurs when creating or ...

Answers: 3

join

Using PK to select distinct values
answered 30-01-2018 13:24:07 -0500

We are facing an urgent issue with the tool. We are unable to select distinct row level values on a derived view without selecting all the columns for that particular derived view. In such a case, we are left with selecting a large number of columns fo...

Answers: 1

Forcing primary key to remove duplicates from a derived view
answered 30-01-2018 13:23:25 -0500

Hiwe havearun 600 columns in our derived view and select distinct Option in the output tab would generate a vql with select distinct on all the 600 columns. This makes the query very expensive on the data source ( fully delegated). Is there a way to fo...

Answers: 1

Duplicates primary keys

Unable to acess Denodo schedular adminstration tool
answered 30-01-2018 07:06:52 -0500

HI, I have used Schedular admistration tool and created job and executed it and it got completed.Now iam unable to login after restarting my Desktop and the denodo server on which denod is built. Could you please advise on the possibilities related to...

Answers: 1

Maintenance jobs
answered 30-01-2018 05:30:06 -0500

Are there any schedule application maintenance jobs on the Denodo server and what are they.

Answers: 1

salesforce as Data Source and Consumer
answered 30-01-2018 05:09:25 -0500

Does denodo support salesforce as a data source and consumer? If yes, kindly explain the steps to be followed.

Answers: 1

salesforce Data Source

Manipulate a websites HTML before scrapping
answered 30-01-2018 00:39:02 -0500

Hello, There is a link on a page that opens to a new window using a target="_blank" tag. I am wondering if there is a way to remove this tag from the page so that it will open in the same window. URL: http://www.michigan.gov/mdhhs/0%2c5885%2c7-339-71...

Answers: 1

HTML ITPILOT

Denodo - Base view vs derived view
answered 29-01-2018 11:07:39 -0500

I would like to better understand the difference between the base view and the derived view. I have a general idea, but can you articulate it so I can better understand the difference. Thank you...

Answers: 1

Views

VSAM/flat files as a data source and consumer?
answered 29-01-2018 07:58:41 -0500

Does denodo support VSAM/flat files as a data source and consumer? If yes, kindly explain the steps to be followed.

Answers: 1

VSAM Data Source flat file