COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: CogConsult on 06 Aug 2015 01:35:06 PM

Title: Changing DB type in catalog
Post by: CogConsult on 06 Aug 2015 01:35:06 PM
A client has an existing installation of Cognos Impromptu 7.4 and is going to stick with it.

However, the underlying database that's being pulled from is going to change from Btrieve/Pervasive to MS SQL Server. The schema will stay essentially the same (some fields may flip between date and text).

It should be possible to just edit the catalog to point to the new DB server and provide the same environment, right? Will the reports themselves need to be changed as well?