Steps to repoint a Business Objects Universe to a new reporting database (for Software Compliance Manager or Asset Portfolio Management 12.x installations)
book
Article ID: 49610
calendar_today
Updated On:
Products
CA Automation Suite for Data Centers - Configuration AutomationCA Client Automation - Asset ManagementCA Client Automation - IT Client ManagerCA Client AutomationCA Client Automation - Remote ControlCA Client Automation - Asset IntelligenceCA Client Automation - Desktop Migration ManagerCA Client Automation - Patch ManagerCompliance Manager for z/OSCA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Issue/Introduction
Solution:
Log onto the Business Objects server. Launch the Business Objects designer from the start menu
Login as Administrator and the main design window launches
From the File menu, select Import to import an existing universe
Click Browse to locate the CA Allegheny universe and click OK
Click OK on the next screen to import the universe. You'll see a message that the universe imported successfully
From the File menu, choose Parameters
Click EDIT to edit the 'Allegheny' connection
Change the server name and the port number to point to a new MDB server name
For example: tcp:<MyDBServerName>,1433 (NOTE: 1433 is the port number for a sql server default instance) If using a named instance, use this syntax: tcp:<NamedInstance>\<MyDBServerName>,1433
Click Text Connection to verify the database connectivity
Click next a few times to go through all the screens (keeping defaults), then click finish.
Click OK, to return to the main Universe window
Close the Business Objects designer universe and save the changes on exit.
Restart the Server Intelligence Agent service
On the SWCM web server machine
Edit the SWCM\Web Server\web.config file
Change the following keys to point to the new Business Objects machine
<add key="ReportingWebServiceServer" value="<Your BO Server Name>:<port#>" />
Note: Launch Business Objects Java Infoview on the Business Objects server to obtain the correct port number.