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.

Custom Logging for JAVA procedures
answered 02-05-2017 08:46:05 -0400

We have a Java Stored Procedures that refers to other java classes. We want to have logging framework which will log to file during execution. Currently, I am using org.apache.commons.logging.Log; org.apache.commons.logging.LogFactory; private static ...

Answers: 1

logging

Connecting pop3 server
answered 02-05-2017 05:41:48 -0400

Hi Team, I am trying to connect pop3 server for getting mail details but not sure how i can create the pop3 data source. I have tried 'Aracne' data source but while creating base view i am geting "Unable to connect to aracne server" Please let me kn...

Answers: 1

Scheduling Jobs in Denodo using BMC Contol-M (without using the Denodo Scheduler)
answered 02-05-2017 02:05:54 -0400

I am using Version 6.0 (update 12192016) on RedHat Linux. I need to use Control-M with Denodo - to run jobs in Denodo to populate the Cache engine tables. Can I use ODBC to connect from Control-M to to Denodo to run VQL scripts to run Base/Derived Vi...

Answers: 2

Denodo Scheduler 6.0 wrapper contol-M

Access Cognos TM1 from Denodo
answered 28-04-2017 07:28:02 -0400

HI We wanted to Access Cognos TM1 from Denodo.INstalled the denodo O data wrapper in denodo What all details required to make successful connection to TM1 but not sure on options to select while creating a Datasource .Any document or link supporting it

Answers: 1

Denodo TM1

Case statements not giving expected results in Denodo
answered 28-04-2017 06:58:55 -0400

When I execute the below logic in TOAD in the SELECT statement, I get proper expected result but when I put the same logic in Denodo View for one of the output columns, the result set doesn't match with what Toad is returning: ((((trim(tr_tran_short_d...

Answers: 1

CASE

Issue with CONTEXT date conversion with call from a REST Webservice
answered 28-04-2017 06:30:57 -0400

I am getting the following error when I execute a the following query from a REST Web Service to a view in Denodo: SELECT_NAVIGATIONAL <fields> FROM <denodo derived view> WHERE (1=1 and (Rcvd_Date BETWEEN DATE '0001-01-01' AND DATE '9999-12...

Answers: 1

Date Conversion dateformat

custom wrapper
answered 28-04-2017 04:12:47 -0400

Why have you written a custom datasource wrapper for fetching data from salesforce.com when you are using soap only internally in it and we know that denodo supports creation of soap datasource?

Answers: 3

custom wrapper

Connector to Spark SQL
answered 26-04-2017 11:50:25 -0400

Hi Team, We are looking for Connector for Spark SQL. when i go through the same question, i see one answer that we need to create the baseview from query instead import baseview. Also config change in hive datasource. These answers are when the versio...

Answers: 1

Spark-sql connection

Does Denodo accept this Delimiter ?
answered 26-04-2017 07:32:41 -0400

The column delimiter is |~ Is that a product limitation ? -- Lokesh

Answers: 1

Date conversion not working as expected
answered 26-04-2017 07:09:36 -0400

I have a NUMERIC source column which is in format “YYYYMMDD”. I am using TO_DATE function to convert into date. However the dates are not converted accurately using the function. The dates I have in the source column are 20170421 while the output of TO...

Answers: 1

TO_DATE function