Q&A

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

How to pull all the Non-LDAP users (Service Accounts) list using VQL?
answered 24-06-2019 08:05:05 -0400

How to pull all the Non-LDAP users (Service Accounts) list using VQL? How to pull all the LDAP users list using VQL? Can you some one give the VQL queries how to pull the above users list. I need to pull the LDAP and Non-LDAP users saparatly.

Answers: 1

Not able to login to Virtual dataport administration tool
answered 24-06-2019 07:56:17 -0400

Hi, I have recently installed denode , but seems like I have forgotten my credetials to login to Virtual data port administation tool. Can you please let me know the steps to re-set the password or retrive my password. Regards Suchitra

Answers: 1