cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Feb 04, 2019 07:26 PM
Updated by: