Q&A

Push down not working in Dendo Version 7
answered 26-06-2019 08:31:56 -0400

we recently went though an upgrade from Denodo 6 to Denodo 7. We followed the migration guide provided by Denodo. All seemed to have worked. Data was flowing and users logging in. However, some users started placing queries that worked just fine in den...

Answers: 2

RANK Function Migration QUERY_TIMEOUT Rank Upgrade

offline datasource - dummy records?
answered 26-06-2019 07:48:39 -0400

If your connection is stale, or even worse when your connection to a datasource is offline/not available. But you do have views working on top of these datasources. Is it possible for Denodo to give you a "select X from dual()" dummy record back inst...

Answers: 1
Related to: Denodo JDBC Connection Pooling Implementation

dummy offline datasource DENODO

Load a Date Column using Scheduler
answered 26-06-2019 06:50:10 -0400

Hi , We tried creating a derived view which has a Date Type column and we are trying to load it to the database table which has a date type column in Oracle. Whenever we execute the job to load the data from Derived view to the table , we get the below...

Answers: 1

#Timestamp #DataLoad#SchedulerDataLoad#ScheduleDate#DateType

Denodo with Spark
answered 26-06-2019 06:47:21 -0400

Hi, I need to connect Denodo with Spark which is on Yarn. How to connect it? This Spark is not Database.

Answers: 2

How to get result in array or registered ?
answered 26-06-2019 02:06:07 -0400

SELECT xpath ( cast ('xml', '<?xml version="1.0" encoding="ISO-8859-1"?> <a> <b>Hello</b> <b>World</b> </a>' ) , '/a/b/text()', false) as xpath_results FROM Dual(); The result is xpath_results HelloWorld ...

Answers: 3

XPATH XML

Failure when using Denodo Testing Tool
answered 25-06-2019 12:41:30 -0400

I am trying to test denodo testing tool on one of the base views I have created on a local orable db installed on my pc. Everytime I try to run it, I am getting below error Test FAILED. Test raised an unexpected com.zaxxer.hikari.pool.HikariPool$PoolI...

Answers: 1

#Denodo #denodotestingtool #testingtool #denodo

Connecting to Denodo Server running in Azure with VDP Admin Tool not working
answered 25-06-2019 10:46:08 -0400

I can get ODBC and Restful connections to work fine (yay!) but the minute I try to use a JDBC or VDP Admin tool connection, I get a connection timeout. Any ideas why ODBC and restful connections work, but JDBC doesn't? I opened up ports 9090 and 9996...

Answers: 2

Timezone conversion
answered 25-06-2019 07:18:13 -0400

how to convert UTC time to CST ? I am looking for Oracle FROM_TZ equalent function in Denado. your inputs really appriciated!! thnaks!

Answers: 3

Timezone conversion

Encrypting passwords that are stored in the .properties files
answered 25-06-2019 07:05:26 -0400

Hello, How can I manually encrypt the passwords that are in the properties files? I ask because I'm managing my own properties files outside of Denodo and I wanted to use the encrypted password instead of the plain text password. I wanted to do this...

Answers: 9

Data Cleansing & Scoring
answered 25-06-2019 02:53:18 -0400

Hi, Can DENODO do data cleansing, like for example identifying if records are duplicates or identical and provides a "Similarity Score" based on the rules that you designed? (Please table below) Customer Number Full Name Customer Number (Checking) S...

Answers: 3