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.

Port of MySQL
answered 13-04-2020 08:05:06 -0400

Hello, I have already mysql-server image on doker, using the port 3306. Is it possible to change the port of MySQL installed by denodo ? Or , if i want to use your database acme for tutorial, how can i get the script ? Thnak you.

Answers: 3

Denodo_MySQL

default limit set on the derived view
answered 13-04-2020 00:40:13 -0400

Hi , Can we set default row limit on the derived view? if yes how can we increse to max limt?

Answers: 1

web service Description problem
answered 10-04-2020 04:45:52 -0400

Hi, The web service description in virtual dataport is different from data catalog description. Is this normal ? Thank you for your answer, José

Answers: 2

data catalog description

Attribute lineage Excel reporting
answered 10-04-2020 04:44:23 -0400

Is there a way to generate a flat excel reporting about every attribute lineage (including view, descriptions, etc…), The goal is to generate a 2D reporting for a more general architecture topic regarding the IT system and transformation Thank you i...

Answers: 2

lineage excel

I want to see the datediff between dates and trim the date from the timstamp
answered 09-04-2020 15:05:59 -0400

I am trying to find out the number of years between the dates but getting arity error. Need a query for difference between the years and extract only date from the query. Can someone wil help here? Thank you

Answers: 1

Denodo customWrapper Datetime field is not working in environment

Teradata Query Banding
answered 09-04-2020 13:48:35 -0400

Hi , We have requirement to implement query banding for Teradata. We have tried putting directive in driver connection pool properties 'SET QUERYBAND 'PROXYUSER=user;' FOR SESSION' But the queries getting failed with below error “Could not create a ...

Answers: 4

Teradata Query Banding

Creating views take a lot of time so is there any ways to automate the task?
answered 09-04-2020 08:25:33 -0400

When there are plenty of tables ...it consumes a lot of time to create views so how do we automate the task

Answers: 1

Write back data from Excel source to Oracle db using Denodo
answered 08-04-2020 07:56:44 -0400

Hi, I have data that gets generated in excel and I would like to insert this data everytime it is generated into a Oracle DB using denodo. Is this possible in denodo?If yes how can it be done. Thanks & Regards, Nisarg Shah

Answers: 5

[JDBC ROUTE] [ERROR] Received exception with message 'ERROR: Grouped aggregate function calls may not be nested' i am getting this issue after adding group by clause .Note the one source is snowflake and other is netezza
answered 08-04-2020 07:21:50 -0400

on denodo 7

Answers: 3

Cannot Connect to training Oracle database
answered 08-04-2020 05:29:06 -0400

I am following along the developer basic traing. But got stuck while connecting to oracle data-server. The error i'm getting is: Unable to establish connection: IOError: The network adapter could not establish connection. The database URI: ...

Answers: 11

JDBC Data Sources training Oracle 11g