Central Enterprise Management Tool ( CEMT )

In the Open Dental install folder, run CentralManager.exe.

After logging on, the Central Manager - Admin CEMT window will open. The Central Enterprise Management Tool (CEMT) allows Multiple Locations to use separate databases at each location, yet have a centrally located management tool to interact with all the databases.

The CentralManager.exe is shipped and installed in the same Open Dental folder as the main program. It connects to a mostly blank Open Dental database (e.g. dbcentral) that does not have any patient information or use most of the normal tables. It does have some of its own tables that are ignored by the ordinary Open Dental program. Before initial use, you must configure the CentralManagerConfig.xml file.

Requirements:

Updates: To prevent accidental updates of Open Dental when multiple locations potentially run different Open Dental versions, set an Update Server Name (also known as Middle Tier Server Name) in Miscellaneous Setup. This computer will be the one and only computer that has permission to execute updates.

Central Manager Window

From this central location you can easily:

Menu:

Conn Groups: Click a dropdown option to only view connections for a specific group. Set the default on the Connection Groups window.

Filter Connections: Filter the connections. Enter criteria then click Filter.

Refresh Statuses: Click to refresh the connection statuses.

Version: Displays the current CEMT version.

The connections grid displays connection information. Double-click a connection to launch a separate instance of Open Dental for that database. You will be logged on using your CEMT username and password.

Patients can be searched between all connected databases. Enter criteria, then click Search. Patients who match criteria will list with their associated database connection.

Troubleshooting

Problem: Name conflicts when syncing users (states which names are in conflict).

Solution: Rename the CEMT user using a unique user name. Because CEMT users never show up in the normal Open Dental interface, their username can be anything. For example, Open Dental user Sally, could use SallyCEMT as her CEMT username. The chances of conflicts are very slim. After renaming users, make sure to sync all Open Dental databases.

Problem: Log in failed message when trying to connect to an Open Dental database.

Solution: Sync the CEMT credentials for the user to the Open Dental database.

Problem: SERVER OFFLINE: incorrect user name or password on a middle tier connection.

Solution: Ensure that the username and password exist in the database connection. If unable to push the credentials for the user from the Central Manager, add them to the database with a direct connection.