COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Kanag on 16 Jun 2011 01:02:56 AM

Title: FM Packages for development & Production
Post by: Kanag on 16 Jun 2011 01:02:56 AM
Hi Guys,
             We are doing a Cognos project from scratch..

We have developed one FM model and published a package as DEV ( used for development purposes) with Datasource DEV.

For moving to Production,
                                        Do i need to develop another FM model and another package pointing to the datasource PROD?

or can i use the same model and create a new package for PROD pointing to the datasource PROD (assuming all the tables in DEV and PROD datasource are in sync)

Would appreciate the reply..,


Thanks,
KR
Title: Re: FM Packages for development & Production
Post by: Arpitagrawal9 on 16 Jun 2011 01:45:33 AM
For migrating your Model and Reports to Any other  environment.
Create the DSN for Dev environment and publish the package there once the package is published you can create a DSN for Prod environment with the same name and migrate the same package using Export and import from Cognos Connection.

Or you can use Tools like MotiCI for Migration
Title: Re: FM Packages for development & Production
Post by: Kanag on 16 Jun 2011 03:50:28 AM
Hi Arpit,
            Do u mean to say that Model would be only one and Datasource alone would be changed ( PROD in case of Production, DEV in case of development) in creating a new package for production?

Thanks,
KR
Title: Re: FM Packages for development & Production
Post by: Arpitagrawal9 on 16 Jun 2011 03:57:33 AM
See you also dont need to create a new package

Example
Suppose your Database name for devloment is Adventure Works.So you can create a DSN Named "Adventure Works" and start building your model.Once your are done with the model you would publish the package in a particular folder of the Devenviorment.

In Production enviorment you can create the DSN with the same name but poiting to production database.Now to use the model originally created you can export the complete folder from dev enviorment and import in the prod.Hence as you have created Data Source with the same name package would automaticlly point to Prod database.

So you dont need to created Seprate models for both.

In case you still have doubts you can give me a call.I will explain you the process

Hope this helps  :)
Title: Re: FM Packages for development & Production
Post by: Kanag on 16 Jun 2011 04:45:01 AM
Thanks a lot Arpit..,

Will keep u engaged with my questions :)  :)  (if any , in future)

Regards,
KR