PeopleSoft Books
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PeopleSoft Books
(→Using Functions in PeopleSoft Query) |
|||
| Line 1: | Line 1: | ||
| + | == Using Functions in PeopleSoft Query == | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | |[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg|190px|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]] | ||
| + | |||
| + | |Amazon Kindle: [http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query] | ||
| + | |||
| + | At the heart of a PeopleSoft Query is a SQL query. Knowing some extra tricks with SQL functions will go a long way to extracting the exact results you need. | ||
| + | |||
| + | But isn't SQL hard? So completely difficult that only Einstein after 3 Red Bulls could possibly stand a chance of putting a query together? This book aims to dispel this myth and help you increase the number of tasks you can complete with PeopleSoft Query. | ||
| + | |||
| + | Harness the power of PeopleSoft Query using the database (both Oracle and SQL Server), use this book to take the raw Query results and fashion them. | ||
| + | |} | ||
| + | |||
| + | == PeopleSoft Users Companion == | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | |[[File:PeopleSoftUserCompanion.jpg|190px|link=http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24]] | ||
| + | |||
| + | |Amazon Kindle: [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] | ||
| + | |||
| + | This book is packed full of hints and tips for users of the Oracle PeopleSoft applications. The hints and tips can be applied to HR, Campus, Financials and CRM. | ||
| + | |||
| + | The Oracle PeopleSoft applications are very versatile and powerful. A little knowledge of tricks and techniques can help you make more of the system, and get things completed faster. | ||
| + | |||
| + | These tricks will save you time - some every day, some occasionally. Some ideas you may have been vaguely aware of, but not seen how they can be used. | ||
| + | |||
| + | |} | ||
| + | |||
| + | |||
== Peoplesoft for the Oracle DBA == | == Peoplesoft for the Oracle DBA == | ||
| Line 7: | Line 39: | ||
|Amazon: [http://www.amazon.co.uk/gp/product/1590594223?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=1590594223 Peoplesoft for the Oracle DBA] | |Amazon: [http://www.amazon.co.uk/gp/product/1590594223?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=1590594223 Peoplesoft for the Oracle DBA] | ||
| - | + | This is an excellent text for PS Admins and developers that want to know more about what goes on under the covers. | |
* Background of how PeopleSoft makes use of particular Oracle database features. | * Background of how PeopleSoft makes use of particular Oracle database features. | ||
| Line 29: | Line 61: | ||
* Building a page in Application Designer. | * Building a page in Application Designer. | ||
| - | * | + | * Writing PeopleCode |
| + | * Building processes in Application Engine and SQR | ||
| + | * Reporting in XML Publisher. | ||
|} | |} | ||
| Line 45: | Line 79: | ||
* Using object orientated Application Packages. | * Using object orientated Application Packages. | ||
* Add AJAX to your pages to reduce network round trips | * Add AJAX to your pages to reduce network round trips | ||
| + | * Using Java from within PeopleCode | ||
* Extending Integration Broker with home grown connectors | * Extending Integration Broker with home grown connectors | ||
