Upgrade from BusinessObjects Enterprise XI or XI Release 2 to BusinessObjects Enterprise XI 3.1 SP3 › 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 about the database server that you select, and login credential information for the account used for connecting to the database instance. The database account requires permissions to add and drop tables, as well as 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.

   All the information required for each database type is as follows:

   MySQL

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

   Sybase

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

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

   DB2

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

   Oracle

   • Server: tnsnames connect identifier
   • Login credentials used to access 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 or 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 or 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.

   All the information required for each database type is as follows:

   MySQL

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

   Sybase

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

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

   DB2

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

   Oracle

   • Server: tnsnames connect identifier
   • Login credentials used to access 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.