Q&A

How to do a Denodo integration with external KMS systems to decrypt a CSV and use it as a data source
answered 11-11-2020 00:36:55 -0500

Lets say I have an encrypted CSV file, whose encryption keys are managed by AWS KMS or any other 3rd party KMS. Now I want to use this CSV as a data source for Denodo. How can I setup denodo to use the decryption keys from KMS and then read the CSV con...

Answers: 1

Key management systems

Duplicate Rows after "Group By" query
answered 10-11-2020 06:04:25 -0500

Hi, I'm currently having some issues with a query that I've created. I created a derived view, deriving from quite a huge dataset. I used the "Group By" SQL aggregation to group my query results by "ReportDate". However, i realised that quite oddly, th...

Answers: 1

combine rows
answered 10-11-2020 05:30:09 -0500

I have a table like this ItemNbr Identifier Value 123 plant C01 123 plant C02 123 mrp M01 123 mrp M02 456 mrp M03 I want like this ItemNbr plant mrp 123 C01 M01 123 C02 M02 456 null M03 I tried creating 2 different views based on Identifier column ...

Answers: 1

Pivot

Sap Bw DSO with Denodo
answered 10-11-2020 05:19:55 -0500

Hi Team , We are creating bv for DSO table in denodo using Denodo RFCReadTable Custom Wrapper ,We were able to pull all column but we are missing out few column like Reference_date(Key date) any suggesion will be of great help Thanks in advance

Answers: 1

SAP BW

Denodo Query Optimizations for the Logical Data Warehouse - is this KB article not applicable for Denodo 8 ?
answered 10-11-2020 04:42:51 -0500

Hi Team, While going over the below KB article, I found that it is applicable only to Denodo 7, 6 and 5.5 https://community.denodo.com/kb/view/document/Denodo%20Query%20Optimizations%20for%20the%20Logical%20Data%20Warehouse Is it not applicable in De...

Answers: 1

Query optimization in Denodo 8

[help needed] Denodo API development
answered 09-11-2020 07:42:39 -0500

We have a case that the API inputs will be array format , can you pls provide a sample and guidance that can show us step by step. And have a meeting to show us how to handle this case as below by sharing desktop will be great. For example: Input form...

Answers: 1

Denodo Testing tool-1
answered 09-11-2020 07:25:05 -0500

Hello, I have one API which has authentication of OAuth. How can I test A API with authentication?

Answers: 1

Denodo Testing Tool

Unable to connect Excel 2016 to Denodo environments
answered 09-11-2020 05:52:43 -0500

Hi. I am unable to connect an Excel workbook to our Denodo environments via a ODBC connection. It's odd because this worked perfectly earlier this year (spring/summer). I don't know what changed. We did apply a patch and upgrade in late August. This is...

Answers: 1

Creating base view for REST API whose access token changes frequently
answered 09-11-2020 05:40:28 -0500

I have a REST API created whose access token changes every 2 hours. How do i create a base view on top of that. I want the access token to be automatically passed at the run time, whenever denodo queries the data source through base view. I followed ...

Answers: 1

Denodo Increamental Cache Load
answered 06-11-2020 09:07:54 -0500

I am using Denodo V7 and I have enabled full Cache on a view in Denodo. Now I am trying to set up an incremental Cache load for this view through the Denodo Scheduler. But I keep getting an error which goes like this 'Error executing query. Total tim...

Answers: 3

Denodo Incremental Cache