Home / Q&A / All Questions

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 September 2019.

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.

Issue type casting BLOB to XML Data Columns
answered 01-10-2018 10:45:55 -0400

Hi , I am trying to extract the XML data from Blob column in oracle database. I was refreing the below solution to convert blob to XML data. but still I am getting the error. ‘cast($1 as $0) -> Cast to xml not supported in Oracle’. XML Data in B...

Answers: 1

BLOB XML

SSL on Solution Manager prevents platform from acquiring license and solution manager web tool from logging in
answered 28-09-2018 10:51:49 -0400

windows 2012 r2, denodo 7, java 1.8 get error 207702 [https-jsse-nio-443-exec-14] ERROR 2018-09-26T07:39:07.497 ResponseUtils [] - The server localhost failed to respondcom.denodo.solutionmanagertool.business.exceptions.ServiceException: The server l...

Answers: 1

Error while fetching data from Hive using Denodo
answered 28-09-2018 05:38:08 -0400

Hi, We are unable to fetch records from hive tables using denodo.The Test conenction is working fine . For creating base view, we are able to select the database and the required table but when we go about executing ,it aborts with the below error. RK...

Answers: 1

Hive

Unable to start VDP server on Control Center
answered 28-09-2018 02:26:04 -0400

I am unable to start the VDP server from the Denodo control center tried on Denodo 6 and 7 but still facing the same issue. Thank you

Answers: 1

How to concatenate column values in VQL?
answered 28-09-2018 02:25:51 -0400

Hi, I have this in Oracle. select 'A' || ', ' || 'B' || ', ' || 'C' from dual How do you do this in VQL? Thanks.

Answers: 3

Connect to a Siebel Offline database?
answered 28-09-2018 02:24:49 -0400

Hello, I would like to how if anyone has been able to connect to an offline siebel database

Answers: 1

Connecting R to Denodo
answered 27-09-2018 23:23:43 -0400

Has anyone successfully connected to Denodo using Rstudio or any of the R tools using JDBC?

Answers: 1

Denodo 7 R JDBC

Using Regexp_like in Case in Select
answered 27-09-2018 11:26:31 -0400

Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...

Answers: 2

REGEXP_LIKE Select Query CASE

xpath function is not working as expected in Denodo
answered 26-09-2018 19:20:25 -0400

SELECT xpath ( cast ('xml' , '<Entries> <ChargebackClaim DebitMemoRefNum="61186134101">123 </ChargebackClaim> </Entries>' ) , '/Entries/ChargebackClaim/@DebitMemoRefNum/text()', true) as xpath_results FROM Dual(); I am getting...

Answers: 2

XML

update values in log4j2.xml using virtual dataport VQL
answered 26-09-2018 10:47:00 -0400

I've seen commands to update configuration parameters. Is it possible to change the "filename" and "filePattern" parameter within "RollingFile" for QUERIESOUT using VQL ? Or has this to be done by editing log4j2.xml directly?

Answers: 1

Virtual DataPort v6.0 log4j2.xml