Page 1 of 1

Integration accessing SQL DB or middle tier

Posted: Tue Nov 22, 2022 9:00 pm
by jtang
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!

Re: Integration accessing SQL DB or middle tier

Posted: Fri Nov 25, 2022 2:51 pm
by jsalmon
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