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.

When configuring a fault tolerant environment for FME Flow, you must provide your own database server on which to configure the FME Flow database. Supported database servers include PostgreSQL (recommended), SQL Server, and Oracle.

Provide a database server that is physically separate from the machines on which the FME Flows are installed. Separating the FME Flow Database ensures that it also remains available in a failover scenario.

When providing a database server, keep in mind the following:

• In addition to being physically separate, the database server should, by itself, be configured for fault tolerance.
• 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 and place it in the following directory:
  

  • Windows:
    • <FME FlowDir>\FMEFlow\Utilities\jdbc
  • Linux:
    • /opt/fmeflow/Utilities/jdbc

  Driver versions recommended: 12.1 (ojdbc7.jar), 12.2 (ojdbc8.jar), 18.3 (ojdbc8.jar), 19.3 (ojdbc8.jar), 19.3, 19.6, 19.7 (ojdbc8.jar).
  

  Driver versions not recommended: All ojdbc10.jar versions.

  For more information, see https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html.

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