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 April 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

Source refresh on base view changed to sourcetypeid = '91' from sourcetypeid = '93'
answered 03-10-2018 16:29:29 -0400

Hello, I did a source refresh on one of the baseviews and I observed that there is a change in sourcetypeid for some of the date attributes from: sourcetypeid = '93' to sourcetypeid = '91' I also observed that not all attributes have changed. What wou...

Answers: 1

Denodo Testing tool for Denodo7 Upgrade Regression Testing
answered 03-10-2018 16:29:13 -0400

Has anyone used Denodo Testing tool for upgarde Testing b/w V6 and V7? If yes, can you please share the testing approach.

Answers: 1

Connecting Denodo to IBM MQ version 9
answered 03-10-2018 11:22:38 -0400

Does anybody here have experience in connecting Denodo to an IBM Websphere MQ version 9? I'm creating the JMS Listener in Denodo however keep getting the error "Error starting JMS listener 'IBM_MQ': Error starting JMSListener. Unable to initialize Webs...

Answers: 1

IBM MQ

Advanced Data Virtualization Developer - On-demand online learning
answered 03-10-2018 07:48:44 -0400

Hi, This is more of a feedback than a question. I am on the third topic in the advanced course and the presenter seems to be drowsy and not clear at all, in the way he speaks. Sorry to say but he seems very unprofessional in the way the training is c...

Answers: 2

Installation problems Denodo express on Windows 10
answered 03-10-2018 05:58:42 -0400

Hi Denodo, I've downloaded Denodo Express (denodo-express-install-70-win64 ) from your side. However, I'm running in some trouble when I go through the installation procedure. All go's fine until the last part of the installation ~ 98% of the last ste...

Answers: 2

xcopy installation Error

SQL Query in a field expression
answered 03-10-2018 04:20:18 -0400

Hello, I am using Denodo 6.0 and wanted to find out if I can have a SQL query in a Field Expression of the field in a Derived View. I am looking for a instance of certain characters from a separate table (Table B) based on the value in the Field in T...

Answers: 3

Expression

ITPilot Wrapper Sequence Generator 7.0 runs in Protected Mode in IE
asked 02-10-2018 19:12:20 -0400

I just started experimenting with ITPilot, and creating sequnces using the IE-based Sequence Generator, and noticed that all files saved/loaded are "sandboxed" to a virtulaized file path due to IE running in Protected Mode. So files I save to "C:\User...

Answers: 0

ITPILOT

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