In the Central Enterprise Management Tool ( CEMT ), click Setup, Connections.

Connect to unlimited databases using CEMT. Also group connections together to make running reports easier.

View Connections:

• Connection Groups: Connections can be grouped together. See CEMT Connection Groups.
• Search: Search for a connection. Connections search as characters are typed.

Add: Click to add a new connection. See below for details.

Conn. Order:

• Up / Down Arrows: Highlight a connection, then click to reorder it in the list.
• Alphabetize: Click to order connections in alphabetical order.

Prefs:

• Automatically Log On: Check to automatically log on to the target database when connecting through CEMT.
• Dynamic Mode (launch mismatched version): Use to connect to a database from a different version of Open Dental without updating or downgrading the local client.
  • When checked, if the selected server and database are running a version different than the currently installed version on the workstation, Open Dental automatically creates a temporary install of the server's version of the Open Dental client into a dynamic folder (typically C:\Program Files (x86)\Open Dental\DynamicMode) and launches the program from there.

Add or Edit a Connection

Click Add, or double-click an existing connection to edit.

Enter connection details, then click OK.

• Direct Database Connection: Enter the Server Name, Database, MySQL User, and MySQL Password. (see MySQL Security).
• Middle Tier Connection: Enter the Middle Tier connection details. This is rare and should only be used if not using a direct database connection.
• Show clinic breakdown on reports: Check to enable clinic breakdowns on reports generated for this connection through CEMT.
• Note: Enter any notes regarding this connection. Note can be used to alphabetize the list.