Can ya use the power aPps mysql connector and gateway...

For users or potential users.
Post Reply
Ray.Casey
Posts: 11
Joined: Wed Jan 11, 2023 2:08 pm

Can ya use the power aPps mysql connector and gateway...

Post by Ray.Casey » Wed Jan 11, 2023 9:05 pm

To access the opendental schema (read only and not CRUD), or do ya have to use the ApI? If the latter is the case, has anyone used APM or a custom connector to wrap up the OD API to expose it to powerapps, power portal or Power BI?

SLeon
Posts: 476
Joined: Mon Mar 01, 2021 10:00 am

Re: Can ya use the power aPps mysql connector and gateway...

Post by SLeon » Thu Jan 12, 2023 9:08 am

Good morning,

In regards to you first question, Open Dental recommends developers use the API to interact with customer databases.

From the Programming Resources page:
Queries
Simple read-only operations can be performed with queries. This is useful for reports. Any third party is welcome to query the database as long as no writes are involved. We have security measures in place to prevent writing to the database, so don't even think about it.
and
API
This is the only way of interacting with Open Dental for any action that requires a write to the database. Direct writes to the database are never allowed other than by going through the API.

More information on our API can be found on its specification page and forum.

Post Reply