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.

PostgreSql ODBC Driver
answered 14-04-2017 21:33:56 -0400

We are running Denodo 6.0.20170220, connecting to VDP from OBIEE via PostgreSQL ODBC Driver. We get following error in vpd.log whenever running a particular query in OBIEE. We don’t get any error, running the same query connecting to other VPD servers....

Answers: 1
Related to: How to access to VDP from OBIEE via ODBC in Linux

OBIEE

Issue with fields with the new Denodo 6 version through JDBC
answered 14-04-2017 16:46:45 -0400

We tackled a new error, after update to the last Denodo 6 version (from January 2017). we get an exception from : com.denodo.vdb.engine.wrapper.raw.jdbc.JDBCAccess [] - Error creating new metavalue the next line of the exception is : com.denodo.vdb.en...

Answers: 6

JDBC query

Statistics calculation
answered 14-04-2017 16:42:25 -0400

It seems that unless you create a custom wrapper by the API, there is absolutely no way to run statistics. Something in the mechanism in Denodo, expects that manual statistics calculation will be done in milli-secs, or it fails with exceptions. There i...

Answers: 5

JDBC Generic configuration

Connection to a generic JDBC wrapper results in catastrophic performance
answered 14-04-2017 16:29:31 -0400

I remeber it wasn't so bad in previous versions. I am trying the anchormen sql4es, which works fine from point of view of connection testing and getting the metadata. However, as running a query directly vs the JDBC driver (java code) takes miili-secs...

Answers: 5

jdbc wrapper performance

Flatten a register in XML
answered 14-04-2017 13:00:07 -0400

Hi team! I have a couple of XML files with a register in it. These are orderfiles from different sources, so they use different names for fields. I'd like to make a new virtual generic table (ordertable) with these XML files, but it seems I can't fl...

Answers: 1

Register XML

Denodo Api for creating users
answered 14-04-2017 12:53:41 -0400

Simple question, but have not found an answer yet We know we can create users with a vql statement. But is there also an Denodo API available to create users?

Answers: 1

API users

Updated 5.5 JDBC driver ?
answered 14-04-2017 12:48:03 -0400

I'm using a version of your 5.5 driver that was compiled with java 1.5 and in using Splunk to connect to Denodo it errors out on the following call a. java.lang.AbstractMethodError: com.denodo.vdb.jdbcdriver.VDBJDBCConnection.isValid(I)Z The isValid c...

Answers: 1

JDBC

Our jobs are failing if it is prolonging more than 15 min
answered 14-04-2017 12:38:27 -0400

When we our trying to read our data in denodo from our ETL , it is getting failed with fetch optimise error if it exceeds more than 15 min. Kidnly advise

Answers: 1

Vql to get Dendodo Server name
answered 12-04-2017 09:00:48 -0400

Hi Denodo, Is there anywat that i can get Denodo Server name using VQL,I am asking similar function like @@servername in Sql Server.

Answers: 1

VQL

Creating a new column in derived view
answered 12-04-2017 08:49:20 -0400

Hi team, I created a derived view from two base views. In this derived view I want to create a new column doing the following transformations to the data: I currently have this column existing column street: value: 'streetname123' I want to create a...

Answers: 1

Data Quality derived view