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:

  • Oracle
  • PostgreSQL
  • SQL Server

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 a SQL Server database server, it must be secured with a valid SSL certificate.
  • 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.