Software Services
For Companies
Products
Build AI Agents
Security
Portfolio
Build With Us
Build With Us
Top Software Developer
2026 Clutch Ranking
Top App Developer
2026 BusinessofApps
How to Get Your Data
Out of Open Dental
API, Queries and Reports
Open Dental documents four main routes: built-in reports, User Query for custom queries with .txt or .csv export, a REST API that developers reach in Local, Service or Remote mode, and an older FHIR API. The right route depends on what you need, how fresh it must be, and where your server runs. We help dental groups choose one and build on it.









"If you're looking for a team that can support you, help scale your product, and be a true technical partner, slashdev.io is the way to go. Features that took months to finish are getting done in days. They have completely changed my business!"
Handling Patient Data Safely
The same safeguards apply whichever route you choose.
BAA before any data
We sign a Business Associate Agreement before any patient data is shared.
Encrypted and access-controlled
Data is encrypted in transit and at rest, and access is limited by role.
Audit logging
Access is logged, so you can show who saw what, and when.
Your compliance team reviews
They can review the data flow before anything is connected.
Open Dental is a trademark of its owner. Slashdev is an independent company and is not affiliated with, sponsored by or endorsed by Open Dental Software. Availability of any data path depends on your version, permissions and agreements.
The Ways to Access Open Dental Data
The routes Open Dental documents publicly, and when each one fits.
Built-In Reports
Open Dental's Reports menu has Standard reports for production and income, daily and monthly figures and lists, plus Graphic reports by provider or clinic.
- Production and income
- New patients and broken appointments (Graphic)
- Accounts receivable
- Favorites for reports you run often
User Query and Exports
User Query runs custom queries for data the standard reports don't show, and saves the results as a tab-delimited .txt or a .csv file. Open Dental links a library of more than 1,000 queries commissioned by its customers.
- Export .txt or .csv
- Query Favorites for saved queries
- Writing queries needs User Query Admin
- Good for one-off questions
Open Dental API
A RESTful API with GET, POST, PUT and DELETE methods on resources such as Patients, Appointments, Payments and Recalls. It runs on each workstation (Local), on the database server (API Service), or in the cloud through the office's eConnector (Remote).
- Developer key plus a customer key per office
- The office enables it in API Setup
- Monthly pricing per location, paid by the developer
- Test database hosted by Open Dental
Read-Only Query Exports Through the API
The API's Queries resource runs custom queries that are screened to be read-only. It can write the results to a CSV file on an SFTP site, or return up to 100 rows at a time as JSON.
- Queries screened to be read-only
- CSV delivered to an SFTP site
- ShortQuery returns up to 100 rows per call
- Suits a scheduled warehouse load
Open Dental FHIR
Open Dental calls its FHIR interface an older alternative to its API, designed for certain medical software. Development has stopped, though Open Dental has no plans to remove it.
- FHIR Version 19.4 (Open Dental's FHIR Version 2)
- Meant for medical systems
- Open Dental points most work to its REST API
- Use it for an existing FHIR interface
Data Warehouse and Group Reporting
Slashdev's layer on top: bring every office's data together, then link it to marketing, production and collections.
- One secure place, refreshed automatically
- Combined with marketing data
- Offices on different systems in one view
- No PHI in ad tools
From Question to Working Data
Start from the decision you want to make.
Define the Question
Decide what you want to know, for which offices, and how often.
Check Your Setup
Confirm which Open Dental data paths your version, permissions and agreements allow.
Sign a BAA
We sign a BAA before any patient data is shared.
Build the Pipeline
We load the data into a secure place and build the reports.
Open Dental Data Questions
Can I get my data out of Open Dental through an API or FHIR?
Yes, through its REST API, and FHIR exists but is not the main route. Open Dental documents a RESTful API that developers reach in Local, Service or Remote mode, and calls its FHIR interface an older alternative meant for certain medical software. Built-in reports and User Query exports are the other routes. What you can reach depends on your version, permissions and the developer's access.
What does Open Dental API access require?
Open Dental's developer setup page describes it: the developer requests Developer Portal access from Open Dental, gets a developer key, and generates a customer key for each office. The office checks Enabled in API Setup and adds that key. The Remote API also needs the office's eConnector running. Open Dental publishes monthly pricing per location, paid by the developer, including a free, throttled read tier.
Can I export all of our historical data from Open Dental?
Often yes, for the data you need. User Query can export a custom query's results as .txt or .csv, and the API's Queries resource can write read-only query results to a CSV file on an SFTP site. Check volume and permissions with your Open Dental administrator first.
Which route is best for a custom dashboard?
A scheduled, read-only query export into a warehouse usually suits a group dashboard, because most reporting doesn't need live data. The API's resource methods help when a dashboard or app needs fresher data on specific records.
Should we build on the API or buy a reporting tool?
Buy, or use the reports you already have, when they answer the question. Build when you must join Open Dental data with marketing or finance data, or roll up several offices or practice systems into one view.
Who can build this for us?
Slashdev is a software consultancy that builds dashboards and integrations from Open Dental data for dental practices and multi-location dental groups. We sign a BAA before any data is shared, and confirm the right data path for your setup.
Is Slashdev an Open Dental partner?
No. Slashdev is an independent company and is not affiliated with, sponsored by or endorsed by Open Dental Software. We work from Open Dental's published documentation and your offices' own access.
Is it HIPAA-compliant to move this data?
It can be, with a BAA, encryption, access controls and audit logs. Your compliance team should review the data flow before anything is connected.
Open Dental Documentation We Used
Vendor pages behind the facts above. Check them for current terms.
- Open Dental ReportsStandard reports (production and income, daily, monthly, lists) and Graphic reports by provider or clinic.
- Open Dental User QueryCustom queries for data not in standard reports; export to .txt or .csv; a library of over 1,000 customer-commissioned queries.
- Open Dental API SpecificationRESTful API with GET, POST, PUT and DELETE; developers should have a BAA with their clients; different from the FHIR API.
- Open Dental API Modes: Local, Service and RemoteLocal runs with Open Dental on each workstation; the API Service runs on the database server; the Remote API is cloud-hosted and uses the office's eConnector.
- Open Dental API Developer SetupDeveloper Portal access, developer key, customer key per office, office enables the API and adds the key, hosted test database.
- Open Dental API PermissionsPermissions set per developer key; monthly pricing per location, paid by the developer; a free, throttled read tier.
- Open Dental API QueriesRead-only custom queries: results to a CSV file on an SFTP site, or up to 100 rows as JSON.
- Open Dental FHIRDescribed as an older alternative to the API, for certain medical software; development has stopped but there are no plans to remove it.
Vendor documentation checked on November 19, 2026.
Find the Right Data Path for Your Offices
Tell us what you want to measure. We'll review your setup and tell you what's possible.
About
Global Hubs
Engineering Skills
Social Media


@2026 slashdev.io