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.

Used By Views, through query
answered 14-01-2019 07:35:31 -0500

Hi Team, Denodo 5.5 Denodo 6 Base Views - BV1, BV2 Derived Views: DV1 = BV1 JOIN BV2 DV2 = BV1 UNION BV2 DV3 = Selection on DV2 So, DV1 is not used further. DV2 is used in DV3. DV3 is not used further. Question: How to get list of views which are ...

Answers: 1

Used by

Different roles within the same Distribution List
answered 14-01-2019 07:29:30 -0500

We have configured an LDAP authentication in our Denodo system. We have different databases created meant for different users but under the same Distribution List(DL). So if i want to assign privilege for a user to a particular database from the DL, wi...

Answers: 1

Access and Role Role and User Management

Migration Cycle
answered 11-01-2019 08:06:30 -0500

Hello, How can we compate two environment ( Dev and Test) ? after first migration I like to validate which objects are modify after first migration. Denodo have any tools or system where I can compare to environment.

Answers: 1

Denodo Testing Tool Integration with Test Rail
answered 11-01-2019 07:22:44 -0500

Hi Team, Could you please help me with following questions. Is there any possibility to integrate Denodo Testing Tool and VDP with Test Rail to run Tests from Test Rail instead of Command Prompt ? Can you please provide detailed steps to integ...

Answers: 1

Denodo Testing Tool

Integration between Denodo Data Catalog and Collibra using TIBCO as the middleware
answered 11-01-2019 06:48:14 -0500

Hello, Has anyone in the community seen an integration between collibra and denodo using TIBCO as the middleware in lieu of Mulesoft. Regards, Lorrin

Answers: 1

unable to find columns error when trying to read meta data from a JDBC data source
answered 11-01-2019 06:46:43 -0500

Hi, I know that the Generic JDBC data-source, is not fully supported (as it seems). However, it seems like there are some issues with it. I am working with a JDBC driver which is written "by the book" (meaning all the interfaces are implemented as nee...

Answers: 3

jdbc data-source

SAS data sources
answered 11-01-2019 06:34:37 -0500

Hello, I have followed the instructions at the following https://community.denodo.com/answers/question/details?questionId=90670000000XcmsAAC&title=Regarding+Denodo+Connectivity+with+SAS I know that I am connecting to a SAS Workspace server so am...

Answers: 1

How to achieve JSON custom format for array of values while applying Denodo nest()
answered 11-01-2019 05:21:35 -0500

Hi Denodo Team, I have created a base view with 3 employee records for Dept_id= 'D100' as below. SELECT 'D100' AS dept_id , 'E1' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E2' AS empid FROM DUAL UNION SELECT 'D100' AS dept_id , 'E3' AS empid...

Answers: 1

Nested Array DENODO REST Webservice JSON

How to do error handling on accessing data sources that we do not control + Different REST Web Service formats don't seem to return the same information?
answered 10-01-2019 10:31:48 -0500

Hello! There are two problems, that my team was wondering if there were answers to. The first problem: There are several data sources that we have no control over, and therefore can't tell if those services are live or not. My team was wondering how w...

Answers: 2

denodo platform XML Denodo Testing Tool REST Webservice json HTML Error Handling

How are the Surrogate key Field values maintained in Denodo
answered 10-01-2019 07:44:55 -0500

This is an interesting document on the approach for performing Type 2 SCD in Denodo. Can you help me understand the following. In the StarSchema on the web page aach dimension has an SK field. I am assuming these are Surrogate Key fields. How are the S...

Answers: 1
Related to: How to model slowly changing dimensions in Denodo

Surrogate key