COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: Kory on 20 Apr 2006 01:09:55 PM

Title: RestoreSampleDatabase
Post by: Kory on 20 Apr 2006 01:09:55 PM
Would someone please give me step by step instructions on how to restore the sample databases. All the steps after restoring are well written by the help documentation, but I do not know how to restore them. I know from reading one post that I have to use Enterprise Manager. I need someone to give me step by step instructions - I've never done this before.
Thanks In Advance!
Title: Re: RestoreSampleDatabase
Post by: smiley on 20 Apr 2006 06:41:45 PM
Asuming sql server here:

Ask your dba to restore database backup file "GOSL", "GORT" and "GOSLDW".
These are found in c8\webcontent\samples\databses\sqlserver (or something like that path, don't have a C8 in front of me)

Ask your dba to create an sql user called "samples" (with for simplicity, the same password)
Ask the dba, to make this new "samples" user, db_owner of the 3 restored databases.

Copy  c8\webcontent\samples\content\cognos_samples.zip to: c8\deployment.

Open cognos connection, go the data sources, and create a new datasource for each of your restored sql databases. The data source names HAVE TO BE the next format, in order to work.

db GOSL = "GoSales"
db GORT = "GoRetailers"
db GOSLDW = "Go_Data_Warehouse"

Use the "samples" user for logging into it, and make sure to tick the box that saves the password, during the datasource creation. Use the testbutton to doublecheck.

In deployment, import the cognos_samples.zip package.

The samples are now ready to use.

A full step by step is mentioned in file "inst_cr_winux.pdf" on page 163 to 172 located on both the Cognos 8 cdrom and your cognos 8 install directory.