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.


Key Features:

  • 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



TCI set-up process



TCI Data Creation Process

Additional information can be found here  https://popmednet.atlassian.net/wiki/spaces/DOC/pages/208929021/TCI+-+SQL+Test+Case+Inserter