Q&A

Denodo MS SQL Server datasource: parameterized URI
answered 02-02-2021 07:08:37 -0500

Hi ! I'd like to be able to use the same view for different databases on the instance. That means to have same generic datasource (?) connecting to the same instance but different databases. Is this possible ? Interpolation variable in the URI ? there ...

Answers: 1

How to move the Denodo code from dev to testing
answered 02-02-2021 05:41:22 -0500

Hi Team, can you please share what is the best practice and stepd to be followed to move the code written for dev to testing enviornment. If any specifc documents which explains with best practices. Thank you

Answers: 1

DATAMOVEMENT Plan Error "There are '1' data movements defined in view 'view-name' for subview 'view-name-1' but there should be 2 "
answered 02-02-2021 05:23:02 -0500

I have created a derived view (view-name), which uses a base view, a view from different source to which I have read access (view-name-1), and data manipulation in WITH clause. Inside with clause view-name-1 is being used 2 times in query joins. As so...

Answers: 1

MDX command with UNSUPPORTED
answered 02-02-2021 05:00:09 -0500

Hi We are having issue with more than 50 columns in multi dimesion data source , we are seeing following error if more than 50 columns is that excpeted Data source SAP HANA Error executing BAPI: Invalid MDX command with UNSUPPORTED: > 50 CHARACT

Answers: 1

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