tMDataLoader is a tool developed by Clarivate Analytics (Formerly the IP & Science business of Thomson Reuters) in order to automate ETL processes for tranSMART. This is an open-source software, written in Groovy and available for download for both Oracle and PostgreSQL versions of tranSMART. tMDataLoader uses the same Stored Procedures as Kettle but some of them were modified.
tMDataLoader supports all tranSMART clinical and HDD - high dimensional molecular data types (with the exception of the NGS read count observation format).
tMDataLoader includes options for loading, deleting, incremental loading and moving/renaming folders and nodes within the tree of a loaded study. Studies can be deleted by path or by ID. tMDataLoader does not automatically delete platforms associated with HDD data of a study being deleted because the same platform can be associated with multiple studies. If needed, it has to be deleted manually after verifying that other studies will to be affected.
Parameters and where to set them - including any parameters outside the plugin that it also uses.
(screenshot, QA tests)
To be used as screenshots in documentation and as standard QA tests for correct functionality and to pick up changes to results.