Q&A

Check the feasibility of installing denodo express on UNIX/Linux box without UI
answered 16-06-2020 07:23:33 -0400

HI, is there any way to install denodo express on Linux box and use the VDP via web URL?

Answers: 1

How to consume Denodo RESTAPI (based on HANA view with input parameter) inPowerBI
answered 16-06-2020 06:59:47 -0400

Hello Colleagues, I have a requirement where I am having a Denodo base view which is built on SAP HANA view having input parameter. I have generated RESTFUL API from Denodo and when i run it, it says we need to in put as follow: There was an error ...

Answers: 1

List of Roles and complete hierarchy
answered 16-06-2020 05:43:07 -0400

How do i get the list of roles in Denodo and the complete role hierarchy?

Answers: 5

Role and User Management

Not able to pull requests from GitHub
answered 16-06-2020 03:43:57 -0400

Hi, I am working on Denodo 7.0 and recently configured GitHub with Denodo. Seems like I am not able to pull any requests from GitHub. Please help. Thanks, Naveed

Answers: 1

GitHub VCS

How to get data from different sources, without errors.
answered 16-06-2020 02:32:27 -0400

I have an selected view that uses like input an excel file, and I have another selected view that uses a CSV file like input. I want to have an union with those selected views, but if one file is missing I get an error. How can I avoid this error? I...

Answers: 4

VDP Denodo view

Scheduler Admin Extraction Section and Exporter Section
answered 16-06-2020 01:23:12 -0400

hello, I created a scheduler job. below is the query I have in "Extraction Section"(using Parameterized query option) and I am dynamically getting the gtin value from "list" source. select from ent.dv_extractaxwaysns where dv_extractaxwaysns.gtin='@gt...

Answers: 2

Job scheduler Denodo Scheduler 7.0 Scheduler Admin Extraction

Access to view data in CustomPolicy class
answered 16-06-2020 00:02:45 -0400

We have a need where we will receive user roles as a view parameter value, then that parameter will be parsed within a custom policy to make sure the role exist, then that role needs to be translated to actual values (which exists in a view within a co...

Answers: 3

Denodo 7.0 custom policy

WebService Dependencies
answered 15-06-2020 13:59:37 -0400

Is there are way I can get DEPENDENCIES (VIEW_DEPENDENCIES) similar way that we can get for base, integrated and business views?. Looking for a way to get Lineage from "Web service-Business-integrated-Base-Datasource" via command (VQL). Also, any way ...

Answers: 1

WebService view_type

SQL Server date datatypes error in conversion for base views
answered 15-06-2020 04:04:07 -0400

¡Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...

Answers: 1

Date Conversion Base view datetime Error SQL Server

SQL Server date conversion error in BaseView
answered 15-06-2020 04:02:11 -0400

Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...

Answers: 1

Date Conversion Base view VDP 7.0 SQL Server