Migration of MDL/ISIS sample database to ACD/Spectrus DB Platform
Customer
Pharma company
Goal
Migrate obsolete samples database to a recent system
Description
To preserve production operations and historical data, the no-longer supported MDL/ISIS Base database had to be migrated to a Windows 10 compatible software. ACD/Spectrus platform has been chosen as destination software because of its capability to store and search chemical structures and spectra to enrich the knowledge collected around a specific sample. To successfully accomplish the task three steps have been taken:
- Proof of Concept to determine export feasibility with special attention to molecular structure conversion issues
- Reverse engineering approach to derive the underlying data model.
- Data migration from source model to target data model with Extract-Transform-Load (ETL) KNIME workflow (Link to KNIME session)
- Configuration of screen and entry forms in the target software to improve user experience and data integrity.
Team
