Latest Activity

code

Java SpringBoot application - Could not obtain connection to query metadata : com.denodo.connect.hibernate.dialect.DenodoDialect does not support ddl operations

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:...

code

Connecting Denodo to sql server management studio

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

code

Pass results from one query to where clause of another

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...

code

Connectivity between DataRobot & Denodo

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

code

How to pick the last record from duplicates?

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 ...

VQL
code

REST service data source for large amount of data

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...

code

Is there something in Denodo similar to Identity Column uses in DB2 to create an unique sequentially primary key?

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...

code

Need A simple picture to know how Denodo solutions can finish GET & POST jobs

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....

code

Need syntax how to pass multiple values in restapi url for input parameters

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 (...