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

ODBC connection issue
answered 07-05-2018 06:50:51 -0400

I am trying to connect sql server 2014. I installed ODBC drivers provided from denodo but connection issue as below. What is the fix for this?? "Unable to establish connection: server closed the connection unexpectedly This probably means the server t...

Answers: 4

ODBC SQL Server

Apple os X el capitan
answered 07-05-2018 03:56:03 -0400

how do download denodo express into macbook with os X

Answers: 1

deleted view is still found in catalog search, causes errors in metadata scripts
answered 04-05-2018 10:25:54 -0400

Hi, a view was first created, and deleted some hours later. On recreating this view with the same name, this error pops up: Error storing view 'VIEWNAME': Error accessing the metadata while loading/storing objects checking Catalog Search, we fi...

Answers: 3

Views Metadata Catalog

How to connect Hadoop source with Kerbros configured
answered 04-05-2018 07:01:07 -0400

Hi, I'm trying to connect Hadoop using database adapter as Hive 1.1.0 for cloudera(HiveServer2) and with following url : jdbc:hive2://host:10000;databasename=default;authenticatiobmethod=kerbos;serviceprincipalname=hive/host@xxxx.com. But i am getting ...

Answers: 1

kerberos authentication client sampe code Denodo and Hadoop Hive Issue hive; hadoop

How to connect with Arango DB ?
answered 04-05-2018 06:12:12 -0400

Hi Team, Can you please help me if there is any connectors avaialbe to connect with Arango Database ? Regards, Genesh

Answers: 1

JDBC

Automated Process to store the result of derived view into CSV file
answered 04-05-2018 05:12:27 -0400

HI Team, I like to know that can we automate the process which will store result of derived view into a csv file and sent into a mail as attachemant on daily basis. Regards, Ganesh T (7875588330)

Answers: 6

VDP

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