plm data migration_general_considerations
DESCRIPTION
This presentation presents general concepts and consideration in Enterprise Data migration. Focus here is on Product Lifecycle Management data.TRANSCRIPT
PLM DATA MIGRATION
PASAR: PLM DATA MIGRATION : 8/30/2011
How Data Migration Works
DataExtraction
DataCollection
Data Archival
&Data
Retention
Testing &
Data Loading
Data Analysis & Cleansing
Data Transformation
The process is refined until the transformed data is acceptable.
PASAR: PLM DATA MIGRATION : 8/30/2011
Data Migration Patterns
Managed Data Source Loosely Managed Data Source Managed Data Target
PASAR: PLM DATA MIGRATION : 8/30/2011
Data Migration is Like Changing an Engine in Midair …
Product information is the lifeblood of a company
Migration must be done in a way that doesn’t disrupt current process
Improper migrations can be catastrophic
PASAR: PLM DATA MIGRATION : 8/30/2011
… Garbage In, Garbage Out …
Just because you can migrate all your data doesn’t mean you should
Take a hard look at legacy data and be selective
Do not pollute your new system with corrupt or inaccurate data
PASAR: PLM DATA MIGRATION : 8/30/2011
… Two Gallons of Water, One Gallon Container …
Critical for companies who are downsizing to a less complex system
Identify critical information early
Verify the target system has structure to accept certain data types
PASAR: PLM DATA MIGRATION : 8/30/2011
What a Tangled Web We Weave
Map out data sources early
Identify issues like naming conflicts and data integrity
If possible consolidate prior to migration
PASAR: PLM DATA MIGRATION : 8/30/2011
Volume, Volume, Volume
Assess the amount of data you need to move and factor this into planning
Try reducing the amount of data through purging, deleting and limiting history
Use a phased migration approach to allow for testing and to minimize system downtime
PASAR: PLM DATA MIGRATION : 8/30/2011
History is Best Forgotten
Extracting and transferring history to a new PLM is challenging
Most companies rarely access earlier versions of data
Using a “Latest only” approach dramatically reduces cost and complexity of data migration
PASAR: PLM DATA MIGRATION : 8/30/2011
Be Prepared
Don’t “under provision” hardware for data migration
Identify needs and have analysis and data cleansing solutions ready
Clean up your data as much as possible prior to migration
PASAR: PLM DATA MIGRATION : 8/30/2011
Test, Validate, Rinse, Repeat
Two test passes and a production pass are minimum recommendations for most migrations
Have a specific test plan to evaluate data in the test system
If required to validate combine it with testing to reduce test cycles
PASAR: PLM DATA MIGRATION : 8/30/2011
Conclusion Good migration is mostly common sense
Don’t let migration be an afterthought
The information is more important than the tool/method of migration
PASAR: PLM DATA MIGRATION : 8/30/2011
BACKUP
PASAR: PLM DATA MIGRATION : 8/30/2011
Cycle Diagram Template
Text
TextText
Text
Text
Add Your Text
Cycle Name
PASAR: PLM DATA MIGRATION : 8/30/2011
Progress Diagram Template
Phase 1Phase 1 Phase 2Phase 2 Phase 3Phase 3