Latest Activity

code

IMPLEMENTATION of INTERFACE VIEW is automatically changing

Hi Team, In the interface view,for example we have 10 columns and during creation of interfaceview, all 10 columns are implemented with implementation expression and it is working fine. After sometime, the implementation expression for few columns disa...

implementation Interface

code

Using a select statment when implementing a interface

Hi everyone. I need to create an interface with dynamic values on the interface definition. I will give an example to show what I mean: Normally an interface is created this way: CREATE OR REPLACE INTERFACE VIEW i_inventory_50 ( productpartnumber_0:...

VQL Denodo 8.0 select Interface

code

How to show implementation details from an interface?

Looking for a way to export/show implementation details from an interface. How to retrieve this data? Desired solution is a VQL script which shows for interface(s) for example a format like: | Interface name | Interface Definition Field | Interface D...

Metadata Interface

code

Interface View

Hi, I would like to define the interface which has customer_key, customer_name, order_date and sales_amount. adding a implementation to that, i need to get the customer name from customer base view and all other columns from fact_Sales view. on the ...

Interface

code

List all interfaces with field names

We're looking to get a list of all our interfaces, with field names, and preferably attributes (ex. data type, max length). The end goal is to allow report developers to be able to search for all interfaces which contain specific field names. Is this p...

names Interface statistics

code

How to query on different View?

I have 3 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 Denodo ??

REST Webservice derived view Interface

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 deal with the changes on the Interface View (Implementation)

We need to change an attribute type from Array (register) to Nested object in a derived view, which impacted the dependent Interface and then the subsequent REST service. The moment we made this change the interface view model changes and the impleme...

Interface

code

Refreshing a service

I have a SOAP service as a data source. We created a base view for one of the the data providers of that service and then we created an Interface to publish our data. We now modified the service and added some more columns that we would like to publish...

Base view SOAP Interface

code

VQL for interface creation

On creating interfaces from derived views using denodo front end, I found that some decimal columns(in the derived view) were shown either as decimal or long datatype in the interface. I wish to create interfaces using vql script. Is it safe if I copy...

Interface