To be clear, designing the ETL process to move the data is a manual process. We hope that there will be standard elements which most warehouses will want to use that can be shared, but the individual data elements and cleansing them will be a site-by-site process. Once the ETL is complete, it can be automated to write to the warehouse on a regular basis. You then would derive OLAP cubes which would need to be refreshed for the analytical part...
Andy -------------------- Andrew S. Kanter, MD MPH - Director of Health Information Systems/Medical Informatics Millennium Villages Project, Earth Institute, Columbia University - Asst. Prof. of Clinical Biomedical Informatics and Clinical Epidemiology Columbia University Email: [email protected] Mobile: +1 (646) 469-2421 Office: +1 (212) 305-4842 Skype: akanter-ippnw Yahoo: andy_kanter >________________________________ > From: Sokha RUM <[email protected]> >To: [email protected] >Sent: Wednesday, March 14, 2012 3:35 AM >Subject: Re: [OPENMRS-DEV] OpenMRS: ETL/Data Warehouse/Reporting > >Hi Darius, > >Thank you for your feedback. >So it means that OpenMRS can connect to a DW, but it has to be done in a >manual process. > >Sokha. > >_________________________________________ > >To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to >[email protected] with "SIGNOFF openmrs-devel-l" in the body (not >the subject) of your e-mail. > >[mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l] > > > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
