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
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
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
Hi, I need to connect Denodo with Spark which is on Yarn. How to connect it? This Spark is not Database.
Answers:
2
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
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
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
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
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
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