Top 5 Trends in REST Services – Database Access via RESTful API Using LightWave

In an enterprise, there are many different data sources that are produced and consumed in many different departments. Instead of being tied to the proprietary access of each database, the use of a web service API will make integration with these myriad of data sources much easier. RESTful web services will provide a data access layer that’s more flexible and compatible with different applications, including mobile, web or cloud services. Many database vendors now provide access to their databases using RESTful APIs. They include Oracle, and MS SQL Server, the two leading databases in the marketplace.

This blog discusses the benefits of using REST, and how the LightWave product suite from NuWave enables NonStop applications to take advantage of data access using RESTful API easily and simply.

 

Oracle REST Data Services (ORDS)

ORDS enables external client applications to access Oracle databases using RESTful API from any language environment, without installing and maintaining client drivers. This is especially important in the case of NonStop, where no native Oracle client driver is available. This enables the use of standard HPP calls (GET/POST/PUT/DELETE) via URI to get to the appropriate database and have data items returned in a JSON payload. The advantage of using REST is that it is simple and easy to set up, and it scales.

Text Description automatically generated

Microsoft SQL Server

Microsoft SQL Server from Microsoft is the most popular relational database management system used in business organizations. Almost every user that uses NonStop also has one more instances of MS SQL Server running within the enterprise. In many cases, there is a need to exchange data between the NonStop applications and SQL Server tables. While there are already data replication tools available between NonStop and SQL Server, there is no native SQL Server client driver available for online transaction access from NonStop applications. However, Microsoft has introduced access to SQL Server via a REST API, which enables REST clients to easily access a database. This can be done by using Microsoft SQL Server Integration Services (SSIS), or by using Node.js.

Arrow Description automatically generated with medium confidence

So, we see that both Oracle and MS SQL Server allow REST cliens to access their databases. So what you need on the NonStop is the ability for an application to function as a REST Client.

LightWave ClientTM

LightWave ClientTM provides the ability to securely access REST services from your HPE NonStop. As SOA (service-oriented architecture) or APIs becomes widely adopted with NonStop customers and users, the necessity of integrating mission critical legacy applications with the larger enterprise has become more prevalent. LightWave ClientTM provides HPE Nonstop applications with the ability to act as a REST client and securely access REST Web services anywhere, on any platform or operating system.

Your NonStop application simply sends a formatted interprocess message to the LightWave ClientTM Process which handles all of the details of mapping the IPM elements to a JSON or XML message, exchanging the message with the Web service provider, and parsing the JSON or XML response into the reply IPM. The LightWave ClientTM process hides the complexity of the TCP/IP, HTTP, SSL/TLS, JSON, and XML protocols required to access REST Web services.

LightWave ClientTM also provides a browser-based Console to easily create, view and edit API definitions needed to access remote REST web Services. Using the Console, one can simply point-and-click to build the API and messages that allow any NonStop applications to consume REST services.

Graphical user interface, text, application, email Description automatically generated

In addition, you can create an API definition by importing a Swagger definition, e.g. one from ORDS.

Simple Swagger example from ORDS

Once the API is defined in LightWave ClientTM, you can build applications to consume the remote RESTFul Web Services, including ones that provide access to Oracle or MS SQL Server databases.

Timeline Description automatically generated

Conclusion

Introducing a REST layer to database access allows an organization to centralize data access logic and exercise tighter control of security. It also enables different client platforms, including HPE NonStop, to access the needed business data, without being tied to the underlying database implementation. Using RESTful APIs to access external databases opens up new opportunities for HPE NonStop applications to interoperate in the enterprise. Any NonStop application can have real time access to different databases, including Oracle, MS SQL Server, etc., using a common industry standard. LightWave Client is the best tool to help HPE NonStop users implement RESTful API applications easily, quickly and safely.

Authors

  • Dave Belliveau

    Dave Belliveau is the CTO of NuWave Technologies and has spent more than 30 years developing middleware for HPE NonStop servers. Before joining NuWave, Dave was the architect and developer of Remote Server Call, the original NonStop client/server middleware. That experience, combined with his work on NuWave's next-generation SOAP and REST middleware products, makes Dave one of the leading experts on NonStop modernization and cloud integration.

  • Phil Ly

    Phil Ly is the president and founder of TIC Software, a New York-based company specializing in software development and consulting services that integrate NonStop with the latest technologies, including Web Services, .NET and Java. Phil’s passion for NonStop, and educating the larger technology community – both industry veterans and next gen alike – on the power the platform leverages, are central to TIC’s business philosophy. While Phil (and TIC) have always evangelized modernization as a NonStop keystone, he is especially focused, as of late, on identifying applications and services to “future proof NonStop,” so as to extend the platform’s efficacy and impact for years to come. Prior to founding TIC in 1983, Phil worked for Tandem Computers in technical support and software development.

Be the first to comment

Leave a Reply

Your email address will not be published.


*