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.

Difference between blank space and NULL
answered 04-05-2018 05:09:11 -0400

What is the difference between blank space and null in denodo? I observed that the fields with blank space cannot be retrieved using IS NULL. So, How to retrieve the columns with blank space or how to change them to NULL?

Answers: 1

Connecting to multiple databases with ODBC Connection
answered 03-05-2018 12:31:28 -0400

My goal is to be able to query multiple databases in a workflow, but I am not able to determine how to set up one ODBC connection that allows you to query more than one, or how to set up multiple ODBC connections that are each mapped to one database. I...

Answers: 1

ODBC ODBC Alteryx

Unable to Crate Oracle 12c Connection
answered 03-05-2018 12:07:32 -0400

Hi, I am using Denodo Virtual Data Port Version 6.0. When trying to create a new JDBC connection to my Oracle 12c database, I receive the following message: Unable to establish connection: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: ...

Answers: 1

NULL Function usages.
answered 03-05-2018 11:08:23 -0400

Dear All, convert(date,a.createddt,112) between b.EffectiveFrom and Cast(isnull(b.EffectiveTo,getdate()) as DATE) The above code was written in SQL Server. As I am using the Excel data is my data source. I want to convert the above syntax to DENOTO ...

Answers: 1

NULL

connect to mysql using JDBC Driver
answered 03-05-2018 05:08:24 -0400

Dear Sir, I have MYSQL in Linux Enviroment and Denodo installed in the Linux Environment. What is the JDBC driver class for connect to MySql database via Denodo tool. Regards, Senthil

Answers: 3

JDBC

ITPilot extractor table multiple levels
answered 03-05-2018 04:54:44 -0400

Hi! I am using denodo platform 6.0 and itPilot so as to extract data from web. I would like to know if we can extract data from multilevel table row. I have 2 levels and I would like to join data from parent row and children row, for example: I have a ...

Answers: 1

ITPILOT ITPilot

Tenable REST API token
answered 02-05-2018 22:18:43 -0400

I try to create JSON datasource and create base view from tenable REST API https://docs.tenable.com/sccv/api/index.html It request authentication via token. Any suggestion? "Authentication Most SecurityCenter API REST calls require authentication. ...

Answers: 2

REST API Token

Any way to completely automate config deployments
answered 02-05-2018 05:58:48 -0400

We are using export.sh and import.sh to move code/config between environments for vql/vdb and the scheduler components. Is there any way to deploy ISST information self service tool config from the command line rather than through a GUI? Thanks

Answers: 1

import export scheduler isst

issue with training course
answered 01-05-2018 21:49:39 -0400

I was taking basic course (FUNCTIONS), and all of sudden voice didn't come out. Voice is still gone - Is there any problem?

Answers: 1

remove errors from SOURCE_CHANGES()
answered 27-04-2018 07:26:47 -0400

currently, views go in error when executing SOURCE_CHANGES(). at the documentation I've seen the remark: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/source_changes this remark indicates to ...

Answers: 5