Q&A

Delimited File sources with DateRange
answered 02-11-2020 03:49:16 -0500

Could someone provide an example which works for using Delimited Files with a date range in the file name (or path)? I have given up our own design for now, and I am currently trying to recreate the example from "Virtual DataPort Administration Guide"...

Answers: 10

Interpolation Variables Delimited Files

How to change default port of Virtual DataPort Server 9999 to other available port?
answered 02-11-2020 02:21:11 -0500

How to change default port of Virtual DataPort Server 9999 to other available port? I'm using Denedo Express 64Bit version. Thank You! LakshmiNarayana J.

Answers: 4

64-Bit Windows Virtual DataPort

Error executing bcp command.
answered 02-11-2020 01:57:02 -0500

We are trying to load a cache for salesforce database view with full cache mode on (Incremental query) refering the link below https://community.denodo.com/kb/view/document/Incremental%20Queries%20in%20Denodo but when we try to execute this (selecting ...

Answers: 1

Error executing bcp command.
answered 02-11-2020 01:48:00 -0500

We are trying to load a cache for salesforce database view with full cache mode on (Incremental query) refering the link below https://community.denodo.com/kb/view/document/Incremental%20Queries%20in%20Denodo but when we try to execute this (selecting ...

Answers: 1

Derived View problem in Migration
answered 30-10-2020 03:52:37 -0400

I migrated my databases from Denodo 7.0 to Denodo 8.0 and in that I lost my Derived View from the database. I normally get vql and properties files from Denodo 7.0 and after getting started I received this problem. Please get me for this as soon as pos...

Answers: 1

Denodo 8.0 Denodo 7.0 Migration

Creating Json, confirming to open targets schema from any datasource,
answered 30-10-2020 01:56:17 -0400

Hello, I have tried to search for this in denodo if I can call any Api or other data in other form into JSON and I cannot find anything. SO is it possible to get any such data in JSOn format always irrespective of data Source form? Any way of conver...

Answers: 1

JSON

Hibernate
answered 28-10-2020 07:48:34 -0400

Hello, There is a usecase to read data from Denodo using Hibrnate. It's just a read only case, where we just want to pull data from Denodo to a client java application using Hibernate. Is there a hibernate Dialect which can be used for this. Do we kno...

Answers: 6

Is there a Hibernate Dialect for Denodo 8.0?
answered 28-10-2020 07:46:52 -0400

Hi, Denodo 7.0 has a Hibernate Dialect that allows Hibernate to generate the appropriate VQL code to interact with Denodo 7. My team is trying to use Hibernate with Denodo 8.0, and I cannot find anything on the Denodo community site about a Hiberna...

Answers: 3

Hibernate driver connector

What is the Java version requirement for denodo-vdp-server.jar for Custom Wrapper development
answered 28-10-2020 06:01:25 -0400

We have denodo 7 running java version "1.7.0_261" OpenJDK Runtime Environment (amzn-2.6.22.1.83.amzn1-x86_64 u261-b02) OpenJDK 64-Bit Server VM (build 24.261-b02, mixed mode) Tried to compile a sample Custom Wrapper using Java7 (major version 51) and ...

Answers: 1

Custom Connector

Multiple Nest()
answered 28-10-2020 05:53:52 -0400

Hello I am attempting to create multiple nests in my json output within denodo. I have the following vql statement in the derived view; CREATE OR REPLACE VIEW dv_view2_name FOLDER = '/03 - business entities/project/03 - derived views' AS SELECT ...

Answers: 1

Nested Array API nesting