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 April 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

UID AND PWD
answered 05-02-2018 03:21:20 -0500

what is the username and password for logic to Denodo after installation with licence.

Answers: 1

SENT1

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

import SAS Metadata

handelng leading zeros
answered 02-02-2018 13:07:13 -0500

Hey Team, I have a Database (SAP) that I connect via the custom wrapper (RFC Calls). In this I have a column that contains leading zeros. It usualy contains int with 8 digits but itis saved as text with 10 char (2 leading zeros). Is it possible to map ...

Answers: 1

VDP SAP leading zeros

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