Q&A

Maven Integration with Denodo4E plugin
answered 19-04-2017 07:51:06 -0400

Can we integrate Maven build management with the Denodo4E plugin ? I am trying to upload dependencies to Nexus repository so they can be linked in the project using Maven. When deploying the Denodo project, the plugin doesn't recognize the dependencie...

Answers: 3

Stored Procedures Custom Functions Denodo4E deploy

How to provide default value for parameter if user don't provide any value
answered 18-04-2017 09:12:12 -0400

In our example we have two parameters which are optional. We want in such a way that if parameters are not provided we provide some default values. How to provide default value for parameter if user don't provide any values while executing VQL?

Answers: 1

VQL

Rest service in Denodo calling a Denodo Stored Procedure
answered 18-04-2017 08:45:38 -0400

I need to have a Rest service on top of a view that does 2 things. returns its result set inserts the records from its result set plus a few extra input parameters into a table on a different database. My first thought was do a Denodo proced...

Answers: 1

Find position of a certain character via VQL sql
answered 17-04-2017 08:16:32 -0400

I have a field with the following value (the file path and the file name): \N9000SF2\Investments\home_old\inv\HOME\HISIRXW\INVDB\INVDB FINAL 01 25 2008\Data Definition Reports\Rei Model Definitions.xls I want the result to be everything except the fil...

Answers: 1

VQL Vql

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