Administration Guide › How to Configure Reporting › Create a Database Connection to the Report Server

Create a Database Connection to the Report Server

To allow the report server to access the reporting information in the database, create a database connection to the report server.

Follow these steps:

1. Log on to the system where you installed CA Business Intelligence.
2. Install the Client Software that is associated with your database (Microsoft SQL or Oracle).
3. Go to Start, Programs, BusinessObjects XI 3.1, BusinessObjects Enterprise, Start to start the Universe Designer.
4. Log in as an administrator.
5. Import the CA GovernanceMinder universe as follows:
   1. Go to File, Import to import a universe.
   2. Click Browse and Select CA Universes, CA GovernanceMinder.
   3. Select the CA GovernanceMinder universe under available universes.
   4. Click OK.
6. Define a new connection as follows:
   1. Go to File, Parameters.

      The Universe Parameters screen appears.

   2. Click New and Next to start the connection wizard.
   3. Enter a connection name and select a driver as follows:
      • Microsoft SQL 2005 or 2008: OLE DB Providers
      • Oracle 10 or 11: Oracle Client
   4. Provide database credentials.
   5. Click Finish and click Test to test the connection.
   6. Click OK.

      The Universe Parameters screen closes.

7. Save the universe and export the changes to the report server as follows:
   1. Go to File, and click Save.
   2. Go to File, Export.
   3. Click OK.

   The changes to the universe are successfully exported and the database connection object is created.