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 Denodo ??
user
10-07-2019 09:27:07 -0400

1 Answer

Hi, As previously answered on a similar community question, [How to query on different View?](https://community.denodo.com/answers/question/details?questionId=9060g000000XenJAAS&title=How+to+query+on+different+View%3F) you can achieve your scenario by connecting to the Virtual DataPort instance where the views A, B, C are created. For instance, if you are working in Denodo 7 you need to create a new JDBC Datasource with a Database adapter “Denodo Virtual DataPort 7.0“ and create a base view using the option “Create from query” with interpolation variable. Select * from @view_name. On publishing this base view as a web service, you will be able to pass the derived view names as an input parameter. Note that the schema of the base view is fixed at create time, this would only work for views with the same schema and column names. Hope this helps!
Denodo Team
11-07-2019 06:21:13 -0400
You must sign in to add an answer. If you do not have an account, you can register here