Integration accessing SQL DB or middle tier

[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!

[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