Test Case Inserter (TCI)
The Test Case Inserter (TCI) is a purpose-built command-line program that expedites the PopMedNet development and validation process as it accurately creates synthetic databases that adhere to any common data model, such as PCORnet, Sentinel, and ad hoc databases. This addresses the usual time-intensive process of generating test data in multiple RDBMS. Additionally, this allows us to validate that the new PMN MDQs are accurate and consistent across the different database flavors.
- Generates databases according to data format (e.g. Common Data Model or CDM) specifications
- Custom program that enables users to easily insert synthetic data into a relational database management system (RDBMS) without requiring the user to have SQL programming skills
- Supports PMM Menu-Driven Query (MDQ) validation and MDQ prototypes for targeting new data sources
Additional information can be found here https://popmednet.atlassian.net/wiki/spaces/DOC/pages/208929021/TCI+-+SQL+Test+Case+Inserter