FME Options: Database Connections

Workbench: Select Tools > FME Options and click the Database Connections icon.

Use the Database Connections window to manage database connections.

To add a database connection

It is usually more convenient to add a database connection at the time you want to use one in a workspace. However, you can also add a connection directly in FME Options Database Connections, and use this connection later in a workspace.

1. Click the Add button .
2. In the Add Database Connection dialog, specify the database type and connection parameters, and click Save.

Visibility: This field applies only if Connection Storage, as specified in Tools > FME Options > Default Paths, is a shared location visible to multiple users. Specify whether the connection is available only to yourself, or to any user of the database (Public). For more information, click Help from the Default Paths window under Tools > FME Options.

Note: The following characters are not allowed in connection names: ^ \ / : * ? " < > | & = ' + % #

Tip: To populate the Add Database Connection dialog with the parameters of an existing connection, select a connection and click , and edit as desired.

To edit a database connection

You can edit the connection parameters of an existing database connection. After you edit, all workspaces that use the connection will use the new parameters to connect.

1. Double-click the connection you want to edit.
2. On the editing dialog, edit the connection parameters as desired, and click Save.

To change the visibility of a database connection

You can specify whether a connection is available only to yourself, or to any user of the database that it references. You do not have to be the creator of a connection to make this change.

1. Ensure that Data Path and Public Key File in Tools > FME Options > Default Paths > Connection Storage reference a common, shared location visible to multiple users.
2. Ensure that you have manually moved the fme_connections.data and fme_publicKey.jceks files referenced by Data Path and Public Key File to the location specified in step 1.
3. On the Database Connections dialog (Tools > FME Options> Database Connections), check the box under Public that corresponds to the connection you want to make available. Or, to restrict the connection to yourself, clear the box.

To remove a database connection

• Select the connection and click the Remove button .

To change the storage location of the connections file

You can change the location where the connection configuration file is stored. This change is made in the Tools > FME Options > Default Paths tool.