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

Cache error by inserting null data
answered 18-05-2018 11:45:40 -0400

When I make a query to save in cache, at the end I get the following error: "ERROR_LOAD_CACHE", "Error loading cache: There was an error while inserting data: null", in the fields use the function: COALESCE to avoid null values someone would have some...

Answers: 2

Cache error

Target Data
answered 18-05-2018 08:15:39 -0400

We Implementing logic in Interface by pulling views with joining different tables and I did not understand where we going to put Target data here, Is it using web services like SOAP and REST services or any other alternate we have to load data in SQL s...

Answers: 1

Not able to create a Base View on MongoDB
answered 18-05-2018 07:34:51 -0400

I'm trying to connect to Mongo DB in Azure Cosmos and create a base view. We're usingb ssl so the connection string is mongodb://dbname.documents.azure.com:<port>/Test?ssl=true We specify the user, password, Collection. The error message is Err...

Answers: 6

Unable to Access Denodo
answered 18-05-2018 05:28:23 -0400

Hi, I have Denodo installed in Windows Server 2012 in AWS. I am trying to create an ODBC DSN connecting to this instance from my local Desktop but it shows connection timed out. I am able to ping the public IP of the Windows Server in AWS. Just an o...

Answers: 1

Denodo with Cassandra as a source Not working
answered 18-05-2018 02:41:17 -0400

Hi, We are using Generic adapter for Cassandra source and it seems it does not support many data type conversion functions and also it does not read the cassandra date values to denodo. We are using the 2.1.2 cassndra driver and thats the one support...

Answers: 1

Cassandra

Column dependency using metadata procedures.
answered 17-05-2018 12:48:05 -0400

I have an requirement to pass list/multiple ViewName parameter to COLUMNDEPENDENCIES procedure dynamically to get all the dependent views consuming this ColumnName parameter across database. ## Metedata Query: Select column_name, dependency_identifie...

Answers: 3

Metadata

remove parameters from query output
answered 17-05-2018 08:42:49 -0400

Hi, Parameters added in a selection or join are always shown in the query output as a new column, is it possible to hide these columns in the query output? The reason I use parameters in some views, is due to the parameter is mandatory for execution,...

Answers: 3

Initialization Error: connection error: Connection timed out: connect
answered 17-05-2018 03:27:03 -0400

After installing the Denodo, when i tried to launch VDP after starting the VDP server, i am getting following error "Initialization Error: connection error: Connection timed out: connect"

Answers: 1

Edit View Parameters dialog panel stuck on screen.
answered 16-05-2018 21:57:33 -0400

Denodo Virtual DataPort Version 6.0 No installed updates I am taking paid training and can't add view parameters to a "Edit View Parameters..." screen. I press OK, Cancel or Add new parameter and I can't get out of the dialog.In this case I am using DE...

Answers: 1

View Parameter entry

Logging in the queries on view into a database.
answered 16-05-2018 15:13:04 -0400

Hi Thanks in advance. I am looking for help or any pointers on how to enable logging in the queries on view into a database. i am not sure if this is even possible. For example: If i have a database "sales" and a business view which is called "Sales R...

Answers: 3