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.

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 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.