Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Purpose

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. 

Overview

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.   


Background

Environment Details

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. 


CREATE DATABASE BI4;                         

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

CREATE USER ‘BI4’@‘localhost’ IDENTIFIED BY ‘vanpassword’;
CREATE USER ‘BI4’@‘10.167.195.5’ IDENTIFIED BY ‘vanpassword’;


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

SELECT USER, HOST, PASSWORD from mysql.user; 




Granting Permissions

You will now need to grant these users permission to access the database structure. 

GRANT ALL ON BI4.* TO ‘BI4’@‘localhost’;
GRANT ALL ON BI4.* TO ‘BI4’@‘10.167.195.5’;

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. 


Related Documentation

Related Notes