Integration accessing SQL DB or middle tier

This forum is for programmers who have questions about the source code.
Post Reply
jtang
Posts: 1
Joined: Tue Nov 22, 2022 8:28 pm

Integration accessing SQL DB or middle tier

Post by jtang » Tue Nov 22, 2022 9:00 pm

Hi all!

I'm writing an Open Dental integration that will make queries to the SQL database. I would like the integration to be compatible with as many practices as possible.

Should I be worried about reading from the SQL database directly? Is it common for practices to install integrations directly on the server machine where the SQL database is accessible?

I saw that some practices might have a "middle tier" set up. Should I be concerned with accessing the database through this middle tier?

Thanks very much!

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Integration accessing SQL DB or middle tier

Post by jsalmon » Fri Nov 25, 2022 2:51 pm

Sounds like you probably want to make your integration with the API instead of directly to the database. Less for you to worry about.
https://www.opendental.com/site/apispecification.html
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply