Case study

Migrating content to OpenText Documentum for Life Sciences under pressure

Document enrichment

Metadata enrichment of documents

Audit-compliant migration process

Adhered to compliance regulations

Precise & transparent migration control

Continuously traceable process

Thumbnail | Case Study | Anonymized pharmaceutical company

Technology

  • Source system: Extracted data on a file share, XML extracts
  • Target system: OpenText Documentum for Life Sciences Research & Development solution and Quality & Manufacturing solution
  • Product used: migration-center 3.9

Challenge

A global generic and specialty pharmaceutical company had the task of incorporating data that was handed over to them from a different pharmaceutical company via an acquisition to their new Documentum for Life Sciences environment. A critical legal timeline was set to complete the hand over of this data as there would no longer be access to the source data after this date. The client had no direct access to the source system. Therefore the content and metadata had to be extracted and transferred over for further processing. On the target system side this information had to be parsed and converted to the necessary target data model. There were several classifications of documents that had to be taken into consideration:

  1. Documents that should not be migrated to the target system.
  2. Legacy documents that should be migrated as-is to a legacy area as no easy mapping was possible.
  3. Active documents that should be mapped to Documentum for Life Sciences Research & Development and Quality & Manufacturing solutions.

Solution

fme and its product migration-center were chosen to partner with the client to help with the extraction as well as to perform the migration. With the use of migration-center, it was made possible to clean-up the data and parse it before migrating it to the new solutions. The legacy data was migrated as-is while still being available for compliance through preserving the original folder path. It was important to the client to ensure that all active data was mapped appropriately to the new Documentum for Life Sciences solutions. With its transformation capabilities, migration-center provided the necessary ability to enrich the data prior to the import as needed for the successful data mapping.

“We were challenged by an acquisition to gather extractions of data from a source system in a very tight timeline. There was a hard deadline to obtain this data in order to further process it for the import into our new systems. The fme project team worked to ensure this data was successfully gathered within the deadline and migration-center was used to help parse the data and migrate it to our new solution with appropriate mappings as well as enable the ability to map legacy data as-is and have it remain searchable.” Project Manager @ pharmaceutical company