Skip to main content
Released

Improve FME Server Installer with optional advanced Database Options for Distrib

Related products:FME Flow
barrett_h
  • barrett_h
    barrett_h

steveatsafe
Safer

***Note from Migration:***

Original Title was: Improve FME Server Installer with optional advanced Database Options for Distributed DB


With the increasing use of Distributed and Fault Tolerant Environments the installer lacks the ability to customize the FME Server System Database connection settings and provides only basic settings (host & port). In High Availability and Fault Tolerant environments these are typically not enough and users must edit config files to complete the connection settings. (in +2020.0 this is now two files).


The FME Server System Database can be stored in SQL Server, Oracle, & PostgreSQL. The drivers used are Java based and the installer provides hostname and port options.

The installer could be expanded to provide optional jdbc parameters much like the FME Workbench Database Connection dialog does when using the JDBC Reader/Writer format.


The SQL Server database is most often requiring this customization the JDBC Parameters. Some examples are:

serverName=<hostname>

databaseName=<databasename>

instanceName=<instancename>

portNumber=<#####>

MultisubnetFailover=true

integratedSecurity=true


It is proposed when performing a Distributed Database (or FT) install that adding a drop down to select the database type and provide options (check boxes) to include additional connection string parameters to add to the config file. (or type in manual parameters) would be helpful and reduce the need to edit config files after installation completes.


Related Ideas:

SQL Server and Dynamic Port Allocation https://community.safe.com/s/idea/0874Q000000TlFqQAK/detail

SQL Server and Windows Authentication https://community.safe.com/s/idea/0874Q000000TlbHQAS/detail

This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

rudy_v
Contributor
Forum|alt.badge.img+6
  • Contributor
  • August 13, 2020

yes please - pain to manual config these settings - in a distributed, you only have it once for the first install, the second install should already have it as you specify the system shared


rylanatsafe
Safer
Forum|alt.badge.img+13
  • Safer
  • October 28, 2020

These changes will be implemented in FME Server 2021.0 – if you would like to test it out, please use Build 21217 or newer from https://safe.com/downloads. Our 2021.0 documentation will be updated accordingly.

 

Note: FME Server 2021.0 documentation is available at http://docs.safe.com/fme/2021.0/html/FME_Server_Documentation/Home.htm


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings