PeopleSoft & JD Edwards Whitepapers and Webcasts
Microsoft SQL Server 2008 Tuning Tips for PeopleSoft Applications
This white paper is a practical guide for database administrators and programmers
who implement, maintain, or develop PeopleSoft® applications. It outlines guidelines
for improving the performance of PeopleSoft applications running on Microsoft® SQL
Server™ 2008. Much of the information presented in this document is based on findings
from real-world customer deployments and from PeopleSoft benchmark testing. The
issues discussed in this document represent problems that prove to be the most common
or troublesome for PeopleSoft customers.
View Document
Office Business Applications for PeopleSoft Sample Application Kit released
The OBA Sample Application Kit for PeopleSoft (one in a series of kits) includes a whitepaper, installation document, source code, and client-side binaries (server-side (MOSS) code is discussed in the documents how to deploy) for you to use and learn how you integrate PeopleSoft programmatically into your Office system.
Download today / Hands on Labs
Upgrading Oracle JD Edwards Enterprise One from SQL Server 2000 to SQL Server 2005 Technical Hands-On Lab
The enclosed lab manual describes the process of upgrading JD Edwards Enterprise One from SQL Server 2000 to SQL Server 2005. It is based on a two day JDE Upgrade workshop conducted in Redmond, WA and covers the prerequisites, recovery, determining the best upgrade approach, steps for upgrade and post-upgrade of the database.
View Document
Microsoft Business Intelligence Solution Demonstrator for Oracle PeopleSoft Enterprise FIN/SCM 8.8
Download the Microsoft BI solution demonstrator for Oracle PeopleSoft Financials. This solution contains a sample source database, target data mart, SQL Integration Services packages, SQL Analysis Services database, SQL Reporting Services sample reports and sample PerformancePoint Server dashboards and a Planning application. View the supplied readme.txt for instructions on the deployment of the demonstrator.
The solution was built in conjunction with IMGroup www.imgroup.com - Microsoft BI Partner of the Year in 2007.
PeopleSoft and SQL Server 2005 BI
Business Intelligence for Oracle PeopleSoft Financials
Integrating Microsoft Office SharePoint Portal Server 2007 with PeopleSoft Enterprise Applications
This technical whitepaper outlines the detailed process of integrating PeopleSoft Enterprise Applications with Microsoft Office SharePoint Portal Server 2007. The step by step approach outlines how to expose, compose and consume PeopleSoft Enterprise Web services by MOSS 2007 and "light up" your Oracle Applications.
View Document
SQL Server Performance Methodology with Oracle Applications
This presentation outlines a process and methodology for customers to achieve better performance for their Oracle Applications on SQL Server. You can download the sql script referenced in the methodology poster.
View Presentation
Get Methodology Poster
Top of page
Oracle Enterprise One On SQL Server 2005: Webcast with Oracle JDE E1 Leadership Team
This presentation led by the Oracle JD Edwards Product Management team and Microsoft Oracle Alliance covers in depth the following topics - Support for SQL Server 2005 (including details of platforms supported), Impact to installations and upgrades, Impact to Enterprise One Server and Windows Clients, Impact to Web Servers, Performance Results from several tests, Index to documentation and additional resources for customers and partners.
Read More
Recording of the webcast
Top of page
PeopleSoft on SQL Server 2005 Datasheet
This two page information sheet summarizes the key new features of SQL Server 2005 and PeopleTools 8.48 that are targeted specifically towards PeopleSoft workloads and significantly improve user experience.
Read More
Top of page
Microsoft SQL Server 2005 Tuning Tips for PeopleSoft 8.x
This white paper is a practical guide for database administrators and programmers who implement, maintain, or develop PeopleSoft® applications. It outlines guidelines for improving the performance of PeopleSoft applications running on Microsoft® SQL Server™ 2005.
Much of the information presented in this document is based on findings from real-world customer deployments and from PeopleSoft benchmark testing. The issues discussed in this document represent problems that prove to be the most common or troublesome for PeopleSoft customers.
Read More
Top of page
Connecting PeopleSoft and Microsoft Excel using the Information Bridge Framework
This whitepaper illustrates the process of connecting PeopleSoft to Microsoft Office Excel 2003 using Microsoft Information Bridge Framework (IBF) technology. IBF is the recommended mechanism for connecting Microsoft Office with line-of-business (LOB) systems. The whitepaper guides you through the process of creating all the components required to retrieve data from PeopleSoft into Microsoft Office Excel.
Read More
Top of page
Connecting Microsoft Office InfoPath 2003 to PeopleSoft
This whitepaper provides information and code snippets to jumpstart writing applications that enable organizations to capitalize on the advantages of MS Office system and provide familiar user interfaces, thus reducing the need to train the users in line-of-business applications such as PeopleSoft. It explains the process of submitting data from InfoPath 2003 to PeopleSoft CRM, illustrating a simple "Create Product" scenario, and shows how to integrate Microsoft Office InfoPath 2003 with PeopleSoft using Component Interfaces via .NET web services.
Read More
Top of page
Connecting to PeopleSoft Web Services with Microsoft Visual Studio .NET
This whitepaper explains the process of setting up a Web service in PeopleSoft environment and consuming that service in Microsoft Visual Studio .NET 2003. The paper covers a simple example of a distributed application based on the PeopleSoft and Microsoft .NET system and shows how to use the data from PeopleSoft in a Microsoft Windows Forms application and in a Microsoft SharePoint Portal Server Web part.
Read More
Top of page
PeopleSoft Red Paper: Microsoft SQL Server Tuning Tips for PeopleSoft 8.x
This Red Paper discusses guidelines for improving the performance of PeopleSoft applications running on SQL Server and acts as a practical guide for technical users, database administrators, and programmers who implement, maintain, or develop applications for a PeopleSoft system.
The paper is structured to provide information about basic tuning, database maintenance for high performance, troubleshooting some common problems, and parameter tunings.
Read More
Top of page
SQL Server 2005 for JD Edwards Enterprise One Customers
This Oracle Open World 2006 presentation gives an overview of SQL Server 2005 for JD Edwards Enterprise One Customers. We cover features in SQL Server 2005 like 64 Bit support, Partitioned Tables and new Views that make database administration and performance tuning much simpler. JD Edwards Enterprise One customers can realize great increases in performance by upgrading to SQL Server 2005.
Read More
Top of page
|