How do I check / change the FNMSDatawarehouse connection?

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).