PeopleTools explained

PeopleTools
PeopleSoft Enterprise PeopleTools
Author:PeopleSoft
Latest Release Version:8.61
Latest Release Date:[1]
Programming Language:C++, Java
Operating System:Windows, Linux
Platform:x64
Genre:Integrated development environment
License:Proprietary commercial software

PeopleTools consists of proprietary application software originally developed by PeopleSoft Corporation, an Enterprise Resource Planning (ERP) software vendor acquired by Oracle Corporation in 2004.[2] PeopleTools facilitates the deployment of both vendor-developed and custom-developed applications using an Internet-based architecture known as the PeopleSoft Internet Architecture (PIA).[3]

Core vendor-developed PeopleTools applications include:

As a result of the high level of abstraction used in PeopleTools, these applications can run in association with a variety of operating systems and databases and can provide multilingual support on a variety of web browsers.

From a development perspective, PeopleTools consists of several technologies for building and customizing applications. While a PeopleTools developer can (and often does) work with many programming languages, the primary language is PeopleCode, and Application Designer is the primary integrated development environment (IDE).

PIA

The PIA (PeopleSoft / PeopleTools Internet Architecture) consists of a variety components including: web, application, search, database, and process scheduler servers as well as Integration Broker. These components can be deployed on a single real or virtual server but are most typically deployed in isolation for reasons of performance and scalability.

Web Server

Like traditional web-based applications, web servers are used within the PIA to provide HTML-based documents for browser-based clients. Supported web server options have changed over time, and as of PeopleTools 8.59, PeopleTools applications are deployed only using Oracle WebLogic Server. Unlike traditional web-based applications, the Java-based software deployed in the web servers contains no application logic, purely presentation logic.

In the PIA, all application logic is deployed at the application server layer.

Application Server

The application server, or “app server,” is the tier between the web and database layers. This layer is primarily responsible for receiving requests from the web server and issuing SQL to the database.

The app server is built on BEA Tuxedo technology, and as such, is responsible for maintaining transaction isolation and database connection pools in PeopleTools applications. Using Tuxedo, PeopleTools app server domains are created as a collection of processes servicing specific needs and clients in addition to web server requests. Within a domain, several types of related programs can be launched, including remote call COBOL, Application Engine, and BI Publisher programs.

Process Scheduler Server

Like the app server, the process scheduler server, or "scheduler" or "batch server" is built on BEA Tuxedo and is deployed as a collection of processes designed to launch and schedule various programs types. Such processes form a process scheduler domain and are used to execute COBOL, SQR, Crystal Reports, Application Engine, nVision, BI Publisher, and many other types of batch programs. Unlike the app server, the scheduler does not return HTML to the web server for delivery to the client browser. Rather, the scheduler simply executes programs and posts logs and reports to the web server for user retrieval.

Database Server

The database server contains all application data as well as all metadata associated with various PeopleTools object types. It also contains many PeopleCode-based application scripts and programs that both the application and process scheduler servers execute.

As PeopleTools is built to operate on many database platforms, database specific constructs (like stored procedures) and programming languages (like PL/SQL) are not traditionally used. Alternatively, developers write Meta-SQL, and the app or scheduler servers translate such into the proprietary SQL for the related database technology.

Search Server

Based on predefined search indexes, the search server returns search results for consumption in the client's web browser. For 9.2 applications running PeopleTools 8.60, the search server technology is a forked version of the Elastic stack.

Integration Broker

Integration Broker is another major server component of PeopleTools. Making use of the PIA web and app servers, Integration Broker sends and receives data via web service-based APIs. While adhering to standards-based web service standards - such as XML-based SOAP and JSON-based RESTful web services - Integration Broker also provides a simple proprietary XML-based standard (known as PSCAMA) for PeopleTools-based applications to exchange data both synchronously and asynchronously.

Application Designer

Application Designer is the core tool used to create and customize PeopleTools-based applications. This tool is used to either connect to the database or app server for the purposes of creating and updating PeopleTools object types. The following is a brief list of such object types created or modified in Application Designer:[4]

Applications can be built or customised in a development environment, then assembled into a project for migration to test and live environments.

Current and Future releases

Current computing trends have led to the introduction of the Fluid User Interface (UI) in PeopleTools 8.54.[5]

The Fluid UI technology provides a means for PeopleTools developers to easily create fully responsive and modern looking applications. As this technology matures, it is anticipated Oracle will provide fully redesigned application pages making use of such technology, especially as customers adopt and apply application maintenance utilizing Fluid UI functionality anticipated with PeopleTools 8.55.

Major Versions and General Availability (GA) Dates

Notes and References

  1. Web site: PeopleTools 8.61 is available for on-premise installation . blogs.oracle.com . 2024-04-16.
  2. Web site: Oracle Buys PeopleSoft . www.oracle.com . 2015-11-08.
  3. Web site: PeopleSoft Architecture Fundamentals . docs.oracle.com . 2015-11-08 . en-us.
  4. Book: Anderson, Lynn . Lynn Anderson

    . Lynn Anderson . Understanding PeopleSoft8 . Sybex . 2001 . 64–68 . 0-7821-2930-7 . registration .

  5. Web site: Fluid User Interface Developer's Guide. docs.oracle.com. 2015-11-22.
  6. Web site: Oracle releases PeopleTools 8.60 on OCI . Oct 15, 2022 . PeopleSoft Blog.
  7. Web site: Oracle Releases PeopleTools 8.59 . blogs.oracle.com . 2021-04-23.
  8. Web site: PeopleTools 8.59 is Available for Downloads . July 21, 2021 . PeopleSoft Blog.
  9. Web site: PeopleSoft PeopleTools 8.58 is Available on Oracle Cloud Infrastructure . David . Bain . December 18, 2019 . PeopleSoft Blog.
  10. Web site: PeopleTools 8.57 is Available on the Oracle Cloud . David . Bain . September 21, 2018 . PeopleSoft Blog.
  11. Web site: PeopleTools 8.56 is Now Available . David . Bain . June 9, 2017 . PeopleSoft Blog.
  12. Web site: PeopleSoft PeopleTools. Oracle Help Center.
  13. Web site: Oracle-PeopleSoft is pleased to announce the general availability of PeopleTools 8.54 (PeopleSoft Technology Blog) . 2014-07-22 . 2014-07-17 . https://web.archive.org/web/20140717105454/https://blogs.oracle.com/peopletools/entry/oracle_peoplesoft_is_pleased_to . dead .
  14. Web site: Oracle Releases Oracle's PeopleSoft PeopleTools 8.53. finance.yahoo.com.
  15. Web site: Release Notes: Oracle's PeopleSoft PeopleTools 8.51. https://web.archive.org/web/20120916122037/http://peoplesoft-toolbox.com/resources/releasenotes/PT851-Notes.pdf. September 16, 2012. live.
  16. Web site: Release Notes for PeopleSoft Enterprise PeopleTools 8.50. https://web.archive.org/web/20120912013925/http://peoplesoft-toolbox.com/resources/releasenotes/PT850-Notes.pdf. September 12, 2012. live.
  17. Web site: Release Notes for PeopleSoft Enterprise PeopleTools 8.49. https://web.archive.org/web/20121119045014/http://peoplesoft-toolbox.com/resources/releasenotes/PT849-Notes.pdf. November 19, 2012. live.
  18. Web site: Release Notes for PeopleSoft Enterprise PeopleTools 8.48. https://web.archive.org/web/20180213170533/http://peoplesoft-toolbox.com/resources/releasenotes/PT848-Notes.pdf. February 13, 2018. live.
  19. Web site: Release Notes for Enterprise PeopleTools 8.45. https://web.archive.org/web/20180213171303/http://peoplesoft-toolbox.com/resources/releasenotes/PT845-Notes.pdf. February 13, 2018. live.
  20. Web site: PeopleTools 8.44 Release Notes. https://web.archive.org/web/20180213171305/http://peoplesoft-toolbox.com/resources/releasenotes/PT844-Notes.pdf. February 13, 2018. live.
  21. Web site: PeopleTools 8.20 Release Notes. https://web.archive.org/web/20120912013910/http://peoplesoft-toolbox.com/resources/releasenotes/PT820-Notes.pdf. September 12, 2012. live.
  22. Web site: PeopleTools 8.15 Release Notes. https://web.archive.org/web/20180213171349/http://peoplesoft-toolbox.com/resources/releasenotes/PT815-Notes.pdf. February 13, 2018. live.
  23. Web site: PeopleTools 8.14 Release Notes . https://web.archive.org/web/20180213171354/http://peoplesoft-toolbox.com/resources/releasenotes/PT814-Notes.pdf. February 13, 2018. live.
  24. Web site: PeopleTools 7.61 Release Notes. https://web.archive.org/web/20180213171357/http://peoplesoft-toolbox.com/resources/releasenotes/PT761-Notes.pdf. February 13, 2018. live.