Windchill Bulk Migrator 1 0 Overview Presentation Created

Windchill Bulk Migrator 1. 0 Overview Presentation Created By: Software Development March, 2011

The Windchill Bulk Migrator: WBM The Windchill Bulk Migrator is used to migrate and consolidate data into a Windchill 10. 0 Enterprise PLM backbone Benefits: § Unify heterogeneous legacy PLM system landscapes through migration § Enable a standard migration strategy for Mergers & Acquisitions or business divestitures § Ensure data integrity by using PTC supported object creation methodology § Lower or eliminate source and target system downtime during migration § Lower migration effort and costs by using out of the box PTC tooling § Lower total cost of ownership by de-customizing during migration and mapping to out of the box Windchill capabilities 2

The WBM fills critical migration use cases Capabilities add to and complement standard Upgrade and Migration paths and tools Migration Type Example Migration Tool Non-PTC (Legacy) to Windchill Migration Matrix to PDMLink 9. 1 Windchill Bulk Migrator Windchill Merge PDMLink 9. 1, system A combine with PDMLink 9. 1, system B into single Windchill 10. 0 system C Windchill Bulk Migrator Windchill Foundation & PDM to PDMLink (with decustomization) Windchill Foundation & PDM 6. 2. 6 to PDMLink 10. 0 Windchill Bulk Migrator Windchill Upgrade PDMLink 9. 1 to PDMLink 10. 0 PTC Upgrade Manager Windchill Update PDMLink 9. 0 to PDMLink 9. 1 PSI: PTC Solution Installer Pro/INTRALINK 3. X to PDMLink Pro/I 3. 4 to PDMLink 10. 0 Pro/I Data Migrator Pro/INTRALINK 10. X to PDMLink 10. X Pro/I 10. 0 to PDMLink 10. 0 PSI: Install PDMLink into existing codebase Windchill on Oracle to Windchill on SQL Server PDMLink 10. 0 (Oracle) to PDMLink 10. 0 (SQL Server) SSMA: SQL Server Migration Assistant Note: Projects vary significantly in effort, duration depending on path and complexity © 2006 PTC 3

What Does PTC Mean by Bulk Migration Goal: Permanently move data from one or more systems to Windchill § Example 1: System consolidation – Multiple Windchill systems merge to single Windchill system § Example 2: Legacy system replacement with Windchill 10. 0 – Metaphase to Windchill, Enovia to Windchill, … § Standard migration approach is Extract, Transform, Load and Validate (ETLV) § New PTC Tools: Windchill Bulk Migrator (WBM) for Windchill 10. 0 Focus: Permanent, oneway bulk migration Not the Focus: 2 way integration Legacy System WBM Legacy System Windchill 10. 0 Map and transform data as needed 4

Windchill Bulk Migrator 1. 0 Contents WBM 1. 0 Release March 2011 § Windchill 10. 0 bulk loading tools – Robust load controller – Discrete, multi-threaded definition of load jobs – Object loaders for common product and admin data • See Install and User Guide for a complete list § Some Incremental migration § Normalized data staging schema – Schema creation scripts – Control file templates for loading into the staging area § Infrastructure improvements – Restricted Migration Domain: Migrated data is hidden until golive WBM Tool Components – Insert or add to existing object history Transform Extract § Some Windchill 10. 0 extractors – Extract data out of Windchill 10. 0 Infrastructure & Administration WBM 1. 0 Release Forward Looking Information Subject to Change PTC Confidential and Proprietary Load Validate 5

WBM 1. 0 Role in System Consolidation Migrations WBM 1. 0 loads data into Windchill 10. 0 from a defined staging database § Pre-Loading activities § WBM 1. 0 activities – Target system design and configuration – Data extraction – Data mapping – Data transformation – Data cleansing – Define and stage data – Control data loading and sequencing – Hide data during migration – Reveal data after migration – Audit migration data completeness Example Use Case Legacy System Raw Data Staging Extract Customer or Global Services Activity with Custom Tools Forward Looking Information Subject to Change Normalized Staging Map and Transform Customer/Services Activity with Custom Tools PTC Confidential and Proprietary Windchill 10. 0 Load PTC Global Services Activity with WBM Tools 6

WBM 1. 0 Software Download and Documentation WBM software, documentation are available on PTC. com – to PTC employees only § Software Download – Select Windchill PDMLink, Release 10. 0 in Download Software Updates on PTC. com – Title: Windchill Bulk Migrator 1. 0 – Installable components contained in ZIP file § Documentation – Install and User Guide, RTF, and Compatabiliity Matrices in Reference Document – Product: Windchill Bulk Migrator – Release: 1. 0 § Installation and Release notes – WBM is released asynchronously from Windchill 10. 0 – WBM is installed into Windchill 10. 0 via a lightweight installer Forward Looking Information Subject to Change PTC Confidential and Proprietary 7

WBM 1. 0 Platform and Product Support Windchill Bulk Migrator Release Windchill PDMLink Windchill Project. Link 1. 0 10. 0 F 000 Database: For both staging and the Windchill 10. 0 target system Windchill Bulk Migrator Release Oracle SQLServer 1. 0 Yes: Version and platform support same as Windchill 10. 0 Not Supported Platform Support § WBM 1. 0 is supported on all server OS platforms that the target Windchill 10. 0 systems are supported on Forward Looking Information Subject to Change PTC Confidential and Proprietary 8