Home / Q&A / All Questions

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.

How can I import the SAS7BDAT file into Denodo with Metadata?
answered 02-02-2018 19:23:08 -0500

I would like to import the SAS7BDAT file to Denodo with Metadata. How can I do that? The metadata will go in the "Column Description".

Answers: 1

SAS import Metadata

Union is not working properly in Denodo
answered 02-02-2018 07:30:25 -0500

Hi Team, I am seeing one issues. here is the example I have a view as 'A' in Oracle DB I have a another view 'B' in Oracle DB ( its another DB) I did A union B and -> I got 'C' > after select view -> 'D' is my final view. Now my issues is. I h...

Answers: 1

Connection to denodo using java
answered 01-02-2018 06:47:16 -0500

Hi Team, Is it possible to connect to denodo using java??? like we can connect to mysql using java code and fetch the data from tables.. in the same way need java code to connect to denode.. kindly help for the same.

Answers: 1

Best Practice question: Limiting the number of connections to a data source from multiple virtual databases
answered 31-01-2018 11:40:24 -0500

Denodo 5.0 Update 20140221 We have many different teams starting to use Denodo and each of them is using their own virtual databases for their projects. In many cases, each team as a few virtual databases and they are all is connecting to the same so...

Answers: 3

Multiple Cache DB
answered 31-01-2018 04:54:38 -0500

Hi , I have a scenario where i need to cache the output of views to diffrent cache db. I know we can have seperate cache db for each of the VDP database. But in my scenarios since I cannot have VDP database for each data Sources, but the Cache needs to...

Answers: 1

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