Redirecting a current Model to a new Data Source (Framework Manager Cognos 10.1)

[CalebMF]

Hello
I had a Model that was built off of a Data Source (Microsoft SQL Server (OLE DB)). Well, the Server was recreated, and moved to a new server.
Anyway, I created the new Data Source but did not imput it into my current Model. What is the easiest and most proficient way to redirect the old Model to the new Data Source?
Thank you
Caleb

[RKMI]

Hi Caleb,

So if your server moved and I'm guessing your tables didn't change and also no colums for tables were renamed/ added/ removed.

If this assumation is correct then you can just add addtional connection to your new server under same datasource in cognos adminstration configuration> datasources connection select the datasource and inside you will see the previous connection and you will have a button on top to add a new connection (Please note you need cognos adminstration access to view and set up this connection or pass the instructions mentioned).

Coming to the model/report, So when you run the report you will get a prompt to select the connection and select the new one and reports should run as intended. If this test passes then you can remove the previous data source connection and move forward. This is the easiest and smoothest way if nothing other than you server was changed... else you need to do what I mentioned then also tend to the table which might have got renamed when the moved occured. Hope this help and makes sense.

Thanks,
RK

[CalebMF]

Hi Caleb,

So if your server moved and I'm guessing your tables didn't change and also no colums for tables were renamed/ added/ removed.

If this assumation is correct then you can just add addtional connection to your new server under same datasource in cognos adminstration configuration> datasources connection select the datasource and inside you will see the previous connection and you will have a button on top to add a new connection (Please note you need cognos adminstration access to view and set up this connection or pass the instructions mentioned).

Coming to the model/report, So when you run the report you will get a prompt to select the connection and select the new one and reports should run as intended. If this test passes then you can remove the previous data source connection and move forward. This is the easiest and smoothest way if nothing other than you server was changed... else you need to do what I mentioned then also tend to the table which might have got renamed when the moved occured. Hope this help and makes sense.

Thanks,
RK

This is perfect. Worked like a charm. Thanks so much.

[RKMI]

Your are welcome.  ;D +1 applaud ?  ;)

Thanks,
RK