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 November 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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

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

Create table as
answered 10-04-2017 08:17:23 -0400

Can you create a table as a select from a derived view? All the tables are in the derived view are in the same database. The newly created table would be in the same database. I notice you can use scheduler to do an insert into a preexisting table that...

Answers: 1

CTAS

Denodo 6 packs
answered 10-04-2017 08:08:28 -0400

Hi ! Let's say I install just the Virtual Data Port (all its 3 components) and the Scheduler but NOT the ITPilot and ARACNE. If in the future the need arises for these, can I install (append) ITPilot and ARACNE at a later date ? Are there any resources...

Answers: 1

Aracne ITPILOT

need to execute the Import.sh on a separate server
answered 09-04-2017 19:50:53 -0400

I would like to execute the "../bin/import.sh" script on server A to create a virtual database via a VQL script on server B. Here is the script I ran in server A (to run some action in server B) /app/denodo/denodo_6.0/bin/import.sh -su -f /app/denodo/...

Answers: 3

import vql shell

How do you handle the custom Delimited file format ?
answered 07-04-2017 21:07:14 -0400

Sample file format: "12121BA121212"|~"12121BA1217"|~"00"|~"GNCCLMP"|~"20"|~"12121BA1217"|~"80"|~""|~"162"|~"92"|~"5967"|~"21"|~"70"|~"99"|~"PA"|~ "12121BA121212"|~"12121BA1217"|~"02"|~"GNCDTLP"|~1|~0|~20161002|~20161002|~"3"|~"99999"|~""|~ "12121BA1212...

Answers: 3

Ways to arrange fields in Derived view into folders
answered 07-04-2017 14:04:36 -0400

Hi Team We are building views in Denodo and have many fields in each of derived views and using Tableau as reporting tool. Wanted to check is there a way we can group fields in folders for view ie Sales View having folders as below as that of other se...

Answers: 2

DENODO formatting

VDP saving Cache database configuration information as a VQL script
answered 07-04-2017 05:59:35 -0400

I am setting the configuration of my Cache database (a MySQL database) in VDP via the Administration menu --> Server Configuration --> Cache --> Connection tab Can I reproduce the information and save it as a VQL or some other type of script?...

Answers: 1

VDP cache configuration