Installation Guide › Installing a Windows Implementation › (Optional) Create an External Report Database on Microsotft SQL Server

(Optional) Create an External Report Database on Microsotft SQL Server

The optional external report database exports data for use by other applications. Extracted data is stored in a dedicated SQL database on a Microsoft SQL Server database server.

• When Microsoft SQL Server hosts CA RCM databases, the installer automatically creates this database when you select the External Report Database option.
• When an Oracle database server hosts CA RCM databases, follow this procedure to create the External Report Database on a Microsoft SQL Server instance after you install CA RCM.

To create an external report database on Microsoft SQL Server

1. Verify that a local instance of Microsoft SQL Server is available.
2. (AIX/WebSphere only) Copy the CA-RCM-12.5-sp2-Core.zip file from the CA RCM installation package to a temporary location, and extract the file.
3. Open a command prompt window, and navigate to the folder that contains the DButil utility.
   • For CA RCM server on JBoss/Windows, browse to:

     RCM_install\Server\eurekify-jboss\bin
     

     Note: RCM_install is the CA RCM installation directory.

   • For CA RCM server on AIX/Websphere, browse to the following extracted directory:

     \CA-RCM-12.5-sp2-Core\Utils&Conf\DB Utility
     

4. Enter the following command:

   dbutil -c_rdb -d reportdb_name -h localhost -u user_name -p password
   

   Note: reportdb_name is the name of the external report database, localhost is the host name or URL of the Microsoft SQL server instance, user_name and password are the login credentials of the administrator account on the database server.

   The external reports database is created on the database server. The following confirmation message appears.

   Create Reporting Database completed successfully
   

5. Define a Microsoft SQL Server JDBC datasource for this database
   • For CA RCM server on JBoss/Windows, browse to:

     RCM_install\Server\eurekify-jboss\server\eurekify\deploy
     

     Edit the reportdb-ds.xml file so that the datasource uses the hostname and credentials of the Microsoft SQL Server.

   • For CA RCM server on AIX/Websphere, use the WebSphere application server to define and assign a datasource for this database in the CA RCM server cluster.