How to change the datasource of existing package in cognos 8.3

[Manik Goel]

I am using cognos 8.3

I have existing package ABC and data source DATA_TEST poiting to database STAGE.

This datasource is used by other packages as well.

Here, I need to change the data source of existing package ABC only. So I have created new data source DATA_PROD, because it should not impact other packages.

Please share the steps to change the datasource of existing package in cognos 8.3

[MFGF]

I am using cognos 8.3

I have existing package ABC and data source DATA_TEST poiting to database STAGE.

This datasource is used by other packages as well.

Here, I need to change the data source of existing package ABC only. So I have created new data source DATA_PROD, because it should not impact other packages.

Please share the steps to change the datasource of existing package in cognos 8.3

You need to open the model the package was published from in Framework Manager. Add your new data source into the list of data sources in your model, then modify each data source query subject to point to this.

Cheers!

MF.

[bdbits]

If you are brave, you can open the model in a text editor and modify the data source name. If you do this and have problems, and support figures out that you did this, it will most likely be unsupported.

Just a thought, but you appear to be using data source name to differentiate between test and prod (and maybe others). This is really not a good idea. You should use a generic name for your data source, then point it to the correct database (test/prod) in the connection setup. Then when you migrate from your test server to your prod server, you will not have any Cognos changes to make other than setting up the (generic-named) data source if it does not already exist.