1 / 24

JD Edwards Enterprise One Support for SQL Server 2005:

JD Edwards Enterprise One Support for SQL Server 2005:. Anu Chawla Program Manager, Oracle Alliance Team, Microsoft. Please dial in for audio Toll Free: 888 469 0489 International: 1-210-234-0013 Passcode: JD Edwards.

buffy-floyd
Download Presentation

JD Edwards Enterprise One Support for SQL Server 2005:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. JD Edwards Enterprise One Support for SQL Server 2005: Anu Chawla Program Manager, Oracle Alliance Team, Microsoft Please dial in for audio Toll Free: 888 469 0489 International: 1-210-234-0013 Passcode: JD Edwards Steve Fillipi - Director of Development (Platform Technologies), Oracle Charunee Pansuvan - Principal Software Engineer, Oracle Tom Chikoore - Principal Software Engineer, Oracle Wanda He SQL Server Program Manager, Microsoft

  2. Purpose: This document provides an overview of features and enhancements included in Oracle’s JD Edwards EnterpriseOne Tools 8.96. It is intended solely to help you assess the business benefits of upgrading to JD Edwards EnterpriseOne 8.96. Disclaimer: This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle. Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.

  3. Oracle Applications Unlimited "We are sincere and passionate about continuing to support [IBM] DB2 and [Microsoft] SQL Server. You will continue to see great support for those platforms," Wookey said. Information Week, October 25,2006 PeopleSoft Enterprise, JD Edwards Enterprise One and Siebel CRM are certified today on SQL Server 2005 across variety of platforms. Oracle Applications Unlimited guarantees support for the Microsoft Platform for our joint customers. Microsoft is committed to providing guidance, support and best practices to our mutual customers

  4. Oracle Online Training Materials – Usage Agreement Use of this Site (“Site”) or Materials constitutes agreement with the following terms and conditions: 1. Oracle Corporation (“Oracle”) is pleased to allow its business partner (“Partner”) to download and copy the information, documents, and the online training courses (collectively, “Materials") found on this Site. The use of the Materials is restricted to the non-commercial, internal training of the Partner’s employees only. The Materials may not be used for training, promotion, or sales to customers or other partners or third parties. 2. All the Materials are trademarks of Oracle and are proprietary information of Oracle. Partner or other third party at no time has any right to resell, redistribute or create derivative works from the Materials. 3. Oracle disclaims any warranties or representations as to the accuracy or completeness of any Materials.  Materials are provided "as is" without warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement. 4. Under no circumstances shall Oracle be liable for any loss, damage, liability or expense incurred or suffered which is claimed to have resulted from use of this Site of Materials. As a condition of use of the Materials, Partner agrees to indemnify Oracle from and against any and all actions, claims, losses, damages, liabilities and expenses (including reasonable attorneys' fees) arising out of Partner’s use of the Materials.

  5. JD Edwards EnterpriseOne Tools 8.96 Transfer of InformationFunctional Overview JD Edwards EnterpriseOne Support for Microsoft SQL Server 2005

  6. Agenda • Announcement of Support for Microsoft SQL Server 2005 • Details of Support • Included Support • Excluded Support • Impact to Installations and Upgrades • Impact to EnterpriseOne Server and Windows Clients • Impact to Web Servers • Special Note for Auditing Functionality • Special Note for Installing on Windows Server 2003 x64 • E1 / SQL Server 2005 Performance • Additional Resources for Customers and Partners

  7. Oracle Announces Support for Microsoft SQL Server 2005 with JD Edwards EnterpriseOne • Oracle announces support for Microsoft SQL Server 2005 with JD Edwards EnterpriseOne applications. The support begins with JD Edwards EnterpriseOne Tools 8.96_F1, which runs with JD Edwards EnterpriseOne application releases 8.9, 8.10, 8.11, 8.11 SP1, and 8.12. • Support extends to MS SQL Server 2005 running on Windows Server 2003 32-bit and x64 editions (database only) • At this time EnterpriseOne support for SQL Server 2005 excludes the following: • SQL Server 2005 on Itanium servers • EnterpriseOne Xe and 8.0 (support is planned for a future release) • EnterpriseOne Mobile Sales • IBM WebSphere Portal 5.1.0.x metadata repository • XPI and Web Services Gateway • Crystal Enterprise Version 10 • Refer to the Supported Platforms pages on Customer Connection for specific details about supported platforms.

  8. Details of Support • Minimum EnterpriseOne Tools release: 8.96_F1 • EnterpriseOne Applications releases supported: 8.9, 8.10, 8.11, 8.11 SP1, 8.12 • Operating systems supported: • Windows Server 2003 32-bit • Windows Server 2003 x64 • Note: Only the database server is supported on Windows Server 2003 x64. Other EnterpriseOne components must run under the 32-bit operating system. • Refer to the Minimum Technical Requirements documents on Customer Connection for details.

  9. Details of Support - Exclusions Microsoft SQL Server 2005 is NOT supported with: • Servers with Intel Itanium processors • JD Edwards EnterpriseOne Xe and 8.0 (Support starts with SP23_Q1 – 32bit only) • EnterpriseOne Mobile Sales • Mobile Sales must remain on SQL Server 2000. • Collaborative Portal with IBM WebSphere Portal 5.1.0.x • EnterpriseOne can utilize SQL Server 2005 as the repository for business data. However, SQL Server 2005 cannot be used as the WebSphere Portal database. • XPI and Web Services Gateway • SQL Server 2005 is not certified to fulfill the Crystal Enterprise Version 10 requirement for a CMS database

  10. Impact to Installations and Upgrades SQL Server 2005 is supported with: • EnterpriseOne Applications 8.9 and above with 8.96_F1 • Planner ESU with instructions for SQL Server 2005: • 8.9 PF4671 • 8.10 PG4759 • 8.11 PH12097 • 8.11 SP1 JJ12489 • 8.12 JK10721

  11. Impact to Enterprise Server, Deployment Server, and Windows Client SQL Native Client (SNAC): • Any EnterpriseOne machine that acts as a client to SQL Server 2005 requires SNAC, including: • Enterprise server • Deployment server • Windows client • SQL Native Client can be downloaded from Microsoft’s web site (http://www.microsoft.com/downloads)

  12. Impact to Web Servers • The Microsoft SQL Server 2005 JDBC driver is supported with the following web application servers: • Oracle Application Server 10.1.2.0.2 • WebSphere Application Server 6.0.x • The Microsoft SQL Server 2005 JDBC driver can be used with either SQL Server 2000 or SQL Server 2005 • Manual configuration of the SQL Server 2005 JDBC driver is required. Consult the JD Edwards EnterpriseOne Tools Release 8.96 HTML Web Server Installation Guide for installation instructions. • SQL Server 2005 JDBC Driver download: • http://msdn.microsoft.com/data/ref/jdbc/default.aspx

  13. Special Note for Auditing Functionality • Customers using the EnterpriseOne auditing (21 CFR Part 11) must apply Microsoft SQL Server 2005 SP1 and hot fix KB925227

  14. Special EnterpriseOne Installation Notes for Windows Server 2003 R2 x64 • Installing the 64-bit SQL Server 2005 on Windows Server 2003 R2 x64 requires modifications to the registry entries on the database server. • The Platform Pack can’t find the SQL Server 2005 (64-bit) instance and will fail • A new entry must be added to the registry before the Platform Pack can be installed • Refer to the special instructions for the Planner ESU for the explicit procedure

  15. SQL Server 2005 Performance • Comparing SQL Server 2000 with 2005 (32bit) • JDE performance comparison (4 scripts) • SQL 2005 (64-bit) Hardware Vendor Results • SQL Server 2005 Customer Proof of Concept (POC) • Interactive and Batch in a constrained window

  16. SQL Server 2000 vs. 2005 Performance (32bit) • Running 4 of our most commonly used interactive applications: • Sales Order Entry (P4210) • Work Order Entry (P48013) • Confirm Shipments (P4205) • Supplier Ledger Inquiry (P0411) • Results: • Average response times improved by 13% • Database CPU dropped from 25% to 11% • No noticeable change in memory usage between SQL Server 2000 and SQL Server 2005 • Evaluation was performed under lab conditions – actual customer results will vary.

  17. SQL 2005 (64-bit) IBM xSeries Results • Evaluate with 500, 750, and 1000 users • Blend of Manufacturing, Distribution and Financial Users Evaluation was performed under lab conditions – actual customer results will vary. Results / details to be published by IBM.

  18. SQL Server 2005 POC – Interactive & Batch • Objective: • 6hrs of intensive SOE workload (interactive and batch) • Database server: • AMD Opteron 4-way 2.6 GHz / 16G RAM • Interactive App (logic) server: • HP DL380 2-way Intel Xeon 3.06GHz / 4.5G RAM • Batch Servers: • 2* HP DL380 2-way Intel Xeon 3.06GHz / 4.5G RAM • HP DL585 4-way Opteron 2.4GHz / 6G RAM

  19. SQL Server 2005 POC – Interactive Users • The database server: AMD 4-way (2.6 GHz) with 16G RAM. • CPU utilization never exceeded 16.1% Note: 90th percentile indicates that 90% of the transactions were under this time.

  20. SQL Server 2005 POC – Throughput • The large majority of transactions were submitted through EDI and Batch processing in a 6 hour window

  21. Additional Resourcesfor Customers and Partners

  22. Index to Documentation Updates

  23. Additional Resources for Customers and Partners Oracle Products http://www.oracle.com/products/ Oracle Education http://www.oracle.com/education/index.html Oracle Support http://www.oracle.com/support/ Metalink Information: http://metalink.oracle.com/ Oracle Product Documentation: http://www.oracle.com/technology/documentation/applications.html EnterpriseOne Minimum Technical Requirements: http://www.peoplesoft.com/corp/en/iou/platforms/enterpriseone.jsp

  24. Thank You! Thank You

More Related