OD DataBase

This forum is for programmers who have questions about the source code.
Post Reply
TrainingGirl
Posts: 1
Joined: Tue Nov 10, 2015 6:04 am

OD DataBase

Post by TrainingGirl » Wed Nov 18, 2015 6:49 am

I'd like to create some quires and reports that may help me with some aspects. So, I need to get these questions answered, please:

What is the path of open dental data base? What is it extension?

How can I import the tables of open dental data base to access 2003 or access 2007?

Thanks in advance!

User avatar
dgraffeo
Posts: 147
Joined: Wed Sep 24, 2014 3:19 pm

Re: OD DataBase

Post by dgraffeo » Wed Nov 18, 2015 9:08 am

The OpenDental Database is installed wherever the user specifies when they install the trial version of OpenDental and select the New Server option. The database is a collection of files and so doesn't have a single extension. I have no experience with Access so I can't help you with that one.
"To understand what recursion is, you must first understand recursion."

David Graffeo
Open Dental Software
http://www.opendental.com

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: OD DataBase

Post by Tom Zaccaria » Wed Nov 18, 2015 1:47 pm

Not a good idea. Access is not robust enough to handle all the tables in OD.

drtmz

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: OD DataBase

Post by tgriswold » Fri Nov 20, 2015 12:38 pm

David and Tom are correct. You cannot use Access for Opendental. Access is NOT a database management system because its not relational, nor is it supported by OD. However, you can export data from mysql to something like excel if you wanted, but it would just be a snapshot of what was in OD at the time. Your best bets are to either use a mysql query to export the data you need to build a report in another program, or design a mysql query to generate the report you want. http://www.opendental.com/manual/progra ... urces.html has links at the top to our database documentation which will give you an idea of what our tables look like. http://opendentalsoft.com:1942/ODQueryL ... yList.aspx is a list of over 1000 different query examples we've generated over the years, which may be able to suit your purposes or be adapted to do what you want. And finally, you can download the source code of OD and dig through it to see how we generate our internal reports.

The path to the OD database is completely up to the mysql service running on the server, but can be found in the mysql my.ini on the server hosting the database. You can look more into how mysql stores databases online in the mysql documentation, but it depends if the user is using MYISAM or INNODB tables.
Travis Griswold
Open Dental Software
http://www.opendental.com

Post Reply