Manage database connections

You manage database connections from the Databases Options dialog.

• On the Insert tab, click Databases, and then click Manage Database Connections

You can edit an existing connection to change or correct its information, duplicate a connection to re-use its information for a new connection, or delete a connection that is no longer needed.

You can also export connection information to an .xml file for re-use, and import connection information from a file exported by you or by another user .

Edit a connection

1. On the Insert tab, click Databases, and then click Manage Database Connections

2. Select the connection to modify in the list, and then click Edit.

3. Modify the connection information, and then click Test Connection to verify it. See Connection troubleshooting if the connection is not successful.

4. Click OK.

Duplicate a connection

1. On the Insert tab, click Databases, and then click Manage Database Connections

2. Select the connection to duplicate in the list, and then click Duplicate.

A duplicate connection is created in the list. You can edit it to change its name and information.

Delete a connection

1. On the Insert tab, click Databases, and then click Manage Database Connections

2. Select the connection to remove from the list, and then click Delete.

Export connections

You can export the information for database connections you have created to a file for re-use in order to make the connections available:

• When you use MindManager on a different system

• If you send a map that contains database topics to other users, to enable them to update and edit the data

• If you add a map that contains database topics to a Mindjet Catalyst workspace, to enable other members to update and edit the data.

To export connections:

1. On the Insert tab, click Databases, and then click Manage Database Connections

2. Click Export Database Connection

3. Select the connections you want to export from the lists (press CTRL and click to select multiple connections).

• Connections on this computer shows all the database connections currently available on your system.

• Connections in open maps shows only the connections in use.

The information for all the connections you select is saved in a single file.

4. Click Select and choose the location to save the file, or browse to an existing file to overwrite it.

5. Click OK.

Import connections

You can import the information for database connections from a file exported by MindManager:

• To use the connections with MindManager on a different system

• If you have received a map that contains database topics from another user, and you want to update or edit the data

• To use a Mindjet Catalyst workspace map that contains database topics, and you want to update or edit the data.

To import connections from a file:

1. On the Insert tab, click Databases, and then click Manage Database Connections

2. Click Import Database Connection.

3. Select the file you want to import connections from, and then click Open.

4. The imported connections will appear in your list.

5. To verify a connection, select it in the list, click Edit, and then click Test . See Connection troubleshooting if the connection is not successful.

A username and password is not included in exported SQL connection files. You must edit the imported connection to enter this information before you can use the connection.