Provide a Database Server

FME Server 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 Server 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 Servers 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 Server installer, or you can configure the FME Server Database on your own database server. Here are some considerations, depending on which you choose:

Using the Database Included with the Installer

As a security precaution, we recommend updating the password for the FME Server Database following installation. If the password is not updated, a user with knowledge of the default settings for connecting to the FME Server Database may log in and make changes.

To update the FME Server Database password (Windows)

  1. Start pgAdmin4.exe from <FMEServerDir>\Utilities\pgsql\pgAdmin 4\bin\.
  2. If this is your first time starting pgAdmin4, it will prompt you to set a master password. Choose something you will remember.
  3. If pgAdmin auto-connects to the FME Server Database, an entry appears in the Object browser, under Servers, similar to the following:

    4. fmeserver (<hostname>:7082)

    If pgAdmin III does not auto-connect to the FME Server Database, add a new Server for it. To add a New Server:

    1. Right-click on Servers and Select Create > Server....
    2. In the General tab of the Create - Server dialog, specify the Name for the server connection. This can be anything, such as fmeserver.
    3. In the Connection tab of the Create - Server dialog, specify the server properties, using the Database Connection details in the fmeCommonConfig configuration file, for DB_TYPE=postgresql, as follows:

      4. Property

      Value from fmeCommonConfig.txt
      Host name/address DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name>
      Port DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name>
      Maintenance database DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name>
      Username DB_USERNAME=<username>
      Password DB_PASSWORD=<password>

    4. Click Save.
  4. In the Object browser, select the FME Server Database server, and locate and expand Login/Group Roles.
  5. Right-click the fmeserver database user account and select Properties. Under Definition, change the Password and click Save.
  6. In the following configuration files, update the value of the DB_PASSWORD parameter that corresponds to DB_TYPE=postgresql with the new password specified above.

    7. When finished, save both files.

  7. (Recommended) Encrypt the FME Server Database password.
  8. Restart FME Server.

To update the FME Server Database password (Linux)

  1. Open a command prompt and changen to the following directory:

    2. <FMEServerDir>/Utilities/pgsql/bin

  2. Run the following command to connect to the FME Server Database:

    3. ./psql -d <databaseName> -p <port> -U <username>

    To confirm the settings, check the Database Connection details in the fmeCommonConfig configuration file, for DB_TYPE=postgresql, as follows:

    Property

    Value from fmeCommonConfig.txt
    -d DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name>
    -h DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name>
    -p DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name>
    -U DB_USERNAME=<username>
    Password ( when prompted) DB_PASSWORD=<password>

  3. Once connected, enter the following command to change the password for your user:

    4. \password

  4. Use \q to quit psql.

  5. In the following configuration files, update the value of the DB_PASSWORD parameter that corresponds to DB_TYPE=postgresql with the new password specified above, and save the files.
  6. (Recommended) Encrypt the FME Server Database password.
  7. Restart FME Server.

Using Your Own Database Server

If you use your own database server, keep in mind the following:

  • PostgreSQL, Oracle, and SQL Server are supported. The following versions are recommended:
    • PostgreSQL: 9.5.6 or later.
    • Oracle: 12c or later.
    • SQL Server: 2014 or later.
  • When you install the FME Servers, 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.
  • 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.