Summary
Here is the instructions for checking / changing the datawarehouse connection
Synopsis
For updating the DataWarehouse connection in the ComplianceConnection table, there is no interface to edit the connection details.
Discussion
This can safely updated directly, since it uses integrated authentication. To update the connection details use the following queries (this is for single tenant on-premises installation):
For updating both DB server and the DB name
update ComplianceConnection set Server = '<servername>', DatabaseName='<dbname>' where SourceType='FNMPDataWarehouse'
or For updating only the DB sever name
update ComplianceConnection set Server = '<servername>' where SourceType='FNMPDataWarehouse'
or For updating the DB name
update ComplianceConnection set DatabaseName='<dbname>' where SourceType='FNMPDataWarehouse'
Registry
The following registry key also needs to be modified
"HKLM\Software\Wow6432node\Managesoft Corp\Managesoft\Reporter\CurrentVersion" and update the connection string in the registry key "FNMPDWDatabaseConnectionString"
Update the references in Cognos. This can be edited through Cognos administration (i.e. as a web admin in Cognos Connection/Administration).
Additional Information
There is a bug - FNMS-25922 : Unable to Configure FNMPDataWarehouse DB connection details from UI