This document will show you the step-by-step instructions on how to install a MySQL database for use as a Central Management Server (CMS) repository.
SAP BI Platform 4.0 is a powerful and robust Business Intelligence suite that delivers feature rich content in an easy to use interface. You can use Crystal Reports, Web Intelligence Reports, Xcelsius documents to give your end users a diverse and exciting view on normally bland data.
Behind the scenes, SAP BI suite requires a Central Management System (CMS) database to control operations such as clustering, users and groups, object security and more. With previous releases of BI 4.0 (XI R2 and XI 3.1) MySQL was the default bundled database. With BI 4.0, the bundled database is Microsoft SQL Server 2008 with Windows, and IBM DB2 with UNIX. This fundamental change in default databases has led to some confusion on how exactly to get MySQL setup since it was done all for you before.
This guide will show basics on how to setup a MySQL database on Windows. There will be some additional wiki articles outlining how to use this MySQL database as a repository for SAP products such as SAP BI Platform 4.0, Information Platform Services (IPS) and more.
Operating Systems: Microsoft Windows Server 2008 R2 64-bit
Database: MySQL 5.1.58 (5.0.91Client used)
** VMWare VCenter Lab Manager is used for the Windows environments **
Installing MySQL database
This section will outline the steps used to install MySQL to Microsoft Windows 2008 R2. MySQL can be downloaded from here: http://downloads.mysql.com/archives.php
** Please ensure that MySQL 5.0 or 5.1 is used. BI 4.0 SP02 does not support MySQL 5.4 or 5. **
The version that was downloaded is 5.1.58 for Windows (Microsoft Windows (Windows Installer format)). After downloading, run the setup and you should be presented with the following installation screenshots:
** UTF-8 character set should be used here instead of the Standard Character Set **
Creating a MySQL Database
Althought the installation is now finished, it does not create a database by default. You will have to create one manually. To do this, we use MySQL Command Line Client located in Start > All Programs > MySQL > MySQL Server 5.1. You will be prompted for a password, this is the password that was used during the installation steps
Upon successful login, you will be presented with the following screen.
** If the screen disappears, then you have entered an incorrect password. **
Run the following command to create a new database.
This will create a simple database that can be used for the SAP BI Platform products.
Creating a User
The root user is installed by default with a MySQL installation. Although you can use this account as a schema, it is a best practice to use a separate user. Run the following two commands
In layman's terms, the above command is saying "Create the user of name xxxx on the following machine with the password of xxxx". The BI4 name and password can be anything you want. The IP Address that is being used is the IP address of the machine that has MySQL machine.
After this command is ran, you can verify the users were created successfully by running
You will now need to grant these users permission to access the database structure.
This above command will grant full permissions on the BI4 database to the BI4 user @ the hostname provided. The IP Address used here is for the machine that is going to be accessing MySQL.
The database is now ready to be used. There will be some additional guides on how to connect SAP BI Platform 4.0 to this newly created MySQL database.