Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

how to identify cache table is active or not
answered 15-03-2019 08:40:14 -0400

Hi Team Suppose I have a View : Employee and it's having a cache Table in Oracle as : EMPTABLE, now I did some changes to the same Employee view and now Cache Table changed to : EMPTABLE1, so in this way there is a invalid table in Cache DB with name ...

Answers: 1

REST Service supporting transnational write back
answered 15-03-2019 07:13:17 -0400

Hello, Is the Denodo REST service supports write back operations involving transactions? I am trying to achieve the following. Begin Transaction - Post to View-X - Delete in View-Y - Patch to View-Z Commit Transaction If this is supported how t...

Answers: 1

Write-back scenarios REST API

analytic function error
answered 15-03-2019 02:48:18 -0400

Hi Team How i am suppose to implement following logic in denodo , i tried to delegate row_number() to DB but geeting execution error row_number() over (partition by ID order by idno) error Finished with error: Syntax error: Exception parsing que...

Answers: 1

handelng leading zeros
answered 14-03-2019 13:34:21 -0400

Hey Team, I have a Database (SAP) that I connect via the custom wrapper (RFC Calls). In this I have a column that contains leading zeros. It usualy contains int with 8 digits but itis saved as text with 10 char (2 leading zeros). Is it possible to map ...

Answers: 2

VDP SAP leading zeros

Need help on selecting appropriate server on AWS
answered 14-03-2019 06:43:23 -0400

Hi, I am planing to move on AWS, Denodo 7.0 version with 2 data sources, concurent queries sassumed to be > 50 and <=100 and daily volume could be around 2.5 million records.# Which option should I go with m4.xlarge or any smaller solution will...

Answers: 1

Connectivity between Oracle DVD and Denodo
answered 13-03-2019 08:51:49 -0400

Hi, I am trying to connect to Denodo from Oracle DVD. I have some data on Denodo platform and would like to create some visualizations on Oracle DVD or Oracle analytic cloud. I am trying to connect using ODBC connection but its not working. Could you ...

Answers: 5

AWS Annual Licensing plan
answered 13-03-2019 05:12:25 -0400

Hi Team, I have gone through the link in the AWS Market place, https://aws.amazon.com/marketplace/pp/B07DRN4Y74?qid=1551689634198&sr=0-1&ref_=srh_res_product_title The recommended server configuration is an "m4.xlarge" instance. The licensing...

Answers: 3

Which version of Denodo officially supports SQL Server 2017?
answered 13-03-2019 04:57:29 -0400

Hello, Which version of Denodo officially supports SQL Server 2017? Where I can find this information and about other supported databases as well? Kind regards,

Answers: 1

Silent Uninstall
answered 13-03-2019 04:20:57 -0400

I'm looking for a way to silently uninstall the denodo admin client from user workstations. I was hoping it would be similar to the silent install steps, but no joy so far.

Answers: 3

Unattended Silent Uninstall

How to Delete Database from GitHub when it is Deleted from VDP Admin Tool
answered 13-03-2019 00:30:51 -0400

I have GitHub for Version Control. When I delete a Denodo Database using VDP Admin Tool, the database disappears from the VCS Management list but does not disappear from GitHub. How can I make it so the database also gets Deleted from the GitHub repos...

Answers: 1

Delete Database Version Control