SUCCESS STORY
Migration to TrackWise Digital
-
CUSTOMER
Industry: Life Science / Pharma
Location: Switzerland -
SOLUTIONS
Source: TrackWise
Target: TrackWise Digital -
RESULTS
Successful, validated migration of records & attachments from the Quality Management solution TrackWise (on-prem) into TrackWise Digital (cloud-based).
PROJECT BRIEF
Business Department: Quality Management
Application Profile: Business critical application for Quality incl. CAPA, Change Control and other GxP related processes.
Approach: Selection, verification and extraction of specified records and attachments and import to the target application.
Source System: Sparta Systems TrackWise
Target System: Sparta Systems TrackWise Digital
CHALLENGE
Our Swiss Life Science customer was facing the challenge of a complete carve-out of facilities, staff, applications, and data after the company was sold out. The necessary reorganization, segregation, and transition were a parallel challenge on its own.
The selection of relevant records to be migrated while the system was constantly used required a close alignment between all involved parties.
A guaranteed ability to successfully pass future quality audits and to further ensure product and patient safety is key in such a program. .
Joachim Freitag, Project Manager IseoSolutions
“When Quality starts using a new Cloud application, it’s always a big deal. If it’s a regulated environment, and you deal with Quality data, you know that a top notch qualification was necessary to get there.
As the GoLive included records, attachments including open Quality processes to be migrated into the new application, stakes were even higher to guarantee completeness, integrity, and data quality. ”
CUSTOMER'S GOAL
Data Completeness
Identify required records & attachments based on selected products and QA units from the existing application TrackWise on-prem including open & closed records.
Review & Approve Data Extraction
Review selected records & attachments and approve selection by Data Owners.
Ensure consistency of links to cloned OpenText DMS
Migrated links pointing to a clone of a migrated OpenText Content Server must work to ensure access to quality documents not migrated to TrackWise Digital.
Ensure integrity & validation
Import records & attachments into TrackWise Digital Business Objects & test extensively to ensure a validated system after data migration.
IMPLEMENTED SOLUTION
Our data migration project required an already validated target system - configured fit for purpose according to the requirements of our client.
The customized TrackWise objects with records & attachments needed to fit into the new TrackWise Digital Business Object structure and data model, so data mapping and linking was a key topic during the DryRun phase on the test servers of the 3 staged TrackWise Digital cloud application.
The scoping and mapping of the data was constantly aligned with the Quality department since changes of the migration scope (more products to be considered) happened during the migration project.
After thorough testing of the migration using the TrackWise Transfer migration tools & scripts, the final data extracts were imported into TrackWise Digital while documenting the whole import and testing process meticulously using Migration Logs.
The delivered solution can be divided into the following main areas:
Data selection & approval
Data mapping
Data extraction and transformation
Data import & testing
The TrackWise Transfer tool, The Salesforce Data Loader & CLI (SFDX) and SFDX Data Move Utility (SFDMU) were used to perform the data migration.
RESULTS
We have managed the complete data migration project of totally >22`000 records, from which around 7`000 are open records, with several involved external companies, multiple key business stakeholders, and technical staff in two client companies.
The organization and constant alignment of tasks, activities, and deliverables for the technical migration as well as the parallel Validation Management were handled by the IseoSolutions Team.
The necessary project documentation including Data Migration Plan, Data Migration Test Specification and Data Migration Report for a successful data migration validation was created, aligned, and approved electronically.
The whole project team including key customer staff, different external parties for the migration, and the TrackWise Digital target system worked very hard to make the project a success.
Provided Consulting Expertise
Project Management & Governance
Data Selection & Migration Approach
Data Migration Qualification & Testing
Validation Management
