SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Data Virtualization Tools and Software Denodo Platform and Data Virtuality Tutorials and Downloads for SQL Database Developer

Create and Deploy Denodo Business Views as REST Web Services


In this Denodo tutorial for developers, I want to show how easy it is to create and deploy a REST web service from an existing data view, either a base view or a business view created on the data model developed on Denodo data virtualization platform. REST web service creation and deployment of the web service is illustrated with a sample case step by step in this Denodo tutorial.

If you are using Denodo Platform on a cloud environment like AWS, you should enable port 9090 for on VPN connections, in security groups and Windows Firewall settings.

Launch Denodo Virtual DataPort Administration tool and connect to the database where the data view is created. You can open the view by a right-click and then click Open context menu option.

Denodo Virtual DataPort Administration tool

On the top right side of the view screen, developers can see a button named "Publish".
Click on Publish button and choose REST Web Service option.

publish View as REST Web service

A new tab will be opened for the REST web service of the data view.
On Resources tab, view data for the web service can be organized like removing or renaming view columns for the REST service.

On the resources tab, Denodo developer can rename the REST web service which is being created by clicking on the default name and typing the desired web service name.

rename web service on Denodo

Using Drop menu option some columns of the view can be removed from the REST service.

remove view fields from web service on Denodo

Developers can also rename view fields for the REST web service

remove fields from web service

If the developer switches to Settings tab, there he or she will find configuration settings for the REST service, its output types, limiting the number of returned rows for each page by enabling pagination, authentication settings and options, etc.

Denodo REST web service settings

Using Set default representation the default REST service return type can be set among the options HTML, XML, JSON and RSS

web service representations among JSON, XML, RSS and HTML

There are a number of Authentication options that the Denodo developer can use for securing the REST service calls and prevent unauthorized access to the Denodo business view data.

Authentication methods for consuming Denodo Web service

I will continue with "None" option for the sake of this Denodo tutorial.

After the developer is finished with REST web service configuration, he/she can save the service configuration using the Save button.

save Denodo REST web service

After the web service is saved for the first time, it will be in status "Not deployed"
Click on the Deploy button to publish the REST web service.

deploy web service using Denodo data virtualization platform

When the Deploy button is clicked, a popup screen will be displayed.
The developer will be defining the credentials used by the web service to connect to Denodo Virtual DataPort server.

privileges for Denodo web service during deployment

Select the appropriate option and click Ok to continue publishing the Denodo web service.
The Deployment status is now changed to "Deployed"

Denodo REST web service deployment details on Virtual DataPort

The web service is deployed to address /server/{database name}/{web service name}/
The database of the data view was "poc" and I renamed the REST service name to "appdetails"
I can now launch a web browser and can access the web service by calling the URL as seen below:
http://10.159.85.54:9090/server/poc/appdetails/

call Denodo web service using Internet browser

If you click on "Search View" link button, you can configure a search URL and display the data rows returned by the web service call.

Denodo REST web service published using data view

Since during configuring the REST web service, I limited the size of the responses to maximum 1000 number of rows, I had a paginated with and a "Next" link on the HTML representation of the web service call return.

I have installed the Denodo Platform on an EC2 server on AWS cloud environment which is connected to the company intranet using a VPN connection. For a successful connection, first of all the port 9090 should be opened on VPN connection. The Denodo server should accept inbound connections over port 9090. Admnistrators should check the Windows Firewall settings and enable port number 9090 to accept connections. On cloud, in an AWS infrastructure, the security group settings for inbound connections should be also checked for TCP traffic over port 9090. After all these security configurations, developers can call REST web service which is developed on Denodo server based on a data view and deployed or published for general availability according to the authentication method chosen during configuration settings.

I hope, this Denodo tutorial showing developers to publish business views as REST web services is useful for all.



Data Virtualization


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.