470 likes | 1.18k Views
Peoplesoft Fundamentals. David Lewis 10/18/02 (adapted from Psoft Training Materials). PeopleSoft Internet Architecture. Any web enabled device can access Peoplesoft Servers can be on one or more machines No code written on the client Provides dynamic hyperlinks, like any webpage
E N D
Peoplesoft Fundamentals David Lewis 10/18/02 (adapted from Psoft Training Materials)
PeopleSoft Internet Architecture • Any web enabled device can access Peoplesoft • Servers can be on one or more machines • No code written on the client • Provides dynamic hyperlinks, like any webpage • http://comwebserver.uml.edu:8080/psp/
Benefits of Internet Architecture • Easy Access • Platform Independence • Look and Feel • Low Bandwidth Access • Maintenance/Deployment • Cost effective
Metadata Driven Architecture • Peoplesoft Application Designer: Allows you to create Peoplesoft Applications: fields, records, pages, components. • When you define a page for example, this definition is stored in the metadata file. • Metadata: data about data • When executed, looks for latest version
Development Environment • Developers (those creating the Peoplesoft pages) and Administrator (those maintaining the system) • Do not need Internet access • Use more powerful machines • Use a Two-Tier connection • End users use Three-tier connection
PeopleSoft Internet Architecture • Four components • Internet access device • Web Server • Application Server • Database Server • Similar to other others: ex. Amazon
Architecture issues • No software to install on the clients • No plugins necessary • Simple, open architecture
Web Server • Purpose • Relay data from Browser to Application Server • Handle encryption • Serve up the image • Connection between Browser and Application Server
Application Server • Where the PeopleSoft logic resides • Brain of the Internet application • Generates the HTML which shows up in the browser • Two pieces • Tuxedo: handles communication between client and Peoplesoft • Jolt: connections to Java applets
Database server • Contains 3 sets of tables (files) • System Catalog Tables: store indexes and physical characteristics of tables • PeopleTools Tables: store object-related data pertaining to the online processing of the system and the activities that occur during import • Supplied by the system
Database server (cont.) • Application data tables: contain data created by the user
Peoplesoft and UML • UML (as part of UM) is implementing • HR (March 2002) • Financials (july 2002) • Student administration (with Dart and Bos) • Currently changing over from old to new Financial System
PeopleSoft and UML • COM: received a grant (with 2Million) from PeopleSoft • Currently: Full Financials package • Goal: Use as an ERP “tool” (PP, Access) • Called: End User Training • Also, Application Development available • Here: Intro to Navigation and Report Writing • May see in later classes
Relational Database Basics Adapted from PeopleSoft Training Materials Oct 2002
Basic Characteristics • Standard for efficient data organization • Store data based on true characteristics • Looks at how data items relate to each other • Each item stored just once
Relational Databases • Files called tables in PeopleSoft • Key fields: uniquely identify a row (record) • Indexes of keys make data storage and retrieval more efficient
PeopleSoft Data Models • These are set up by PeopleSoft • One model for each function • Samples next page
Data Models • Shows relationships between entities • An entity is a person, place, or thing • Items listed inside the boxes are fields • The lines drawn between the boxes represent the relationship between entities • The etchings at the ends represent the relationships