How much data are you looking for?(we have some basic demo data that is used in the demos and we are currently working on supporting bringing in large amounts of demo data along with support for heavy data analysis): Can see several related project on the project roadmap here: http://www.open-emr.org/wiki/index.php/Roadmaps

We are also currently working on providing support for EDU (education, classrooms, instructional, research) use and can see more on this here: OpenEMR EDU

Thanks so much for your great support and quick answer. I would like to get enough data so we can create case-based scenarios for different classes. After each quarter, we should be able to reset the database and start over or add new data.

However, I have a bigger problem. We installed the application in AWS and I am trying to figure out how to have access directly to the database. I want to be able to import data automatically using mysql or phpmyadmin.

Once I know that, it will be easier to import the data. I know this is open source and perhaps we don’t get personalized support. If someone can guide me trying to find the way to get into the database, it will be great.

It sounds like you’re not in the security group of the OpenVPN instance – make sure that the VPN is in an EC2 security group that allows access from your location on port 22. Add a security group if necessary to arrange this.

(You may need to add access to 443 and 943 as well – something tells me they may be blocked too.)

You have to use VPN to access the database because the SQL server is locked behind the VPC – no connections are possible from outside that network.

I hope this helps! You might consider consulting your colleague for further support, since they seem handy enough with AWS to be able to operate CloudFormation.

Well, both are new to AWS… We get totally lost on this system… We have tried many times but when we get to Step 5 of Establish a VPN Server for Private Cloud Access we don’t see the value openemr-vpc. on the listbox for Network.

Do you remember running the stack in CloudFormation? It said CREATE_IN_PROGRESS for a while, and there were several tabs in the middle of the screen that discussed “Output” and “Events” and “Resources”?

Return to CloudFormation and select ‘Resources’, and scroll down for where it talks about the VPC created for the stack. THAT’s the VPC you assign the VPN instance to, at the spot where you’re stuck – earlier versions of this guide created the network through a different technique that allowed it to be named.

Nothing has worked yet. I am looking for a person/company who can spend 3-5 hours with us remotely and we can get this done. We don’t need anything else, just access to the database so we can create our own using the testing sample. And yes, we know about database integrity issues.