Hello. I’m working on a set of mappings and related implementation for representing clinical study data in OHDSI. I’m interested in what tools people have used to implement the mapping. Since I’ll be doing ETL for a number of studies, I’d like to represent the mappings in a table rather than code. I hope to win both in terms of documentation and reduced duplication of effort. My background is in software development, though this is the closest I’ve gotten to ETL work. I’m toying with a little bit of Python and SQL to get my arm around this. At the same time I’m reading about tools like Kettle to see if there is some great leverage to be found there. I’ve also had a look at some of the documentation for the Janssen CDM v5 sample ETL. While my respect for the logical mapping is growing, what are people using to actually move the data?
thanks
-Chris