Q&A

Connecting Denodo Platform Virtual Dataport to Denodo License manager
answered 12-11-2020 22:00:41 -0500

Hi I tried to configure the denodo platform control center to connect to my license manager port 10091. When I try to do that I am unable to connect because of incorrect host. Can you please tell what should I fill for the host? I tried putting 127.0.0...

Answers: 2

Threshold values
answered 12-11-2020 21:37:52 -0500

How many maximum number of connections Denodo can handle and how many connections can be active at a time? What is the maximum number of records Denodo can pull from Source? What will be the impact on live transactions at source while data is ge...

Answers: 1

mac can vdp administration
answered 11-11-2020 10:37:57 -0500

the user has a a n]mac laotop and wants to use the denodo platform control center. can this be installed on a mac?

Answers: 3
Related to: Denodo Admin and Development Best Practices

MAC os

calling a store procedure on db2
answered 11-11-2020 07:25:11 -0500

We have store procedure hosting on db2 zos server, we would like to create a base view on the store procedure. could you please help?

Answers: 1

Connecting to Denodo on AWS using VDP Error
answered 11-11-2020 04:47:36 -0500

Trying to connect to Denodo data platform server which was launched using marketplace AMI in AWS, trying to connect to that server using the passwd as 'instance id' and server URL //public-up-of-server:9999/admin Getting the following error: Could n...

Answers: 1

VDP

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