coe 2016: technical data migration made simple
TRANSCRIPT
Technical Data Migration Made Simple
Jonathan ScottRazorleaf Corporation
• Monday» 4115: (DEM) Technical Data Migration Made Simple
11:35:00 AM - 12:25:00 PM | Jonathan Scott
» 4114: (COL) LIVE DEMO: How to Get to Full Digitalization4:35:00 PM - 5:25:00 PM | Brian Lau, Jonathan Scott
• Tuesday» 4116: (IDM) LIVE DEMO: ENOVIA 2013x Tips
2:00:00 PM - 2:50:00 PM | Michael Craffey, Brian Lau
• Wednesday» 4113: (COL) 10 Cool Tools for 2016
12:05:00 PM - 12:35:00 PM | Jonathan Scott
Explaining the Title
• What I’m NOT going to do:» Make the activity of migrating technical data easier» Give advice on technical migration mechanics
Explaining the Title
• What I’m NOT going to do:» Make the activity of migrating technical data easier» Give advice on technical migration mechanics
• What I AM going to do:» Make technical data migrations easier to understand» Give you a framework for explaining it to others
Moving is Painful
Why is Moving Painful?
• The process is time-consuming• Valuables can be broken & lost• You need to clean-up first (or you risk moving junk)• No room for error
Why is Moving Data Migration Painful?
Why is Moving Data Migration Painful?
• The process is time-consuming• Valuables can be broken & lost• You need to clean-up first (or you risk moving junk)• No room for error
SAMEREASONS
Moving Cost Variables
• How many houses (to/from)• How many rooms per house• How many levels per house• Heavy/large furniture• Room-specific delivery• Acceptable breakage (insurance)
Data Migration Variables• Homogeneousness / congruity• Required accuracy (iterations)• Needed transformations• Metadata or files or both• Inter-relationships (CAD links)• Location in Space (logical location)• History (versions/revisions)
Where Are We Going?
PLM
Where Are We Going?
PLM
Data Sources: Homegrown Access DB
Access
PLM
Data Sources: Network File Servers
Access Windows
PLM
Data Sources: ERP System
Access Windows ERP
PLM
How Are We Getting There?
Access Windows ERP
PLM
ECO
s
Data Streams: ECOs
Access Windows ERP
PLM
ECO
s
BOM
Data Streams: BOMs & Comps
Access Windows ERP
PLM
ECO
s
(ECO
)PD
F (D
rwg)
BOM
Data Streams: PDFs
Access Windows ERP
PLM
ECO
sEC
O-C
omp
(ECO
)PD
F (D
rwg)
BOM
Data Streams: ECO-Comp
Access Windows ERP
PLM
ECO
sEC
O-C
omp
ECO
-Drw
g
(ECO
)PD
F (D
rwg)
BOM
Data Streams: ECO-Drwg
Access Windows ERP
PLM
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
g
(ECO
)PD
F (D
rwg)
BOM
Data Streams: Comp-Drwg
Access Windows ERP
PLM
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
g
(ECO
)PD
F (D
rwg)
BOM
OrC
AD
Data Streams: Electrical CAD
Access Windows ERP
PLM
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
g
Mic
rost
ation
(ECO
)PD
F (D
rwg)
BOM
Auto
CAD
OrC
AD
Data Streams: Mechanical 2D CAD
Access Windows ERP
PLM
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
(ECO
)PD
F (D
rwg)
BOM
Auto
CAD
OrC
AD
Data Streams: Mechanical 3D CAD
Access Windows ERP
PLM
CATI
A
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
Offi
ce D
ocPD
F (E
CO)
(Drw
g)
BOM
Auto
CAD
OrC
AD
Data Streams: Office Docs
Access Windows ERP
PLM
CATI
A
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
Offi
ce D
ocPD
F (E
CO)
(Drw
g)
BOM
Auto
CAD
OrC
AD
PDF-
Nati
ve
Data Streams: PDF Relationships
Access Windows ERP
PLM
CATI
A
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
Offi
ce D
ocPD
F (E
CO)
(Drw
g)
BOM
Auto
CAD
OrC
AD
PDF-
Nati
ve
Unnecessary Data Streams
Access Windows ERP
PLM
CATI
A
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
Offi
ce D
ocPD
F (E
CO)
(Drw
g)
BOM
Auto
CAD
OrC
AD
PDF-
Nati
ve
Data Streams & Revision History
Access Windows ERP
PLM
H H H H H L L H H HL
L = Latest Rev H = History
CATI
A
H
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
Offi
ce D
ocPD
F (E
CO)
(Drw
g)
BOM
Auto
CAD
OrC
AD
PDF-
Nati
ve
Data Streams & Accuracy
Access Windows ERP
PLM
H H H H H L L H H HL
L = Latest Rev H = History
CATI
A
H
90%
Estimating ECO Data Stream
• Latest revision only• Metadata without files• 90% accuracy means only 3 iterations
Estimating ECO Data Stream
• Latest revision only• Metadata without files• 90% accuracy means only 3 iterations
• 2 days to develop the process• 3 days to automate the process• 2 days for refinement 1• 1 day for refinement 2
8
Estimating CATIA Data Stream
• Full revision history• Metadata and files, files links, links to “space”• 90% accuracy means only 3 iterations
Estimating CATIA Data Stream
• Full revision history• Metadata and files, files links, links to “space”• 90% accuracy means only 3 iterations
• 8 days to develop/automate the process• 4 days for refinement 1• 2 days for refinement 2 14
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
Offi
ce D
ocPD
F (E
CO)
(Drw
g)
BOM
Auto
CAD
OrC
AD
PDF-
Nati
ve
Data Stream Estimates
Access Windows ERP
PLM
H H H H H L L H H HL
L = Latest Rev H = History
CATI
A
H
90%
8 14
ECO
sEC
O-C
omp
ECO
-Drw
gCo
mp-
Drw
gSo
lidW
orks
Mic
rost
ation
Offi
ce D
ocPD
F (E
CO)
(Drw
g)
BOM
Auto
CAD
OrC
AD
PDF-
Nati
ve
Data Stream Estimates
Access Windows ERP
PLM
H H H H H L L H H HL
CATI
A
H
90%
6 6 8 13 9 9 6 10 10 118 14
110
Migration Accuracy90% = 110 days (3 iterations)
Migration Accuracy90% = 110 days (3 iterations)
95% = 121 days (4 iterations)
98% = 133 days (5 iterations)
99% = 146 days (6 iterations)
Always Ask Questions
• Which file types are included/excluded?• Which locations/sources are included/excluded?• Latest versions or full revision history?• Correlation of native files to static files?• Will security be maintained?• How accurate will the results be?
Data Migration Key Factors• Homogeneousness / congruity• Required accuracy (iterations)• Needed transformations• Metadata or files or both• Inter-relationships (CAD links)• Location in Space (logical location)• History (versions/revisions)
Data Migration Key Factors• Congruity
Data Migration Key Factors• Congruity• Accuracy required (iterations)
Data Migration Key Factors• Congruity• Accuracy required (iterations)• Transformation needed
Data Migration Key Factors• Congruity• Accuracy required (iterations)• Transformation needed• Files or just metadata
Data Migration Key Factors• Congruity• Accuracy required (iterations)• Transformation needed• Files or just metadata• Inter-relationships (CAD links)
Data Migration Key Factors• Congruity• Accuracy required (iterations)• Transformation needed• Files or just metadata• Inter-relationships (CAD links)• Space (logical location)
Data Migration Key Factors• Congruity• Accuracy required (iterations)• Transformation needed• Files or just metadata• Inter-relationships (CAD links)• Space (logical location)• History (versions/revisions)
Moving is Painful