Q&A

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

Scheduling Cache Problem with Base View
answered 28-10-2020 04:03:19 -0400

Hello, My base views evertime needs a session id to fetch the data(execution). SO I have used an interpolation variable for feeding session key. Session key is generated in different table to whom I usually point when I create a derived view so ...

Answers: 1

Cache

caching load
answered 27-10-2020 08:09:15 -0400

There is a job called call_res which is loading data from Netezza to the Caching DB, from the execution trace I can see that all the stages are finished in minutes, however still running on the Scheduler and may take hours to report complete status in ...

Answers: 1

New Role, admin feature errors with hyphen
answered 27-10-2020 03:49:53 -0400

Seeing some strange behavior as an admin in my denodo Rolemangement screen. when I try to create a rolename with hyphens, ie "rolename-john' I get a 'Verify the folliwing issue > Name: Invalid field name." I know it used to work as we have roles ...

Answers: 1

role management admin roles newrole

Re-access the classes I had access to
answered 26-10-2020 15:48:21 -0400

Good Morning, Is it possible to get access to the original course that I was watching, I think I was about 50% in and then work got in the way. Please let me know. Regards, Norman Marzan Centene Corporation

Answers: 1

How to insert data into Hana
answered 26-10-2020 13:10:55 -0400

Hi team, I have a requirement to call the SQL data which i wanted to insert into HANA table. please guide me best practice using denodo. Is CRUD operations possible from denodo?

Answers: 1