Q&A

Denodo User Groups
answered 01-02-2021 07:17:37 -0500

Is there existing Denodo user groups for benchmarking? I would like to get feedback on how Denodo Security is implemented from other organization using Denodo.

Answers: 1

Java SpringBoot application - Could not obtain connection to query metadata : com.denodo.connect.hibernate.dialect.DenodoDialect does not support ddl operations
answered 01-02-2021 07:04:36 -0500

Hello, Am using Spring Boot 2.3.4 and spring-boot-starter-data-jpa in order to connect to denodo 8.0 My application.yml is as follows spring: jpa: open-in-view: false show-sql: true generate-ddl: false hibernate.ddl-auto: none properties: hibernate:...

Answers: 1

Denodo 8.0 Access Denodo Express does not support ddl operations JDBC com.denodo.connect.hibernate.dialect.DenodoDialect ddl

Connecting Denodo to sql server management studio
answered 01-02-2021 07:02:29 -0500

will be able to connecct denodo with sql server managemen studio as like connecting denodo with DB visualizer? if yes how can i do that? steps plz

Answers: 1

Pass results from one query to where clause of another
answered 01-02-2021 05:11:11 -0500

When querying across datasources, how can the results of one datasource be passed along to the other? When simply using a join Denodo is getting the results from one datasoruce and then essentially a select * against the second datasource before perfor...

Answers: 1

Connectivity between DataRobot & Denodo
answered 31-01-2021 19:16:21 -0500

Hi, I would like to know if there is connectivity between Denodo & DataRobot i.e. can DataRobot tool connect to Denodo & vice versa? Thanks & Regards, Nisarg Shah

Answers: 3

How to pick the last record from duplicates?
answered 29-01-2021 15:03:02 -0500

Say I have a table with 3 columns: A, B, C. See below. Column A Column B Column C 1 11 21 1 12 22 2 13 23 2 12 24 3 14 25 ...

Answers: 2

VQL

REST service data source for large amount of data
answered 29-01-2021 04:31:48 -0500

I have a REST service data source containing a few million product items. How are VSQL query parameters such as ItemId converted to the query parameter on that source REST service? Does Denodo have to pull all 3 million items and then filter the resul...

Answers: 3

REST Data Source

Is there something in Denodo similar to Identity Column uses in DB2 to create an unique sequentially primary key?
answered 29-01-2021 00:33:31 -0500

DB2 has an identity column used as primary key (DB2 automatically generates a monotonically increasing or decreasing sequential number for the value of that column when a new row is inserted into the table. Example CREATE TABLE T1 (CHARCOL1 CHAR(1), ID...

Answers: 1

Need A simple picture to know how Denodo solutions can finish GET & POST jobs
answered 28-01-2021 05:21:54 -0500

I tried creating data source to GET and POST data in respective two sides. I also read how to create new web services and XSLT transform over the data that I got. But I still am stuck of how to connect date I get , transform , and consume POST service....

Answers: 1

denodo express Consume service XSLT MApper Transform

Need syntax how to pass multiple values in restapi url for input parameters
answered 27-01-2021 17:50:43 -0500

I tried this way but didn't work in postman Query1: 1.https://denodo server url /server/inventory/InventorySummaryAPI/views/InventoryOnHoldSummaryAPI? $filter=”fctry_id” in (ABC,EFJ,IJK)& $filter=”opr_id” in (12,13,45) & $filter="strg_cd" in (...

Answers: 1

#denodo 7.0 #API #Rest_API