# Extract data from OpenEMR **URL:** \ **Category:** Management and Administration\ **Created:** [November 13, 2019, 5:10am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138 "2019-11-13T05:10:04Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Noor](https://community.open-emr.org/letter_avatar_proxy/v4/letter/n/c67d28/32.png) [@Noor](https://community.open-emr.org/u/Noor)\ **Post date:** [November 13, 2019, 5:10am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/1 "2019-11-13T05:10:04Z")
Hi, Situation: I am looking for a way to extract patient data from OpenEMR. Question: Is it possible to extract patient data using MIRTH connect?. If it is possible, then how to link MIRTH with OpenEMR? can anyone please help. Thank You. Regards- Noor ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 13, 2019, 11:16am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/2 "2019-11-13T11:16:03Z")
hi @Noor, might want to play around with the API to see if it gets you going in a good direction, [Integration Engine](https://community.open-emr.org/t/integration-engine/13143/2?u=stephenwaite) ---
**Author:** ![Noor](https://community.open-emr.org/letter_avatar_proxy/v4/letter/n/c67d28/32.png) [@Noor](https://community.open-emr.org/u/Noor)\ **Post date:** [November 13, 2019, 11:24am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/3 "2019-11-13T11:24:55Z")
Thanks for the reply Stephen, Is there any way to extract the data from OpenEMR. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 13, 2019, 11:41am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/4 "2019-11-13T11:41:34Z")
if you follow the API guide further down you will see `GET` requests which will extract data here’s a [popular app](https://learning.getpostman.com/docs/postman/sending-api-requests/requests/) that can help get you started ---
**Author:** ![Noor](https://community.open-emr.org/letter_avatar_proxy/v4/letter/n/c67d28/32.png) [@Noor](https://community.open-emr.org/u/Noor)\ **Post date:** [November 13, 2019, 11:45am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/5 "2019-11-13T11:45:23Z")
Thank you Stephen. I will definitely look into that. ---
**Author:** ![Noor](https://community.open-emr.org/letter_avatar_proxy/v4/letter/n/c67d28/32.png) [@Noor](https://community.open-emr.org/u/Noor)\ **Post date:** [November 13, 2019, 11:53am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/6 "2019-11-13T11:53:27Z")
Hi Stephen, One last question. Are there any other ways other than using API. Thank you Regards- Noor ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 13, 2019, 12:48pm UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/7 "2019-11-13T12:48:27Z")
sure, Mirth has been used for hl7 data, like [this post describes](https://community.open-emr.org/t/lis-integration-with-open-emr/10557/12?u=stephenwaite) ---
**Author:** ![visolveemr](https://community.open-emr.org/user_avatar/community.open-emr.org/visolveemr/32/10974_2.png) [@visolveemr](https://community.open-emr.org/u/visolveemr)\ **Post date:** [November 26, 2019, 7:35am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/8 "2019-11-26T07:35:21Z")
Hello Noor You can able to extract the patient medical records using **CCDA** (Consolidated Clinical Document Architecture) -created by HL7 to exchange standardized data between healthcare providers. You can also import CCDA file into openemr to load patients from other vendors. Thank You [ViSolve-051](http://www.visolve.com/hc) ---
**Author:** ![htuck](https://community.open-emr.org/user_avatar/community.open-emr.org/htuck/32/15185_2.png) [@htuck](https://community.open-emr.org/u/htuck)\ **Post date:** [December 2, 2019, 9:16pm UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/9 "2019-12-02T21:16:19Z")
Hello Noor- Of course there’s the old-fashioned method of running queries against the EMR’s MySql database. You’ll need to install phpMyAdmin, since it doesn’t come bundled with the EMR any more, or adminer, which is simple but quite capable. Install instructions on the relevant websites. It will take a bit of work to find all the table JOINs necessary for complex queries but isn’t too hard if you have SQL-competent people at hand. ---
**Author:** ![visolveemr](https://community.open-emr.org/user_avatar/community.open-emr.org/visolveemr/32/10974_2.png) [@visolveemr](https://community.open-emr.org/u/visolveemr)\ **Post date:** [December 3, 2019, 5:07am UTC](https://community.open-emr.org/t/extract-data-from-openemr/13138/10 "2019-12-03T05:07:32Z")
@Noor, Another old fashioned way is - if you have access to the MySQL server, login to the server, run mysql application on the server and query the data base -[ViSolve001](http://www.visolve.com/hc)