SQL-Server endpoint - option to select a different account for windows authentication mode
When creating a new end-point, either for source or target, Qlik Replicate provides 2 options Windows Authentication and SQL Server authentication.
The "Windows Authentication" option is our preferred, more secure option and reduces the burden of managing multiple DB accounts, however QR does not allow one to select a different account, it leverages the underline account that runs the service.
Which increase security exposure as a QR uses the same elevated account that runs it service and connects to multiple databases.
Would it be possible to enable an option to indicate which service account should be used? There will some scenarios where access to DB are very restricted and we are trying to avoid using SQL Server authentication.