Home / Q&A / All Questions

Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Group by clause based on parameter
answered 08-05-2020 03:13:51 -0400

Denodo version 6 My question is I want to use "group by option" based on condition ie if I have parameter say Item, lot then its should group Item and Lot. Only item parameter is provided it should group by Item only...Is there is any way to acheive i...

Answers: 2

Can Denodo connect to files at AL11(t-code) application server of SAP BW
answered 08-05-2020 02:40:01 -0400

Hello Team, Can Denodo consume files at AL11(t-code) application server of SAP BW. When we connect any SAP BW system, it give infoarea structure only. Regards, Vijay

Answers: 2

SAP BW

Denodo Data Catalog: Having Clause
answered 07-05-2020 11:51:01 -0400

Hi, Even though Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query using the GROUP BY clause, this functionality is not available in the Data Catalog that diminishes the value of the queries. Any attempts to add...

Answers: 2
Related to: Oracle SQL to Denodo VQL Quick Reference

Group By Having Clause Data Catalog Denodo Data Catalog. Version 7.0

How to connect to Denodo VDP using Oracle SQL Developer?
answered 07-05-2020 00:37:41 -0400

Is it possible to connect to Denodo VDP 7.0 using Oracle SQL Developer client using Denodo JDBC Driver?

Answers: 1

JDBC

Denodo Data Catalog.v.7.0: Request for Having Clause
answered 06-05-2020 17:55:30 -0400

Denodo Data Catalog. Version 7.0 According to https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/having_clause/having_clause the Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query...

Answers: 1

Having clause Data Catalog Denodo Data Catalog. Version 7.0 Group By

Error while connecting to Azure data lake storage GEN2
answered 06-05-2020 09:16:34 -0400

Hello Team, I am trying to create Datasource based on Azure data lake storage GEN2. Till i save all the configuration, it goes fine. When I try creating base view, it throws below error: There was an error while creating this base view: Error while e...

Answers: 7

OpenOffice Data Source Classeur ODS SXC
answered 06-05-2020 08:01:30 -0400

Hello, Can DENODO connect to a DataSource of OpenOffice likeCalc File with extension ODS or SXC ? tnx

Answers: 1

OpenOffice Classeur ODS DataSource

how to pass the query params to denodo as json HTTP client.
answered 06-05-2020 07:23:33 -0400

i have a requirement to connect the json HTTP client to denodo . the url looks like this: https://<servername>/excer/yhn?$format=json&filters=alud:%2210/1/2019%22 something like above.. please help me on how to execute the same in denodo. ...

Answers: 1

Delete flag option at exporter section Denodo scheduler
answered 06-05-2020 05:45:55 -0400

Hi , please I want to ask about the delete flag option at exporter section at Denodo scheduler ..as when I enable it , all rows deleted even the exporeted rows ? also I want to ask if there is option to delete the rows (which i extract it ) from source...

Answers: 2

Exporter section Job scheduler

Change Management
answered 06-05-2020 05:23:10 -0400

Does anyone have a change process mapped out which they can share. For example what steps do you follow if there is a change in the source system table / file. i.e. attribute added, attribute changed, attributed deleted etc.

Answers: 1