PeopleTools

Last updated
PeopleSoft Enterprise PeopleTools
Original author(s) PeopleSoft
Developer(s) Oracle Corporation
Stable release
8.60 / October 15, 2022;3 months ago (2022-10-15) [1]
Written in C++, Java
Operating system Windows, Linux
Platform x64
Type Integrated development environment
License Proprietary commercial software
Website Official Page

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]

Contents

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

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">Oracle Corporation</span> American multinational computer technology corporation

Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells database software and technology, cloud engineered systems, and enterprise software products, such as enterprise resource planning (ERP) software, human capital management (HCM) software, customer relationship management (CRM) software, enterprise performance management (EPM) software, and supply chain management (SCM) software.

PeopleSoft, Inc. is a company that provides human resource management systems (HRMS), Financial Management Solutions (FMS), supply chain management (SCM), customer relationship management (CRM), and enterprise performance management (EPM) software, as well as software for manufacturing, and student administration to large corporations, governments, and organizations. It existed as an independent corporation until its acquisition by Oracle Corporation in 2005. The PeopleSoft name and product line are now marketed by Oracle.

J.D. Edwards World Solution Company or JD Edwards, abbreviated JDE, was an enterprise resource planning (ERP) software company, whose namesake ERP system is still sold under ownership by Oracle Corporation. JDE's products included World for IBM AS/400 minicomputers, OneWorld for CNC architecture, and JD Edwards EnterpriseOne. The company was founded March 1977 in Denver, Colorado, by Jack Thompson, C.T.P. "Chuck" Hintze, Dan Gregory, and C. Edward "Ed" McVaney.

C++Builder is a rapid application development (RAD) environment, originally developed by Borland and as of 2009 owned by Embarcadero Technologies, for writing programs in the C++ programming language currently targeting Windows, iOS and for several releases, macOS and Android C++Builder combines the Visual Component Library and IDE written in Object Pascal with multiple C++ compilers. Most components developed in Delphi can be used in C++Builder with no or little modification, although the reverse is not true, but this constraint is valid only for source code. Binary code generated by Delphi can easily be linked to binary code generated by C++Builder and vice versa to generate an executable written in both Object Pascal and C++. With this approach, C++ can be called from Object Pascal and vice versa. Since both Delphi and C++ use the same back end linker, the debugger can single step from Delphi code into C++ transparently.

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation.

Oracle APEX is an enterprise low-code development platform from Oracle Corporation that is used to develop and deploy web applications on Oracle databases. APEX provides a web-based integrated development environment (IDE) that uses wizards, drag-and-drop layout, and property editors to build applications and pages.

Microsoft BizTalk Server is an inter-organizational middleware system (IOMS) that automates business processes through the use of adapters which are tailored to communicate with different software systems used in an enterprise. Created by Microsoft, it provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring.

<span class="mw-page-title-main">Uniface (programming language)</span> Low-code development platform

Uniface is a low-code development and deployment platform for enterprise applications that can run in a large range of runtime environments, including mobile, mainframe, web, Service-oriented architecture (SOA), Windows, Java EE, and .NET. Uniface is used to create mission-critical applications.

Oracle Fusion Middleware consists of several software products from Oracle Corporation. FMW spans multiple services, including Java EE and developer tools, integration services, business intelligence, collaboration, and content management. FMW depends on open standards such as BPEL, SOAP, XML and JMS.

<span class="mw-page-title-main">Oracle Designer</span>

Oracle Designer was Oracle's CASE tool for designing an information system and generating it. After generating the information system one is able to edit the generated code with Oracle Developer Suite.

SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to the acquisition of Sybase by SAP.

Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs.

Oracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. Osama Elkady from the Applications Technology Group and Tim Dexter from the Financials Group were the main drivers for the product. It was first released with Oracle E-Business Suite 11.5.10 in 2003. Since then it has been integrated into most of Oracle Products including JD Edwards EnterpriseOne application 8.12 and PeopleSoft Enterprise 9, and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.

Jive is a commercial Java EE-based Enterprise 2.0 collaboration and knowledge management tool produced by Jive Software. It was first released as "Clearspace" in 2006, then renamed SBS in March 2009, then renamed "Jive Engage" in 2011, and renamed simply to "Jive" in 2012.

Configurable Network Computing or CNC is JD Edwards's (JDE) client–server proprietary architecture and methodology that implements its highly-scalable enterprise-wide business solutions software that can run on a wide variety of hardware, operating systems (OS) and hardware platforms. Now a division of the Oracle Corporation, Oracle continues to sponsor ongoing development of the JD Edwards Enterprise Resource Planning (ERP) system, While highly flexible, the CNC architecture is proprietary and, as such, it cannot be exported to any other systems. While the CNC architecture's chief 'Claim to fame', insulation of applications from the underlying database and operating systems, were largely superseded by modern web-based technology, nevertheless CNC technology continues to be at the heart of both JD Edwards' One World and Enterprise One architecture and will play a significant role Oracle's developing fusion architecture initiative. While a proprietary architecture, CNC is neither an Oracle nor JDE product offering. The term CNC also refers to the systems analysts who install, maintain, manage and enhance this architecture. CNC's are also one of the three technical areas of expertise in the JD Edwards Enterprise Resource Planning ERP which include developer/report writer and functional/business analysts.

Oracle WebCenter is Oracle's portfolio of user engagement software products built on top of the JSF-based Oracle Application Development Framework. There are three main products that make up the WebCenter portfolio, and they can be purchased together as a suite or individually:

<span class="mw-page-title-main">WaveMaker</span> Low-code programming platform

WaveMaker is an enterprise grade Java low code platform for building software applications and platforms. WaveMaker Inc. is headquartered in Mountain View, California. For enterprises, WaveMaker is a low code platform that aims to accelerate their app development and IT modernization efforts. For ISVs, it is a consumable low code component that can sit inside their product and offer customizations.

A cloud database is a database that typically runs on a cloud computing platform and access to the database is provided as-a-service. There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.

Google Cloud Platform (GCP), offered by Google, is a suite of cloud computing services that runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, Google Drive, and YouTube. Alongside a set of management tools, it provides a series of modular cloud services including computing, data storage, data analytics and machine learning. Registration requires a credit card or bank account details.

References

  1. 1 2 "Oracle Releases PeopleTools 8.60 on OCI". blogs.oracle.com. Retrieved 2023-02-08.
  2. ↑ "Oracle Buys PeopleSoft". www.oracle.com. Retrieved 2015-11-08.
  3. ↑ "PeopleSoft Architecture Fundamentals". docs.oracle.com. Retrieved 2015-11-08.
  4. ↑ Anderson, Lynn (2001). Understanding PeopleSoft8 . Sybex. pp.  64–68. ISBN   0-7821-2930-7.
  5. ↑ "Fluid User Interface Developer's Guide". docs.oracle.com. Retrieved 2015-11-22.
  6. ↑ "Oracle releases PeopleTools 8.60 on OCI". PeopleSoft Blog. Oct 15, 2022.
  7. ↑ "Oracle Releases PeopleTools 8.59". blogs.oracle.com. Retrieved 2021-04-23.
  8. ↑ "PeopleTools 8.59 is Available for Downloads". PeopleSoft Blog. July 21, 2021.
  9. ↑ Bain, David (December 18, 2019). "PeopleSoft PeopleTools 8.58 is Available on Oracle Cloud Infrastructure". PeopleSoft Blog.
  10. ↑ Bain, David (September 21, 2018). "PeopleTools 8.57 is Available on the Oracle Cloud". PeopleSoft Blog.
  11. ↑ Bain, David (June 9, 2017). "PeopleTools 8.56 is Now Available". PeopleSoft Blog.
  12. ↑ "PeopleSoft PeopleTools". Oracle Help Center.
  13. ↑ "Oracle-PeopleSoft is pleased to announce the general availability of PeopleTools 8.54 (PeopleSoft Technology Blog)". Archived from the original on 2014-07-17. Retrieved 2014-07-22.
  14. ↑ "Oracle Releases Oracle's PeopleSoft PeopleTools 8.53". finance.yahoo.com.
  15. ↑ "Release Notes: Oracle's PeopleSoft PeopleTools 8.51" (PDF). Archived (PDF) from the original on September 16, 2012.
  16. ↑ "Release Notes for PeopleSoft Enterprise PeopleTools 8.50" (PDF). Archived (PDF) from the original on September 12, 2012.
  17. ↑ "Release Notes for PeopleSoft Enterprise PeopleTools 8.49" (PDF). Archived (PDF) from the original on November 19, 2012.
  18. ↑ "Release Notes for PeopleSoft Enterprise PeopleTools 8.48" (PDF). Archived (PDF) from the original on February 13, 2018.
  19. ↑ "Release Notes for Enterprise PeopleTools 8.45" (PDF). Archived (PDF) from the original on February 13, 2018.
  20. ↑ "PeopleTools 8.44 Release Notes" (PDF). Archived (PDF) from the original on February 13, 2018.
  21. ↑ "PeopleTools 8.20 Release Notes" (PDF). Archived (PDF) from the original on September 12, 2012.
  22. ↑ "PeopleTools 8.15 Release Notes" (PDF). Archived (PDF) from the original on February 13, 2018.
  23. ↑ "PeopleTools 8.14 Release Notes" (PDF). Archived (PDF) from the original on February 13, 2018.
  24. ↑ "PeopleTools 7.61 Release Notes" (PDF). Archived (PDF) from the original on February 13, 2018.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.