Introduction to SWS

Welcome to the SWS product created by Cedar Hills Group, Inc.

• SWS is a bolt-on PeopleSoft Application Designer project that allows you to create web services with configuration only. We assume you read about it on the SWS Product Page.
• Check out the Your First SWS Service to see how fast you can create web services with configuration only.
• You should first read about SWS Concepts to get an understanding of how to think about SWS configuration and requests.
• Then you need to get SWS installed using the installation documentation
• Then read about the detailed SWS Configuration Options
• Not sure why you should use web services? I would check out the Why Use Web Services? chapter of our book.

When you install the SWS from Cedar Hills Group, it has two PeopleSoft web services that have very different use cases and audiences.

• SWS Get Services - You will use this method 95% of the time.
• PsoftQL Web Services
  • This is a more advanced method to extract PeopleSoft data for a system integrator or outside vendor.
  • You generally will NOT open up this web service to many users. This is geared toward internal integration tools like Mulesoft, Snaplogic, and Boomi.

SWS Get Services

The easiest and most secure way to expose your PeopleSoft data is by using SWS-configured web services. This method gives the PeopleSoft admin control over what data is exposed to third parties and is a more secure model for most use cases. You can read about how to set up a new web service in the SWS Configuration Section.

• A PeopleSoft power user
  • Configures a new SWS configuration with either SQL or PsoftQL Syntax.
  • Defines parameters and filters
  • Grants security
  • Give URL and Authentication information to the integration partner.

The integration partner ends up using a REST GET Service Operation called CHG_SWS. This web service checks security, resolves parameters, executes the SQL, encodes the data and returns it to the user.

• SWS Get Services - Standard HTTP Clients - Service Operation: CHG_SWS
  • Most of the web services you configure with SWS will be set up to be used by non-trusted users.
  • This is the default way to configure SWS services.
  • You can start reading about how to set up a new web service in the SWS Configuration Section

(Advanced) PsoftQL Web Services

This is a more advanced method for a system integrator. You generally will NOT open up this web service to many users.

• PsoftQL Web Services - Service Operation: CHG_SWS_PSOFTQL
  • This web service allows a highly trusted integration platform to request data in PsoftQL Syntax
  • This is for internal integration tools like Mulesoft, Snaplogic and Boomi.
  • When developing and prototyping new SWS configurations, your PeopleSoft admins may use this method to execute PsoftQL against PeopleSoft before configuring it in the must secure and locked-down SWS Get Service.