PeopleSoft Simple Web Services

The Simple Web Service (SWS) module is a small but powerful PeopleSoft bolt-on that makes web services easy, very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes. It enables you to quickly define new PeopleSoft web services with only configuration. There is no coding other than SQL. It supports CSV, JSON and XML output encoding.

The traditional method of developing web services in PeopleSoft can take weeks to months to develop even a relatively simple web service because:

  • You need a developer to get involved that has experience working with web services and understands the design constraints.
  • There are the complexities of setup, code, migration, and security.
  • Making iterative changes is time consuming and expensive.
  • The Integration Broker documentation is not great.

SWS liberates you from that complexity and allows your organization to “free” the PeopleSoft data quickly. You provide the SQL and the SWS module handles all the other complexity.

SWS Features

  • You can define a new web service with only configuration in a few minutes.
  • There are zero code migrations.
    • After the initial product install, there are zero code migrations for new web services.
    • Changes to web services are all done in the web browser.
  • If you know how to write SQL, you can create a web service.
  • There is no need to write any PeopleCode or have any real knowledge of Service Operations, Services, Messages, Handlers, etc.
  • One configuration supports JSON, XML or CSV output encodings automatically.
  • You can quickly decommission web services that are no longer needed with one check box.
  • SWS generates a consistent output format so applications using the services can quickly experiment with and implement integrations without have to drastically re-implement data parsing logic.

Limitations

In the current release of SWS, only “GET” web services are supported. These are web services that run SQL and export data out of PeopleSoft. Upon customer feedback, we will look to support inbound (POST/PUT) operations.

Product Road Map

  • Version- 1 - Current Release
    • Support for Get REST Web Services
    • Support for CSV, JSON and XML output encodings.
    • Support for naming output columns
  • Version - Future - Pending Customer Feedback
    • Support or “Drop Box” style web services
    • Support for nested SQL and parent child relationships
    • Support for custom code plugins and event hooks
    • Support for stored procedures

Product Documentation

Alternatives

There are a few alternatives to our solution.

Query Access Web Services

We have an KB article called Reporting Web Services: Using the REST Web Services to run a Query which demonstrates how you can make a “web service” out of a PeopleSoft query manager query. This can be an effective tool to generate web services.

However, the SWS offers many advantages over this delivered functionality.

  • You have better control over the field names in the output.
  • SWS offers more output encodings.
  • The PeopleSoft query tool imposes unneeded complexity with data security and query tree security that often just gets in the way.
  • SWS supports more advanced SQL and you are not forced into the SQL generated by query manager.

Traditional PeopleSoft Web Service Development Cycle

Another alternative is to get a developer to create a new web service for each department or vendor request. If a vendor commissioned the PeopleSoft application team to develop a new web service, the following process would likely be followed. This assumes you are a medium to large organization with a formal development process.

Task Minium Estimated Person Hours Maximum Estimated Person Hours
Gather Requirements 5 10
Write a technical specification 5 10
Technical Design Review 2 10
Create and unit test code 8 40
Functional Testing 8 40
Code Review 2 10
Code Migration 2 4
Bug Fixes 4 10
Totals 36 Hours - $3,600 @ $100/Hour 130 Hours - $13,000 @ $100/Hour

If you value your developer’s time at roughly $100 an hour. Then the cost to develop a new web service is somewhere between $3,600 and $13,000. With SWS, that amount can be drastically reduced. In some case, it can take just a few minutes to create a new web service and have it deployed in production.