We have two programs. One is destop based and one is web based. The desktop based application is at [url removed, login to view] The web based application is [url removed, login to view] We need the the desktop application to push the patient demographics to the web based application database and pull from the web based application database the patient balance. The desktop application is a client server application running on a MsSQL database. The patient data is originated in the Loop program and when the patient is added to the schedule then the patient needs to be added to the patient database of the EMR program. The Loop program will be run as the front end scheduling instead of the built in scheduler of the OpenEMR program. There are more pieces that will need to be shared but this is the first and most basic piece of information the programs need to share. Any ideas on how to make the two programs work better together would be reviewed and appreciated. The desktop application is written in C#.
The ideal would be to have a sync engine, but that is just my idea. This data has to be automatic.