Reconfigure Reporting

System

Solaris 9
TS 6.7.1

We need to repoint Reporting to a different Crystal server. This is a fairly new installation. We are thinking of uninstalling Reporting module and re install using new Crystal server info.

Is there an easy way of doing this? A config file update and restart process sort of thing?

Thanks,
Krishna.

nbwoven

1.You can edit the exisiting $IWHOME/private/lib/content_center…./reporting_config.xml file
& deploy it using using install_webapps.ipl command line tool.

The following info. is changing in your case

• Crystal Enteprise Hostname (Name of the CE Server)
  
• Crystal Enteprise Root Path(Path of the CE Folder where Teamsite Reports will Reside)
  
• Datasourcename(Name of the Data sources through which CE can access Reports DB)
  
• DBname (Name of DB where TS Events are Stored will remain same)
  

2. As the TS report database information will also change use the CLT:$IWHOME/tsreport/bin/iwconfigtsreport.ipl
#iwconfigtsreport.ipl -h will show the usage information.

3. There are changes required on the New Crystal Enterprise
Server too.If you're using the Datadirect Driver then its odbc.ini should be pointing to the Reporting DB.

• It should have a ODBC System DSN entry referring to the existing TeamSite events database .
  
• There should be appropriate database client drivers installed
  
• You'll have to create the TS Report Folder and setup the Individual users on this new CR Server.
  

Hope this helps !