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.

Identify derived_views related depending on a specific base view
answered 02-10-2018 16:04:10 -0400

Is there a way to identify all derived_views that are depending on a base view?

Answers: 4

Updating Datasource Schema
answered 02-10-2018 03:09:19 -0400

Our Primary Data source is HP Vertica. This is managed by another team so when we have to update schema we submit a change request for them. I am wondering can we update the schema of the data source through Virtual Data Port? For example, could we, f...

Answers: 1

XML Data in BLOB into Columns
answered 01-10-2018 11:00:24 -0400

A base view created from Oracle has a column of BLOB Data Type. This column has XML stored. How can I extract data out from XML. How Can I convert the XML data from BLOB field into Adject columns in the Derived View?

Answers: 3

XML XML Data Source derive

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