Latest Activity

code

How to query on different View using web services?

I have one Base view top of that I am creating 3 diffrent logic Derived view A, B and C. I want to pass parameter from web services like B then the query agains B derived view. If I pass C then the query agains C derived view. This is possible in Denod...

REST Webservice derived view Interface

code

How to deploy the derived view in the different environments (Staging/Production) from Development with updated fields without modifying the individual derived views?

I have created a "Selection" Derived View. I would like to add a field in the Derived View for "URL" in the final output for Tableau reports like "https://DevTableauServerName/DevReportname". So, I added like this, Output Tab -> New Field -> Fi...

derived view URL deployment

code

issue in accessing derived views in Alteryx

Hi, I have provided access for a derived view from denodo to Alteryx. The user is able to access the derived view from SQL editor in Alteryx. My question here is Can I view the list of derived views in the rightside navigation panel in the Visual Que...

access ODBC Alteryx derived view alteryx

code

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Parameterize slow query Parameter derived view Tableau

code

Denodo Training - Derived Views

Hello, I am taking the Denodo Training and i am stuck creating a derived view. Data Virtualization Developer Introduction - DEN60EDU0118LAB01 I do not understand how to convert parameters into a simple field.

training derived view

code

How to view execution history of a view

Hi, How to see the execution history of a base/derived view. I want to see the historical execution status of a view. the run time and the status of execution. Is there any way we can get the historical statistics of the views executed in denodo. S...

derived view execuion history

code

Creating an XML output view using the existing base/derived Views

How to Create an XML output using derived view ? for example: I have 3 base view Party, Party Address, Party Related Party. I will need to create an XML output, which needs to be published as SOAP Service. the structure should as below. <PartyServi...

XML DENODO XML Data Source derived view XML request to response

code

SQL queries ran on native Data source in VDP

Hello there, I just a few questions, I was wondering if you could provide me with an answer. How can I edit a SQL query that I created directly on the Data Source(Hadoop)? How should the SQL query be written, names the datasource, table, and fiel...

base view Hadoop Sql performance derived view

code

Derived view access issue from Alteryx

Hi, User wanted to connect to a derived view from Alteryx, So I have provided connect privilege for the respective database and read privilege to the derived view. Now the user is able to access the derived view from SQL editor in Alteryx but not able...

access ODBC Alteryx derived view

code

restricting access to derived views only.

Can we provide read access for a derived view to users without providing any access to base views. User is accessing views from another tool(Alteryx) through odbc connection. Thank you Sachi

Access derived view