Setting up an Empty Database for the CMS

If you want to use an existing database server as the Central Management Server (CMS) or auditing database, you must create a new tablespace or database before installing BusinessObjects Enterprise.

The installer will prompt for the connection and authentication details if you choose to use your own database during the installation of BusinessObjects Enterprise. The following database servers are supported for the CMS system and audit databases:

·            SQL Anywhere

·            Microsoft SQL Server (ODBC)

·            Oracle

·            DB2

·            MySQL

·            Sybase IQ

Review the online BusinessObjects Enterprise supported platforms document for information supported platforms document for information related to supported database software and version requirements: "service.sap.com/pam" .

·            Create a new tablespace, schema, or database (the exact terminology will depend on the database platform you're using) to act as the CMS database. Create a second for the auditing database, if you plan to enable auditing.

·            Create a new user account and password to be used by BusinessObjects Enterprise to access the CMS database. Create a second username and password if you plan to enable auditing.

·            Specify that the new user account has required permissions to create, modify, and delete tables and create procedures so that database can be modified as required.

·            Record the name of the database(s), the user account(s), and the password(s) you created, so you can enter the details when you run the BusinessObjects Enterprise installer.

During the installation, you can choose to reinitialize the existing database. This will cause new tables to be created in your existing database. Consult your specific database server documentation if you are unsure of the procedure for creating a new tablespace, schema, or database. Ensure that your database server is set up to use Unicode character encoding (such as UTF-8).

If you have a previous release of BusinessObjects Enterprise you cannot use your database from a previous release for BusinessObjects Enterprise. You must create a new database, or existing data from the previous release will be destroyed. To migrate from an previous release, create a new database migrate your old content to the new current version's database after the installation is complete.