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

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

VDP Server Configuration
answered 07-04-2017 05:47:14 -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 script? Meaning can I export ...

Answers: 1

VDP cache configuration

DENODO data connection wrapper to COBOL CopyBook ?
answered 06-04-2017 18:51:49 -0400

Hi Denodo Tech Support, Does Denodo provide that ? Why would you suggest external third party data wrapper ? Should we conisder this as a product limitation ? -- Loki

Answers: 1

Data Masking
answered 06-04-2017 04:32:21 -0400

Hi , Currently in Denodo if we mark a feild as Sensitive, it makes the value as NULL when a select is run on the view. Is there a way by which we can have a custom mask value instead of NULL. As NULL does not provide the correct picture, it does not he...

Answers: 1

Data Mask

Is OAuth an option for Authentication of Denodo created Web Services?
answered 05-04-2017 13:35:36 -0400

I believe in the 6.0 documentation the options for authentication for Denodo generated web services are HTTP Basic, HTTP Digest, WSS, Kerberos, SAML 2.0. I know that Denodo can authenticate against 3rd party services using OAuth, but would like to know...

Answers: 1