oracle openworld event branded template -...

32
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | OpenWorld 2017 Migrating PeopleSoft to Oracle Cloud Infrastructure Session ID: SUN3252 David Pigman Senior Technical Architect SpearMC Consulting October 1st , 2017 Confidential – Oracle Internal/Restricted/Highly Restricted

Upload: nguyenkiet

Post on 12-Jul-2018

240 views

Category:

Documents


0 download

TRANSCRIPT

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

OpenWorld 2017 Migrating PeopleSoft to Oracle Cloud Infrastructure Session ID: SUN3252

David Pigman

Senior Technical Architect

SpearMC Consulting

October 1st , 2017

Confidential – Oracle Internal/Restricted/Highly Restricted

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Agenda

Introduction about the company

High level overview of application

What are the key requirements you expected out of t

Round Table

1

2

3

4

Confidential – Oracle Internal/Restricted/Highly Restricted 2

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

• David Pigman

– Technical Architect – SpearMC Consulting

Introduction

Confidential – Oracle Internal/Restricted/Highly Restricted 3

Welcome to my hometown, San Francisco CA

My role: Everything technical related to PeopleSoft. Systems architecture, administration, development

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

• Marcus Bode

–Managing Director – SpearMC Consulting

Introduction

Confidential – Oracle Internal/Restricted/Highly Restricted 4

Welcome to my hometown, San Francisco CA

My role: Oracle-PeopleSoft Evangelist, Product Development and Chief Customer Satisfaction Officer

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

About SpearMC Consulting

Confidential – Oracle Internal/Restricted/Highly Restricted 5

Founded in 2004, SpearMC Consulting specializes in:

PeopleSoft FSCM, HCM, SCM, Grants

PeopleSoft Hosting & Managed Services

PeopleSoft/Tools Training

Oracle Cloud IaaS/PaaS

PeopleSoft Reseller since 2008

QA & Test Automation

Hyperion, PBCS and Cloud EPM

Oracle Business Intelligence

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

About SpearMC Consulting

Confidential – Oracle Internal/Restricted/Highly Restricted 6

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle Cloud Infrastructure How to get Started

Confidential – Oracle Internal/Restricted/Highly Restricted 7

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

What things looked like at SpearMC a long time ago (in 2016)

Confidential – Oracle Internal/Restricted/Highly Restricted 8

Running PeopleSoft ERP’s on different platforms

Seven internal instances (FSCM, HCM, CS) at

SpearMC On-Premise Data Center in Pleasanton;

Three training instances (HCM, ELM) at AWS;

Four client instances (FSCM 9.1 and FSCM 9.2) at

NTT co-location in Singapore;

Laptops and servers with static IP’s.

un·sus·tain·a·ble!!!

1. not able to be maintained at the current rate or level.

2. not able to be upheld or defended.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Coming up with a Business Case

Confidential – Oracle Internal/Restricted/Highly Restricted 9

Focus first on the “why” not the “how”

• Reduce Data Center Expenses: Hardware, Real Estate, Power, OS/SW

• Less Reliance on Internal Capabilities

• Speed to New Environments, Speed to Test, Scale for Future Growth

• Desire for Greater Stability, Redundancy, Failover and Failback

• Fewer Operational Issues and More Secure

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Call to Action and Next Steps

Confidential – Oracle Internal/Restricted/Highly Restricted 10

Next focus on “when” and “what” then start your blueprint

• When: Timing to purchase OPC…your next material IT event:

– Hardware refresh

– Hosting services renewal

– Oracle database upgrade (or move to Oracle database)

– PeopleTools upgrade (and then migrate to OPC)

• What: Consider OCI for the following:

– Demo Environment

– Update Source Environments

– Staging and Testing Environments…and ultimately Production

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Hiring your Architect – Deployment Options

Confidential – Oracle Internal/Restricted/Highly Restricted 11

If you understand this blueprint and all the “moving” parts, you’re in good shape to start

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Hiring your Architect

Confidential – Oracle Internal/Restricted/Highly Restricted 12

If you understand this blueprint and all the “moving” parts, you’re in good shape to start

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle Cloud Infrastructure (OCI) Services used for client migration from on-premise to OCI

Confidential – Oracle Internal/Restricted/Highly Restricted 13

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

IaaS, PaaS, DBaaS, SaaS

Confidential – Oracle Internal/Restricted/Highly Restricted 14

Platform as a service (PaaS) is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the infrastructure

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle Cloud Infrastructure Services used for Deployment

Confidential – Oracle Internal/Restricted/Highly Restricted 15

Metered and Non-Metered

Compute Classic

Storage Classic

Database

Database Backup Service

Networking

Load Balancing (Phase B)

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Compute Classic (Iaas)

Confidential – Oracle Internal/Restricted/Highly Restricted 16

• Choose OS and Images in the Marketplace

• Shapes – OC3 - 1 OCPU, 7.5 GB RAM, High Mem 15GB RAM, High I/O SSD Storage – OC4 - 2 OCPU, 15 GB RAM, High Mem 30GB RAM, High I/O SSD Storage – OC5 - 4 OCPU, 30 GB RAM, High Mem 60GB RAM, High I/O SSD Storage – OC6 - 8 OCPU, 60 GB RAM, High Mem 120GB RAM, High I/O SSD Storage – OC7 - 16 OCPU, 120 GB RAM, High Mem 240GB RAM, High I/O SSD Storage

• Scalable – No need to forecast needs and manage quotas, consume what is required, scale up/down as your needs evolve

• Cost Effective – Pay only for what you consume, reduce cost burden of expensive on-premises systems

• Secure – Data encrypted at rest and in motion across multiple availability domains

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Storage Classic

Confidential – Oracle Internal/Restricted/Highly Restricted 17

• Cloud Storage

– Database backups

– File attachments

–OS Snapshots

• Block Storage

– Supports Database and Compute Classic Servers

• High I/O SSD Storage

– High Performance Storage

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Database - Advantage of DBaaS over BYOL to IaaS

Confidential – Oracle Internal/Restricted/Highly Restricted 18

• Reduced time and complexity to provision database services

• Automated Oracle Database Backup Service (RMAN) deployment

• Tooling for automated patching and upgrades

• Instance monitoring console

• Automated deployment of HA features (RAC, DataGuard and GoldenGate)

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Database – Create Oracle Database Cloud Service Instance

Confidential – Oracle Internal/Restricted/Highly Restricted 19

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Database – Oracle 12.1 (Windows) to 12.2 (Linux) Upgrade and Lift and Shift using Oracle Data Pump for PeopleSoft

Confidential – Oracle Internal/Restricted/Highly Restricted 20

• Create Oracle Database Cloud Service Instance utilizing Multi-tenant container, pluggable database architecture

• Create additional pluggable databases

• Full expdp from Source Database

• Create dependencies on target

– Tablespace, Schemas, Roles, Grants

• Import Meta-data only (PeopleSoft Data Mover or impdp)

• Import data-only using impdp

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle Database Backup Service (RMAN)

Confidential – Oracle Internal/Restricted/Highly Restricted 21

• Performance, Redundancy, Security

– Data replicated in multiple storage nodes in different regions

– Encrypted Database, transfer and backups

– Faster restores

• Clone

– Use Database backups to clone Development, Test, QA for in Cloud or On-Premise

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Networking

Confidential – Oracle Internal/Restricted/Highly Restricted 22

• Shared Network

– Security Rules, Security Lists, Security Applications Security IP Lists, IP Reservations

• IP Network

– IP Networks, IP Exchanges, Virtual NIC Sets, Routes, Access Control Lists, Security Protocols, IP Address Prefix Sets, IP Reservations, VPN Connections, Private Gateways

• Corrente VPN

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Networking

Confidential – Oracle Internal/Restricted/Highly Restricted 23

• Security Implemented at Client

– Servers only accessible via RDP and Putty through provisioned Remote Desktop Server

– Two factor authentication implemented for Remote Desktop Server using DUO www.duo.com

– Remote Desktop Server connections encrypted

– Corrente VPN tunnel to clients CISCO VPN. https only accessible when VPN connection established

• Security (Menu Driven)

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

PeopleSoft Cloud Manager

Confidential – Oracle Internal/Restricted/Highly Restricted 24

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

PeopleSoft Cloud Manger Features

Confidential – Oracle Internal/Restricted/Highly Restricted 25

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

PeopleSoft Cloud Manager 05 – New Features

Confidential – Oracle Internal/Restricted/Highly Restricted 26

• Automated PeopleTools 8.55 to 8.56 Upgrade

• Automated Apply PeopleTools Patch

• PeopleTools 8.56 Environment Provisioning

• …and more

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle and Customer Reponsibilities

Confidential – Oracle Internal/Restricted/Highly Restricted 27

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Customer Responsibilities

Confidential – Oracle Internal/Restricted/Highly Restricted 28

See “Oracle

Infrastructure and

Platform Cloud Services

Security” White Paper

for more information.

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle Responsibilities

Confidential – Oracle Internal/Restricted/Highly Restricted 29

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Oracle and Customer Reponsibilities Use these slides as needed

Confidential – Oracle Internal/Restricted/Highly Restricted 30

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

More Thought Leadership

Confidential – Oracle Internal/Restricted/Highly Restricted 31

http://spearmc.com/insights

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

Tailored PeopleSoft Training

Confidential – Oracle Internal/Restricted/Highly Restricted 32

http://spearmc.com/training/