{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,26]],"date-time":"2026-03-26T14:38:04Z","timestamp":1774535884531,"version":"3.50.1"},"reference-count":0,"publisher":"IOS Press","isbn-type":[{"value":"9781643683485","type":"print"},{"value":"9781643683492","type":"electronic"}],"license":[{"start":{"date-parts":[[2022,11,3]],"date-time":"2022-11-03T00:00:00Z","timestamp":1667433600000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2022,11,3]]},"abstract":"<jats:p>Improving the interoperability of healthcare information systems is a crucial clinical care issue involving disparate but coexisting information systems. However, healthcare organizations are also facing the dilemma of choosing the right ETL tool and architecture pattern as data warehouse enterprises. This article gives an overview of current ETL tools for healthcare data integration. In addition, we demonstrate three ETL processes for clinical data integration using different ETL tools and architecture patterns, which map data from various data sources (e.g. MEONA and ORBIS) to diverse standards (e.g. FHIR and openEHR). Depending on the project\u2019s technical requirements, we choose our ETL tool and software architecture pattern to boost team efficiency.<\/jats:p>","DOI":"10.3233\/shti220974","type":"book-chapter","created":{"date-parts":[[2022,11,3]],"date-time":"2022-11-03T04:38:03Z","timestamp":1667450283000},"source":"Crossref","is-referenced-by-count":11,"title":["ETL Processes for Integrating Healthcare Data \u2013 Tools and Architecture Patterns"],"prefix":"10.3233","author":[{"given":"Ka Yung","family":"Cheng","sequence":"first","affiliation":[{"name":"Institute for Medical Informatics and Statistics, Kiel University, Germany"},{"name":"University Hospital Schleswig-Holstein, Kiel, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Santiago","family":"Pazmino","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics and Statistics, Kiel University, Germany"},{"name":"University Hospital Schleswig-Holstein, Kiel, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bj\u00f6rn","family":"Schreiweis","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics and Statistics, Kiel University, Germany"},{"name":"University Hospital Schleswig-Holstein, Kiel, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"7437","container-title":["Studies in Health Technology and Informatics","pHealth 2022"],"original-title":[],"link":[{"URL":"https:\/\/ebooks.iospress.nl\/pdf\/doi\/10.3233\/SHTI220974","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,11,3]],"date-time":"2022-11-03T04:38:03Z","timestamp":1667450283000},"score":1,"resource":{"primary":{"URL":"https:\/\/ebooks.iospress.nl\/doi\/10.3233\/SHTI220974"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,11,3]]},"ISBN":["9781643683485","9781643683492"],"references-count":0,"URL":"https:\/\/doi.org\/10.3233\/shti220974","relation":{"is-referenced-by":[{"id-type":"doi","id":"10.1038\/s41598-025-04046-9","asserted-by":"object"}]},"ISSN":["0926-9630","1879-8365"],"issn-type":[{"value":"0926-9630","type":"print"},{"value":"1879-8365","type":"electronic"}],"subject":[],"published":{"date-parts":[[2022,11,3]]}}}