Anyone familiar with a dental practice management software called MOGO? If yes, how can I integrate it into my app that will be my very first app which is for my father's denta practice?

What are you wanting the app to do in regards to the software?

mainly to book appointments, new patient fill-in form that can be submitted into MOGO which saves time for the secratary

also that it can connect with the SQL database that MOGO has

I looked at the software online a little and it looks as though a large portion of it is web based. Correct?

Hi @CSSZiegler, First you have permission to do this? Copyrights and Infringements are being closing watched in both stores! Would this be for IOS or Android? LA

@LA that is where I was heading with this as well.

The version we have currently is from a CD, not web-based or cloud-based but we plan to be upgrading soon to the cloud. LA, of course I have permission. I'm being hired to do this and yes both for iOS and Android

@LA correct me if I am wrong @CSSZiegler once you upgrade to the web based the easiest way would be to us the custom URL plugin and set them to load the web pages specific to what you want. This I believe creates an issue with Apple because you can do the same thing on the website but Google doesn't have much of an issue with it. So if you also add something like a navigation map for the office location and directions to get there it will help with the approval. But once you upgrade you will have to pay close attention to the software's copyright policy to ensure you do not overstep on of MOGO's "boundries".

@CSSZiegler When you work with data in the medical field you have to keep in mind the HIPPA requirements. Accessing a database without the proper security could put your company in violation. That being said, the best thing to do would utilize a secret code that changes randomly with each client and expires after just a couple of hours. This would allow the person to enter information into the form while on site but not after they get home. This information could be placed in the MOGO database or a separate database on a secured server once the form was submitted. For appointments what I have seen in the past is the client submits a form requesting one or more times and the appointment desk makes the final decision and lets the client know which time they are signed up for. Hope this helps. Joe Cool

Now I just have to grasp what everyone just said, LOL

Most medical companies who need apps will ignore open source software. Another thing you will have to think about is licensing your own.

In terms of the 'how', it sounds like this software runs off of a Windows SQL Server, rather than a web-based MySQL server. Is that correct? I assume so if you installed the software via CD. If that's true, you'll need to investigate "Stored Procedures" and pay really careful attention to how the software is making use of tables. (Certain columns are often joined across tables and so if you add a record to one table you better make add records to all associate tables or risk crashing the program).

Yes, correct to Windows SQL Server