If you are unable to create a new account, please email support@bspsoftware.com

 

Switch Model from development to production datasource

Started by zerointeractive, 05 Jun 2007 08:24:00 AM

Previous topic - Next topic

zerointeractive

Hi everybody,

i'm relatively new to Cognos FM and i have the following problem.

I have successfully built my package in a development enviroment (Cognos in localhost), and now I want to move it into our production environment (a Cognos stand-alone server).

The problem is that the production enviroment uses a different datasource name (although the tables schema is the same) than the development one and I'm now facing how to "switch" the name of the datasource that the package relies on.

I think I can do the trick by replicate the datasource in Cognos Connection, obviously with a different name then delete the development datasource and then renaming the production datasource connection to the one used by my package.
But I don't know if this is a good idea.  ???

So, is there a way to do the "switch" without re-importing and re-modeling the package based on the production enviroment?




Any help would be appreciated,

Luigi






Desperado

If you want to change the DS name entirely , i think it may not be possible , but you can make the existing DS to point out to production.
If you want to cahnge the DS Name , there is one approach. open the model.xml using a xml editor like editplus, and then replace it with the new name(lets say, Prod) and save it .
create a new datasource(Prod) in FM pointing to the prod database.
Thats it ..

The other method is

create a connection to your production DB (DS ). Edit the schema name and CM data source.
then it will work

zerointeractive

[...] open the model.xml using a xml editor [...] :o

That's what I was looking for! ;D

thank you