Prepare to Install › Prepare an Existing Database Server

Previous Topic: SQL Anywhere Database Requirements

Next Topic: Before Deploying Web Applications

Prepare an Existing Database Server

After you have created your database, set up the database client, and before you install BusinessObjects Enterprise, ensure that the CMS can connect to it. During your installation, you are asked whether you want to install SQL Anywhere or you want to use an existing database. If you opt to use an existing database, you are asked for the connection and authentication details by the BusinessObjects Enterprise installer:

Existing Database

Information Required by Installer

SQL Anywhere
  • Data Source name
  • Database name
  • Server name
  • Port number (default is 2638)
  • Login credentials to access the database

MySQL
  • Database name
  • Server name
  • Port number (default is 3306)
  • Login credentials to access the database

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 interfaces file.
  • BusinessObjects Enterprise connects to the default database for the user you specify. The database administrator sets this default.

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 name from the Windows System DSN