Integration accessing SQL DB or middle tier
Posted: 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!
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!