***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