Upgrade from BusinessObjects Enterprise XI Release 2 to BusinessObjects Enterprise XI 3.1 SP5 › Perform a Simple Upgrade on Windows › CMS Database Configuration › Configure an Existing Database Server

Configure an Existing Database Server

The CMS Database Information screen displays if you chose to use an existing database server as your CMS for the new BusinessObjects Enterprise installation. Use this screen to configure the database server.

If you are using an existing database, ensure that you have the connection details for the database server that you select and login credential information for the account to connect to the database instance. The database account requires permissions to add and drop tables and to insert, delete, and update data in those tables.

To configure an existing database server

1. Select a database type from the Select existing CMS database drop-down list in the CMS Database pane.

   Depending on your database server selection, corresponding input fields are displayed in the CMS Database pane.

2. Provide all the required information for the database in the fields provided in the CMS Database pane.

   The following list contains the information that is required for each database type:

   SQL Anywhere

   • Data Source Name
   • Database Name
   • Server Name
   • Port
   • Login Credentials

   MySQL

   • Database: MySQL database name
   • Server: MySQL server name
   • Port: Default port is 3306
   • Login credentials to access the database

   Sybase

   • Server: Sybase Server Name
   • Login credentials to access the database

   Note: The Sybase server name is a combination of the host name and the port number which your database administrator sets in the file sql.ini.

   DB2

   • Server: DB2 database alias
   • Login credentials to access the database

   Oracle

   • Server: tnsnames connect identifier
   • Login credentials to access the database

   Microsoft SQL Server

   • ODBC DSN

   If you do not want to specify an auditing database for your new installation, skip to step 6.

3. Select the Auditing Database check box to specify an auditing database for your new installation.

   The input fields under the Auditing Database check box are activated.

   Note: If you select a BusinessObjects Enterprise XI Release 2 auditing database for BusinessObjects Enterprise XI 3.1, the installation program permanently deletes any existing auditing data from that database. This means that the data will not be available after the upgrade is complete. If you want to keep auditing data from BusinessObjects Enterprise XI Release 2, select a new database for BusinessObjects Enterprise XI 3.1.

4. Select a database type from the Select existing Auditing database drop-down list in the Auditing Database pane.

   Depending on your database server selection, corresponding input fields are displayed in the Auditing Database pane.

5. Provide all the required information for the database in the fields provided in the Auditing Database pane.

   The following list contains the information that is required for each database type:

   SQL Anywhere

   • Data Source Name
   • Database Name
   • Server Name
   • Port
   • Login Credentials

   MySQL

   • Database: MySQL database name
   • Server: MySQL server name
   • Port: Default port is 3306
   • Login credentials to access the database

   Sybase

   • Server: Sybase Server Name
   • Login credentials to access the database

     Note: The Sybase server name is a combination of the host name and the port number which your database administrator sets in the file sql.ini.

   DB2

   • Server: DB2 database alias
   • Login credentials to access the database

   Oracle

   • Server: tnsnames connect identifier
   • Login credentials to access the database

   Microsoft SQL Server

   • ODBC DSN
6. Select the Reset existing database check box to delete all current tables and entries in the existing database.

   Note: This option permanently deletes all of the contents of the existing database that you select.

7. Click Next to continue with the installation setup.

   The Select Web Application Server screen displays. This screen only displays if a connection is established with the database configuration you provided.