Change data source for the reports - urgent

[sg24]

Hi,

I want to change the data source to 'Hr' for the reports as all the reports are pointing to a different data source . Please let me know the steps to change.

Thanks in Advance.

Thanks,
Sg

[blom0344]

A report works on a package. The package uses 1 or more datasources. So, pointing reports to another database is normally handled in Administration --> datasources. You will need to make sure the database structures are alike to prevent problems

[ksr]

Steps to Modify a Connection

In IBM Cognos Connection, in the upper-right corner, click Launch, IBM Cognos Administration.

On the Configuration tab, click Data Source Connections.

Click the data source for which you want to modify the connection.

Click the set properties button  for the connection you want to modify.


Create or Modify a Data Source Signon

You add signons to existing data source connections so that users do not have to enter database credentials when they run reports. When you create a signon, you specify the users and groups that can access the signon. The user ID and password that make up the signon must already be defined in the database.

For information about creating groups, see Users, Groups, and Roles.

You can modify an existing signon if the credentials used to log on to the database change, or if you want to change who can use the signon.

Steps to Create a Signon
In IBM Cognos Connection, in the upper-right corner, click Launch, IBM Cognos Administration.

On the Configuration tab, click Data Source Connections.

Click the data source, and then click the connection to which you want to add a new signon.

Click the new signon button .

In the name and description page, type a unique name for the data source signon and, if you want, a description and screen tip, and then click Next.

Type the User ID and Password to connect to the database, and click Next.

The Select the users page appears


Click the Connection tab.

If you want to change the data source type, click an item in the Type drop-down list.

Click the edit icon  to modify the connection string.

[Arsenal]

There are 2 things here - changing a "database" within a datasource and changing the "datasource" that the package refers to.

So, for example if your package was created using a data source named ABC and you now simply want ABC to point to another database you would some of the steps mentioned by KSR above.

However, if you need to change the datasource(for example, from ABC to XYZ) of the package itself (suppose you have other packages that use ABC and these packages need the existing database so you can't change the database) then you will have to do it via Framework Manager after you create the datasource XYZ (again, follow some of the steps KSR mentions). In FM, it's a bit of a pain because you have to import in the new datasoure and then edit all your data source query subjects to start using this new datasource - Select * from [ABC].[TableName] will need to be changed to Select * from [XYZ].[Tablename]

You could possibly do this step using xml manipulations