Skip to Content
Author's profile photo Glen Spalding

Install BOBJ4 on SAP MaxDB

Here I install the BOBJ4 on a SAP Max DB database, and not the packaged MS SQL.

I will download the database software, install it, create a database, then begin the BOBJ4 installation.

Here’s a summary of what’s coming

  • System
  • Download
  • MaxDB DBMS Install
  • MaxDB Studio Install
  • MaxDB Database Creation
  • MaxDB Post Installation
  • BOBJ4 Install
  • Test


I have a very basic system for demonstration. Here are the VM details.


Loopback adaptor, as there is no DHCP server present.



About 10GB already used


Current existing directories


In “Program Files”


In “Program Files (x86)”

All current services


In Control Panel->Programs and Features

Note: Java VM 64bit is required, for MaxDB Studio


Windows Start->Programs



This time, I found it from SDN, Downloads, half way down SAP MaxDB software of version 7.8. This link is likely to expire. But you should be able to perform a search on “MAXDB 7.8”, in Installations and Upgrades on the SMP.

There are two files to download, the actual DBMS, and the DBMS Management tool (Studio).


Files and sizes


MaxDB DBMS Install

Note, you will need the 64bit JVM already installed, see System, above.

I began by running the downloaded “exe”, to commence setup

It begins



The license stuff



Nothing to do next



I kept the defaults 



I kept the defaults



I chose NOT to create a database, as I would do this manually, after installation. But I guess it could be done here.

I kept the other defaults.

Note the “Network Port Number”. This is a parameter we will be using for the BOBJ4 install, later.






and … 


In Start->Programs 


And now to view what Windows Services aquired

2 extra ones here


and 2 extra ones here


MaxDB Studio Install

Now to install Studio, the DBMS GUI Manager, from the downloaded “exe” to commence installation




License stuff



I kept defaults






and finished


A look at what new Windows Services we now have, presents an extra MAXDB entry.


Windows Programs


MaxDB Database Creation

For the BOBJ4 installation, we need to create a database. This can be performed during the database installation, however, I chose to create it manually here, for demonstration purposes.

I began by running the “Database Studio”. For the first time, a “User management” screen appears.


Shortly after, I was presented with a blank Studio canvas


Now to create the database


I created the database by, right-clicking on the “Servers”, then to Administrator Tasks->Create Database…

I kept the default



I supplied the Database Name “BOBJ4”. You will need to remember this for the BOBJ4 installation.



Important: I kept the default User Name “DBADMIN”, and gave it a password. In my case “abcd1234”. I am showing you this now, as it will need to be supplied during the BOBJ4 installation, ONLY IN CAPITALS !



I Kept all defaults



I kept defaults



I chose to put the logging mode to “Overwrite”. Without this, the BOBJ4 installation will fill it up the log, and not complete, until you return to the log and either extend, delete or use overwrite








Now in Studio, we can see our BOBJ4 database


Another look at the Windows Services reveals an extra three “MAXDB” entries


 and an extra “XServer” entry



MaxDB Post Installation

I started the BOBJ4’s specific database Service found on port 7200, so that the BOBJ4 installation can see it.


I changed the System Environment Variable, “PATH”, to include the following path.

C:Program FilessdbMaxDBpgm


I’m not a MaxDB person in the slightest, so any other deeper information, will have to be sought elsewhere, but here’s a good start


BOBJ4 Install

Now on to the actual BOBJ4 installation. I zip through the standard installation screens, and pay more attention to the separate database selection screens.










Now to deselect the “Integrated Database” option, so I will be prompted for my specific database 




 From the selection of Database Types, I chose “MaxDB”



I didn’t care much for installing the Audit Database



I supplied the SIA “Node Name”





Now to supply the Database parameters

CMS Database Name: “BOBJ4”. Set during the creation of the database. Parameter name “Database Name”, see section “MaxDB Database Creation”.

MaxDB Server: “localhost”. Self explanatory.

MaxDB Port: “7200”. Set during the installation of the DBMS. Parameter name “Network Port Number”, see section “MaxDB DBMS Install”.

Username: “DBADMIN” (must be supplied in capitals, regardless of what you actually used during the database creation). Set during the creation of the database. Parameter name “User Name”, see section “MaxDB Database Creation”.

Password: “ABCD1234” (must be supplied in capitals, regardless of what you actually used during the database creation). Set during the creation of the database. Parameter name “Password”, see section “MaxDB Database Creation”.









Nearly a couple of hours past




“Finish” and Re-boot the System


After much trial and error, I eventually managed to successfully test my installation. Here are the steps I followed

1. Stop SIA

In the Central Configuration Manager (CCM), I stopped the SIA Server.


2. Start MaxDB BOBJ4

In Windows->Services, I started the MaxDB BOBJ4 Service – “MAXDB: BOBJ4”


FYI, there are four other MaxDB Services, that start automatically

  • XServer
  • XServer-7200
  • XServer-7299


3. Wait

I waited a couple of minutes for the “MAXDB: BOBJ4” to complete


4. Start the SIA

In the CCM, I started the SIA Server


5. Wait

This one is important. I had to wait a good ten to twenty minutes for the SIA to complete it’s important Services.

This is where I was going wrong. I tried too soon, and was receiving the following message




So …

Q: How long to you wait for ?

A: When you can successfully log into the SIA Manage Servers (see next)


In CCM, select the “Manage Servers” icon for the SIA


Supply your User Name & Password


Wait until you can see all the SIA Servers “Enabled”, & “Running”



Finally, log on to the Central Management Console (CMC)


Again, a little waiting game for Tomcat to initially get going, and finally




Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Julien Bras
      Julien Bras
      For info, have you ever try to install BOBJ4 on a MySQL5 DB server ? I have tested, but it complains about a missing lib...
      Author's profile photo glen spalding
      glen spalding
      Blog Post Author
      no i have not, i could if i could get my hands on it
      Author's profile photo Former Member
      Former Member
      Thank you for your post.

      > Here I install the BOBJ4 on a SAP Max DB database, and not the packaged MS SQL.

      Does anyone know why with BOBJ 4.0 packaged database MS SQL - why not ASA. Both on win and unix-like OSes ?
      It will be logical step to populate ASA in the world. And if SAP get good discount for customers, who use BO on Sybase - thats will be interesting and predictible. Maybe first 3 years without support fee or something.
      Sybase an SAP company or not 🙂

      Author's profile photo Julien Bras
      Julien Bras
      And what is ASA ?

      And instead of MS SQL, how BI4 is packaged on Unix/SOlaris/Linux OS ? without any database ?

      Author's profile photo Former Member
      Former Member
      Sorry,  i mean sybase adaptive server - ASE )), not ASA (Sybase SQL Anywere)
      Author's profile photo Former Member
      Former Member
      Is i khow BI4 is packaged on Unix/SOlaris/Linux OS with DB2. ))) Strange isn't it?