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.

Safety
answered 13-03-2017 09:53:31 -0400

Hi team, We are exploring Denono Express and we like working with it! We would like to connect DE to our source systems but we work with sensitive data. Therefore we would like to know how safe it is to connect our sources to Denodo, to prevent any p...

Answers: 2

safety security

anyway to debug issues with using of generic JDBC
answered 13-03-2017 09:18:09 -0400

Hi, I fail to find any logs under denodo express installation. I've implemented some JDBC driver, and for some reason it seems to be stuck in a loop while I am trying to test-connection. If there was a way to get the error/warning/debug logging, it wo...

Answers: 1

JDBC Data-Source

Need to convert an incoming date value of type Text to a type Date
answered 13-03-2017 08:54:06 -0400

I have a field called EFF_DATE in a Base View which of type TEXT which may or may not have a value in the field. If there is a value, it is in the format of 'yyyyMMdd'. I am creating a "Selection" Derived View which states that: If the incoming value o...

Answers: 1

Date Conversion dateformat

Not able to shutdown denodo
answered 10-03-2017 09:19:18 -0500

Hi, I have installed Denodo Express in my laptop and it worked successfully yesterday. Today when I joined to different wifi and my laptop IP has changed, Denodo vqlserver is not working any more. When I was trying to shutdown, it gave me error as fol...

Answers: 1

Denodo server starting trouble.

jdbc connection to denodo derived view fails for multi-table join
answered 10-03-2017 08:33:19 -0500

Hi, We are using squirrel sql client to test extracts for a UI. we can read base views and 2 table joins fine but 3 or more tables results in semanticexception error 10009, invalid table alias 't0'. the same query works fine in denodo client and the we...

Answers: 1

hive; hadoop JDBC

Last One month Data from a table
answered 10-03-2017 07:19:08 -0500

Hello Team, I would like to fetch the data from a base View of last one month data. We have date column of format Sun Oct 09 00:00:00 PDT 2011 I really appreciate if you can provide me the function where i can use as where condition

Answers: 1

Apache Tomcat service is down
answered 10-03-2017 05:05:49 -0500

Hi I'm trying to query a restful webservice, but it seems like tomcat might be down (Windows). VDP is up and running, so how do I start the tomcat service? I can't find any windows services that looks like tomcat? Thanks Cheers

Answers: 1

Special character
answered 09-03-2017 07:24:02 -0500

I want to stripe-off special character when i query the column. is there a special funtion to do this. e.g. i have characters like ~ @ in the data. so if have value@like, i want to select valuelike. if i have panda~, i want to select panda.

Answers: 1

#SQL #VQL

List multiple servers (of a replication set) in Connection String when creating MongoDB base view
answered 09-03-2017 07:10:49 -0500

I need to know the connection string to use when connecting to MongoDB which is part of a replication set (the set consists of 3 servers). The Connection String I use when connecting to one MongoDB database is: mongodb://server1:port/dbname?authSource...

Answers: 1

custom wrapper mongodb

Denodo 6 : Unable to fetch records from Hive
answered 09-03-2017 02:01:49 -0500

I picked up all the relevant Hadoop & Hive JAR files for making connection with Denodo 6 and was successfully able to connect. Did created the views from existing hive tables, but when I try to VQL simple query to fetch records, it throw error. Bel...

Answers: 2
Related to: Denodo and Hadoop

Hive Issue