The OMrun team at dbi services is a driving force behind a data quality management solution. OMrun, born from the absorption of OMIS by dbi services, stands out for its unique capabilities and efficiency in data processing. We spoke with Marc Keller, Account Manager at dbi services, to better understand this team and their groundbreaking product.
Who’s behind OMrun ?
The OMrun team consists of experienced professionals based in Zurich:
- Frank Zeindler: Product Owner, creator of the initial idea and developer of the first prototype.
- Olivier Schwark: Senior Tester and Quality Engineer, responsible for internal testing and consulting on project implementation.
- Lucas Mancini: Versatile Developer, responsible for implementing new features and supporting marketing efforts.
- Marc Keller: Account Manager, handles OMrun sales and educates dbi services’ internal teams.
Marc Keller emphasizes the importance of this team:
"Our team is our strength. Each member brings unique expertise that contributes to the evolution and success of the OMrun solution, and more broadly, to dbi services."
Product genesis and philosophy
OMrun was created to address a specific need: improving data quality management by processing large amounts of data efficiently and reliably. According to Marc Keller,
"The idea was born from the necessity to handle large amounts of data effectively and reliably, filling the gaps in existing solutions."
The innovation and quality-focused philosophy of OMIS seamlessly integrated with dbi services, reflecting in the solution.
"We strive to reflect these values by providing a robust and scalable solution that meets our clients' growing needs"
adds Keller.
Technical features and integration
OMrun stands out with several unique technical features:
- Powerful Data Comparison Engine: OMrun can process thousands of records per second in heterogeneous environments without requiring an intermediate database. For example, it can compare Oracle and PostgreSQL data in memory.
- Easy Integration: The solution easily integrates with existing systems through preconfigured adapters, facilitating smooth communication with various technologies.
- Complete Automation: OMrun uses predefined templates for generic 1:1 database comparisons, generates table comparison scripts, and creates automated test scenarios for data quality verification.
- Detailed Reports and Dashboards: Each data quality verification run produces detailed reports with evidence and difference lists for further analysis, accessible via a management dashboard.
Use case: Data Migration for a Pharmaceutical company
OMrun has proven its effectiveness in a data migration case for a pharmaceutical company wishing to migrate its product database from Oracle to PostgreSQL. Here are the technical details of the process:
- PoC (Proof of Concept): Conducted with dbi services to demonstrate a fully automated migration and data quality approach.
- Tools Used:
- OMrun for data quality verification: Comparison scripts generated with OMrun took about 10 minutes, and data comparison with four OMrun instances took about 1 hour.
- DBPlus for data migration.
- Statistics:
- Verification of 1,441 tables and over 14,000 attributes.
- Comparison of over 16 million rows and more than 400 blobs.
- 77 tables (5.3%) requiring manual intervention.
- Data Quality Process:
- Comparison of data models (Oracle/Postgres).
- Generation of table comparison scripts.
- Execution of test scenarios.
- Comparison of migrated data.
- Analysis of results and issue resolution.
- Data content comparison.
- Script generation from the data model.
This case enabled the company to migrate tons of critical data without modification, significantly improving their business processes.
OMrun, with its dedicated team and innovative technology, is well-positioned to continue have a huge impact on data quality management. The synergy within the dbi services team and their ability to meet complex market challenges ensure a promising future for OMrun and its clients.