OHDSI Home | Forums | Wiki | Github

Best Approach for Combining Harmonized Data from Two ETLs

Hello everyone!

I’ve successfully completed ETL processes for two datasets from two different hospitals, with the goal of harmonizing them for joint analysis. For the ETL procedures, I used the open-source repository provided by The Hyve (https://github.com/thehyve/ohdsi-etl-prias).

Now, I’m wondering what the best approach is to combine the results of these two ETLs. Should I merge all harmonized data into a single schema, or is it better to maintain two separate schemas for each dataset and perform the same research question in two steps?

I would appreciate any advice or best practices on how to proceed with this!

t