Provide a Database Server

FME Flow uses its own database to manage jobs and workspace information. It is not a source or destination data source for FME workspaces.

To ensure the FME Flow Database remains available in a failover scenario, provide a machine on which to install the database that is physically separate from the machines on which the FME Flows are installed. In addition to being physically separate, the database server should, by itself, be configured for fault tolerance.

You can choose to install a PostgreSQL database that is included with the FME Flow installer, or you can configure the FME Flow Database on your own database server. If you use your own database server, keep in mind the following:

  • PostgreSQL (recommended), Oracle, and SQL Server are supported. The following versions are recommended:
    • Note  PostgreSQL is the recommended database server with FME Flow, offering enhanced performance and stability through targeted optimizations.
    • PostgreSQL: 16.1 or later.
    • Oracle: 19c or later.
    • SQL Server: 2016 or later.
  • When you install the FME Flows, the database server must be running and you must know the connection information.
  • If using an Oracle database server, you must obtain the Oracle Database JDBC driver. For more information, see https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html.
    • Note  Oracle Database JDBC driver versions that use ojdbc10.jar are not supported.
  • Following installation, you must be able to create a new database on the server using SQL scripts.

For information about acquiring a fault-tolerant database server, consult your IT department.

Updating the FME Flow Database Password

If you choose to install a PostgreSQL database that is included with the FME Flow installer, and want to update the password for the database user account, follow these instructions: