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

You can connect to unlimited databases using the CEMT. You can 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 target database when connecting through CEMT.
• Dynamic Mode (launch mismatched version): Use when you need to connect to a database from a different version of Royal dental Software without updating or downgrading your local client.
  • When checked, if the selected server and database are running a version different than the currently installed version on the workstation, Royal dental Software will automatically create a temporary install of the server's version of the Royal dental Software client into a dynamic folder (typically C:\Program Files (x86)\Royal dental Software\DynamicMode) and launch 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.