Q&A

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