Q&A

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 JSON REST Webservice

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

Any guidance on keeping base-views from impala data sources "fresh"
answered 10-01-2019 07:42:06 -0500

Hello, Impala data sources cache data. Occasionally, we encounter views which fail due to an error that essentially says, the cache is out of date. If we execute "invalidate metadata" in impala, the error goes away. How do people automate this? Sche...

Answers: 1