Central Enterprise Management Tool ( CEMT )

See Advanced Topics.

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

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 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.

From this central location, easily:

Requirements:

Also see:

Central Manager Window

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. Users are logged on using their CEMT username and password.

Patients can be searched between all connected databases. Enter criteria, then click Search. Patients who match criteria 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 username. 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 username 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.

Problem: CEMT stopped working after an update, and the version is in red font.

Solution: Update CEMT to the version of the database (or higher).

CEMT windows resize themselves when clicking in a grid or some text is cut off in the CEMT interface.

Solution: Override high DPI scaling behavior in Windows for CentralManager.exe (not for OpenDental.exe). See Zoom, Turn Off DPI Awareness, Option 2 for instructions.