What is data migration and translation? Here is a definition that will help:
- Information exists in different formats and representations. For example, Egyptian hieroglyphics are a pictorial language (representation) inscribed on stone (format)
- However, information is only useful to a consumer in a specific format and representation. So, Roman letters printed on paper may mean the same as an equivalent hieroglyphic text, but the latter could not be understood by a English reader.
- Migration moves data between formats – such as stone to paper
- Translation moves data between representations – hieroglyphics to roman letters
What must a migration and translation achieve?
- The process preserves the accuracy of the information
- The process is consistent
In the PLM world, the requirement for data translation and migration arises as the result of multiple conditions. Examples of these include changes in technology (one CAD system to another CAD system), upgrades to software (from one level of a PLM system to later version), combination of data from two different sources (CAD files on a directory system with files in a PDM), acquisitions and mergers between companies (combine product data) and integration between systems (connect PLM to ERP).
However, migrations and translations can be fraught with problems and require considerable effort. Here are some reasons: […]