Is it possible to use the Amazon Relational Database Service as a database hosting for FlexiCapture Database?
Yes, it is possible to use Amazon Relational Database Service as a database hosting for FlexiCapture Database, since when using the MS SQL Server deployed at AWS RDS, you deal with SQL Server as it is. Also, AWS RDS allows you to use not only MS SQL but several different database engines (for example, Oracle Database or PostgreSQL).
Please note that the RDS supports “Always on” availability, which requires the parameter MultiSubnetFailover=True in the connections string of the Application Server. It’s not set by default and has to be added manually to web.config file of the Application Server.
To add this parameter, follow the steps below:
- On the computer with Application Server installed, open C:\inetpub\wwwroot\FlexiCapture12\Server\web.config file in any text editor.
- Find the <connectionStrings> tag at the end of the file.
- Find the connectionString parameter, add a ";" before the closing quotation mark, and add the MultiSubnetFailover=True parameter.
If you use MS SQL Server or Oracle Database of supported versions hosted at AWS RDS, it is a legitimate and supported configuration for the FlexiCapture database server. However, please note that the platform may have its own limitations or special features that may make using it less comfortable or incompatible with desired configurations.