The integration of heterogeneous healthcare data sources is a necessary process to enable the secondary use valuable information in clinical research. Data integration is time-consuming for data stewards. The transformation using predefined rules for data harmonization can reduce the time-consuming and error-prone work and ease the data integration at various sites. In our study, we examined various script(ing) languages to find the most suitable candidate for definition of transformation rules and implement a smart editor which supports the data stewards in selecting rules reusing them. Thereby, it also provides an automatic and seamless documentation to strengthen the reliability of the defined transformation rules.
Keywords: Data Warehousing; HL7 FHIR; Health Information Interoperability.