Q&A

Scheduler job for CLEAN_CATCH_DATABASE Procedure.
answered 02-11-2020 07:04:21 -0500

Hello, I have configured a scheduler job that calls : CALL CLEAN_CACHE_DATABASE ('@db_name') ; I have been able to pass on the VDBs name using query in Extraction section using the below query with mapping set as "db_name=database_name" select dis...

Answers: 1

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 7.0 Denodo 8.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