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

Updated 5.5 JDBC driver ?
answered 14-04-2017 12:48:03 -0400

I'm using a version of your 5.5 driver that was compiled with java 1.5 and in using Splunk to connect to Denodo it errors out on the following call a. java.lang.AbstractMethodError: com.denodo.vdb.jdbcdriver.VDBJDBCConnection.isValid(I)Z The isValid c...

Answers: 1

JDBC

Our jobs are failing if it is prolonging more than 15 min
answered 14-04-2017 12:38:27 -0400

When we our trying to read our data in denodo from our ETL , it is getting failed with fetch optimise error if it exceeds more than 15 min. Kidnly advise

Answers: 1

Vql to get Dendodo Server name
answered 12-04-2017 09:00:48 -0400

Hi Denodo, Is there anywat that i can get Denodo Server name using VQL,I am asking similar function like @@servername in Sql Server.

Answers: 1

VQL

Creating a new column in derived view
answered 12-04-2017 08:49:20 -0400

Hi team, I created a derived view from two base views. In this derived view I want to create a new column doing the following transformations to the data: I currently have this column existing column street: value: 'streetname123' I want to create a...

Answers: 1

Data Quality derived view

Using variable within interpolation function suffix
answered 11-04-2017 08:04:38 -0400

Is it possible to add somehow another interpolation variable to interpolation function suffix. Following does not work. input2 does not get resolved to value ^ExecuteIfIsNotNull(" WHEN ",@input1," = 4 THEN @{input2}")

Answers: 1

VQL

Scheduler Administration Tool CSV exporter
answered 11-04-2017 05:15:20 -0400

Hi everyone! Im currently using Denodo Express to test different functionalities. One of the functionalities is exportng a CSV file about changes in the underlying databases for my base views. I created a "database changes" view in the VDP by using st...

Answers: 1

Job scheduler CSV

Data Dictionary
answered 11-04-2017 03:31:46 -0400

Hi All, is it possible when creating a view or objects, that each column can be populated with a description so when a in a reporting tool and a power user hovers over a column the pop up shows a column name/data type and description of column? Many ...

Answers: 2

Data Validation in Denodo
answered 10-04-2017 17:31:41 -0400

Hi Team, We would like to know how Data Validation ( in other way data profiling ) is carried out in Denod. ? Is there any in-built internal tool or mechanism exist in Denodo which perform this activity ? Regards, Ganesh Taware

Answers: 1

Data Profiling

Does Denodo support Lex Parser
answered 10-04-2017 11:12:49 -0400

Does Denodo support multi character Delimiters like ? Example delimiters: ^~^ |^| |^ ^| ~^ ^|^ |~ ~!@ |~| How does Denodo handle such delimiters inside the delimited flat file. -- Loki

Answers: 1

Looking for some solution for Denodo server issue
answered 10-04-2017 09:35:08 -0400

Hi All, I am wondering, if we do have anything in Denodo to release unwanted resources over the period of time. For example: We are running many queries with huge volume of data through BO and in about few months (Max 3 months) Denodo starts respondi...

Answers: 1