Latest Activity

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

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

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

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

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

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

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

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

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

Creating a new column in derived view

Hi team, I created a derived view from two base views. In this derived view I want to create a new column doing the following transformations to the data: I currently have this column existing column street: value: 'streetname123' I want to create a...

Data Quality derived view