Providing Your Own FME Flow Database Schema, Name, or User

Introduction

In a distributed or fault-tolerant installation of FME Flow, you can provide your own database server. SQL scripts are provided to create the FME Flow database. For instructions, please see the documentation Provide a Database Server. 

This article provides steps to modify the SQL scripts if you need to provide your own database schema, database name, or database user name. The database name and database user name in the scripts are defined in the FME Flow installer, but can be changed post-installation before the scripts are run.

The SQL scripts are on the FME Flow Core machine. The default locations are:

• Windows: <FMEFlowDir>\Server\database\<DatabaseType>
• Linux: /opt/fmeflow/Server/database/<DatabaseType>

Provide Your Own Database Schema

PostgreSQL

To use your own PostgreSQL database schema instead of the default public schema used in the script, please see FME Flow Database on PostgreSQL with a Custom Schema.

SQL Server

To use your own SQL Server database schema instead of the default dbo schema used in the script, please see FME Flow - Creating the FME Flow Database on SQL Server

Provide Your Own Database Name

Open the <DatabaseType>_createDB.sql script for your database type. Find the database name provided during installation and replace it with the new name. You will need to modify the <DatabaseType>_createUser.sql script to reflect the new database name.

Provide Your Own Database User

Open the <DatabaseType>_createUser.sql for your database type. Find the user name provided during installation and replace it with the new name. 

If you are using SQL Server as your database, you may also want to modify the login name to match.

If you are also changing the database name from what was provided during installation, then the new database name must also be updated in this script.