The CEMT is designed to be a central hub for managing separate Open Dental databases. In an ideal situation:
- There is only one CEMT database that is connected to and used by the CEMT program. Using only one CEMT database avoids concurrency issues.
- CEMT users are created with unique names in the CEMT database.
- Connections are set up to each Open Dental database.
- Each Open Dental database uses the same version as the CEMT database.
- Security settings in the CEMT database, including users, are synced to each Open Dental database.
- CEMT users log into the CEMT tool, then launch a connection to an Open Dental database
- A user's CEMT credentials will log the user into the Open Dental database automatically.
Use the CEMT
- Create and use one CEMT database for all CEMT users.
- Create a CEMT user for each person who will use the CEMT and assign them security permissions. These permissions will restrict or grant access to certain areas of Open Dental databases (just like other Open Dental users).
- Create a connection for each Open Dental database the CEMT will manage.
- Refresh Connection on each connection, then Sync all security settings to all Open Dental databases.
- Have the user log into the CEMT using their CEMT username and password.
- The User can double click a connection to launch Open Dental and connect to the Open Dental databases. Logging on to the Open Dental database will be automatic with the permissions set in the CEMT.
- Manage all CEMT users in the CEMT only and sync to all Open Dental database after any change. This will avoid any concurrency issues.
There is no reason to use multiple CEMT databases. As of version 16.2, it is not allowed. Multiple CEMT databases only creates additional work for users and complicates syncing of users and security settings. All security changes in one CEMT database would need to be synced to all other CEMT databases and all Open Dental databases for all databases to remain accessible. Otherwise you could face some of these challenges:
- If a user exists in one CEMT database but not the other, syncing Open Dental databases from one will insert the user into the Open Dental database, while syncing from the other will remove the user.
- If users have different usernames or passwords in each CEMT database, the Open Dental databases will reflect whichever credentials were synced last.
- If users have the same usernames but different passwords, the Open Dental passwords will reflect the passwords synced last. However, a user won't know which password is correct when logging in to the Open Dental database. They will have to try them all or sync with a CEMT database they know the password for.
- Security permissions for users will reflect the permissions of the CEMT database synced last.
Other concurrency issues may also occur.