Using Amazon RDS to power enterprise applications (Peoplesoft)

50 %
50 %
Information about Using Amazon RDS to power enterprise applications (Peoplesoft)

Published on March 14, 2014

Author: tomlaszewski



AWS Oracle RDS can be used to run Oracle Peoplesoft. This presentation is done by AWS, DLZP, and Select Family.

© 2013, Inc. and its affiliates. All rights reserved. May not be copied, modified, or distributed in whole or in part without the express consent of, Inc. Using Amazon RDS to Power Enterprise Applications [DAT202] Abdul Sathar Sait, AWS David Brunet, DLZP Group Mark Saneholtz and Shawn Leviski, Select Staffing November 15, 2013

What is ahead • Introduction to Amazon Relational Database Service – Enterprise database requirements and wishes – Overview of Amazon RDS – How well RDS fits enterprise application needs – New features in RDS • Partner Story – How DLZP group uses RDS to implement Oracle Enterprise Applications for their customers. – Overview of PeopleSoft Architecture on AWS – Use Cases for AWS – Moving to AWS Project Overview and Lessons Learned • Customer Story – How Select Staffing used RDS to cut cost and speed up migration of their PeopleSoft environments to AWS

Enterprise Database requirements • Reliability • Performance • High-Availability • Scalability • Data privacy and security

Enterprise Database wishes • Instant provisioning • Easy Cloning • Push button scalability • No effort high-availability • Automated backups • Automated Patching

Let there be Databases! Preconfigured fully managed database within minutes

Deploy your databases in any AWS geographic region

Scale your database instance up or down as you need

Set up High Availability and Read Replicas with no effort

Four popular RDBMS engines available

New features in Amazon RDS • Amazon RDS supports 3TB DB size and 30,000 Provisioned IOPS • High Memory Instance with 244GB memory • RDS for Oracle Supports Statspack • New data migration capabilities for RDS for MySQL • Create multiple Read Replicas in quick succession for RDS MySQL • Create a replica from an existing Read Replica for RDS MySQL • MySQL 5.6 with Memcached and Binary Log Access for RDS MySQL • RDS for Oracle Supports TDE and Native Network Encryption

Amazon RDS - Great fit for Enterprise Application Delivers Enterprise Application needs and wants • Fully managed database engines that are commonly used for Enterprise Applications. • High-Availability and transparent failover • Enterprise class performance and easy scalability • Automated backups and easy replication • Rapid provisioning and deployment • Automation support with APIs and CloudFormation scripts • Low-touch management/administration

Enterprise Application that AWS customers use with RDS include • PeopleSoft • JD Edwards • Siebel • ATG Web Commerce • Jaspersoft • SugarCRM • Alfresco

AWS Partner DLZP Group

About DLZP Group • Established May 1, 2011 • Former PeopleSoft/Oracle Employees • Based in Richmond, Texas • Woman & Minority-Owned Business • Founding Member of PeopleSoft on AWS Test Drive Initiative

Agenda • Provide Overview of PeopleSoft Architecture on AWS • Use Cases for AWS • Moving to AWS Project Overview and Lessons Learned

PeopleSoft Architecture on Amazon

Our use cases for Oracle on AWS Production Instances of Enterprise Applications and Databases Development and Test Instances for Enterprise and custom applications Training, POC, Sandbox, Patch Testing and debugging instances Disaster Recovery Site on AWS

Deployment Options • New Implementation vs Migration New Implementation Migration from On-Premise No legacy infrastructure Legacy systems and on premise dependencies require additional work. Clean implementation using optimal infrastructure Restrictions can be imposed by legacy setup and configuration Built using current best practices Migrate to current best practices as feasible. Faster time to go-live system can be stood up within 24 hours. Longer timeline due to data migration

• Create a Replica of your on-site environment in the AWS Cloud • Environment will be setup using YOUR Infrastructure Elements  AWS Instance type (Start small and scale-up based on performance/user needs)  OS’s (Unix, Linux, Microsoft)  Databases Supported (Oracle, DB2, MS SQL Server)  Supports PeopleSoft FSCM, HCM, ELM, EPM, Portal • Allows your team to experiment with the AWS Cloud and validate assumptions and feasibility. PeopleSoft on AWS Proof of Concept Service

Approach to Moving to AWS • Setup VPC • Create Foundational infrastructure (Web, App, Proc, DB Servers) • Copy Database Into AWS • Complete Configuration • Test Environment and Application • Test Move to Production (2 Iterations Min) • Move to Production • Total Time to Deploy – 6-12 Weeks Project Overview

• Migration of Large Databases (Timing) • Customizations • Connection to On-Premise Resources (i.e. LDAP, File Servers) • Availability of Testing Team Migration Challenges

• Environments can be provisioned on demand • Reduce time to implementation • Reduces complexity of technical environment • Provides for ability to experiment with different scenarios with minimal impact to your internal infrastructure • Disk Space is available on demand as you grow • Disaster Recovery is built into the infrastructure Design • Standardized Infrastructure • Scale up or Down based on Business needs. • Repeatability of Deployments. Benefits of Amazon Web Services

Things to Think about • Always Setup VPC First • RDS / EBS Volumes for Data Storage • Think about Ports / Security Required to access applications / printers, etc • Think about other Applications that are required by your PeopleSoft systems (Active Directory, etc)

• Provides 5 hours of PeopleSoft Running on AWS for FREE • Guided walkthroughs for HCM, FSCM • Environment used includes the following elements  M1 Medium AWS Instance  Microsoft Server Data Center Edition  MS SQL Server 2008  PeopleSoft 9.1 Feature Pack 2 • Provisioned in minutes PeopleSoft Test Drive Lab

The DLZP Difference 281-912-DLZP

Select Staffing A Customer View of AWS

Overview of Company – Size of Organization and Brief History • Select Staffing is one of the 10 largest staffing companies in the United States • Over 400 offices across the country • In business for over 20 years • Based out of Santa Barbara, CA

Primary Reasons / Goals for Move to AWS. Challenges • internal infrastructure and resources • DR & Failover solution • Cost of provisioning additional infrastructure and internal support Goal • Stable infrastructure • Dynamic resource provisioning • Cost-effective

Major challenges with moving to AWS • Upgrade challenges • Oracle 10g to Oracle 11g • Data transfer for go-live cut over • 1.2 TB & 1 TB DB’s migrated over to AWS • Required the use of Replication Software

Performance of AWS compared to your existing environment. • Ability to size the environment accordingly • Ability to experiment with various configurations to minimize costs. • Can size each component to its relevant scale • Web Servers can be provisioned on Small Instances • App / Process Scheduler Servers can be of various sizes to manage the workload they are utilized for.

Key benefits gained by moving to AWS • Greater visibility of costs and resource allocation • Scalability without capital expenditures • Test/QA flexibility

We are sincerely eager to hear your feedback on this presentation and on re:Invent. Please fill out an evaluation form when you have a chance.

Add a comment

Related presentations

Related pages

Using Amazon RDS to Power Enterprise Applications (DAT202 ...

Using Amazon RDS to Power Enterprise ... PeopleSoft, and Siebel. In this ... leverage Amazon RDS for use with enterprise applications and learn ...
Read more

Oracle Test Drive - Amazon Web Services (AWS) - Cloud ...

Get Started Start developing on Amazon Web Services using one of ... Oracle enterprise application ... database to Amazon Aurora RDS using RDS ...
Read more

Run Oracle Applications on Amazon EC2 Now! | AWS Official Blog

AWS Official Blog Run Oracle Applications on Amazon EC2 Now! by Jeff Barr | on 16 DEC 2010 | in Amazon EC2 | Permalink | ...
Read more

Enterprise in the Cloud: Peoplesoft on AWS

Here are some case studies and materials for running Oracle Peoplesoft on AWS ... amazon-rds-to-power-enterprise-applications ... Peoplesoft on ...
Read more

PeopleTools 8.52: PeopleSoft Applications User's Guide

Users of PeopleSoft applications include casual users and power ... The technology runs on the Oracle Secure Enterprise ... "Using PeopleSoft Application ...
Read more

Oracle in the Amazon Web Services Cloud

Oracle in the Amazon Web Services Cloud ... Oracle's PeopleSoft Enterprise, ... (RDS), or Amazon Simple Storage Service ...
Read more

ReInvent 2013 : Using Amazon RDS to Power Enterprise ...

Enterprise in the Cloud. Blog posts to help enterprises run applications in the cloud. ... Using Amazon RDS to Power Enterprise Applications
Read more