Web Service and NonStop – Accessing from Microsoft Office – Overview
Updated: Dec 29, 2022
I have always been interested in understanding the different kinds of applications customers are developing on their NonStop systems. I believe that it is not enough to use technology for the sake of technology itself. The more important part is to understand how to use it to solve a REAL problem. In talking with many different NonStop users through the years, I have learned about a lot about their many different interesting applications.
Take for the example, in the area of SOA and Web Services. We know how Web Services and SOAP enable applications on NonStop can communicate with applications on other platforms, such as .NET, Java, mainframe, etc. And all that works very well.
But when I was talking to my friend Tom Schaper, who works for Cass Information Systems, Inc. in St. Louis, MO, he showed me some really interesting things that he had been doing with Web Services that I haven’t seen before.
Tom has developed some practical programs based on Microsoft Office products working in conjunction with SOAPam Server on the NonStop, such as:
Populate Microsoft Excel spreadsheet with data from COBOL Pathway Server
Using Microsoft Word as a development editor tool to manage files on NonStop
The principle is to use Microsoft Office as a Web Service client to interface to Pathway servers on the NonStop.
So I asked Tom to share information about his projects in our recent Webinar last month, which was very well received. There’s a lot of additional information that didn’t make it, so we decided to create this Blog series to cover some of the following topics in more detail:
Web Service 101 and SOAP/AM
Step-by-step tutorial on developing on the Excel code sample
Demo of the Word VBA code sample
We are going to start off with the “Web Service 101 and SOAPam”, which covers the basic concepts of Web Service and an overview of the SOAP/AM Server product for the NonStop.
To learn more about the basics of Web Services, click here.
Do you find this tutorial blog helpful? Let us know what you think, and how we can make it even better. Don’t forget, you can subscribe to our blogs to get automatic email notification when a new blog is available.
Phil Ly is the president and founder of TIC Software, a New York-based company specializing in software and services that integrate NonStop with the latest technologies, including Web Services, .NET and Java. Prior to founding TIC in 1983, Phil worked for Tandem Computer in technical support and software development.