Page 1 of 1
Can ya use the power aPps mysql connector and gateway...
Posted: Wed Jan 11, 2023 9:05 pm
by Ray.Casey
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?
Re: Can ya use the power aPps mysql connector and gateway...
Posted: Thu Jan 12, 2023 9:08 am
by SLeon
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.