BO is a 30 years old French company. BO have the following kind of tools.
1. EIM (Enterprise Information Management) : In this space BO have 2 tools.
i) BODI (Business objects data Integrator)
ii) BODS (Business objects data services) : It is a combination of BODI, Quality Services.
2. EPM (Enterprise performance Management): In this space BO have a tool called as BPC (Business objects planning & Consolidation).
3. GRC (Governance & Risk & Control ): This tool is used to generate reports for scent lies calculations.
4. BI (Business Intelligence) : This space BO have the following BI tools.
i) Web I (Web intelligence)
ii) Crystal Reports
iii) Xcelsius
iv) BI widgets
v) Voyager
BI Stands for Business Intelligence. It is an approach to collect Business Data from different data sources, Integrating into big Data source ( Data warehouse) and generate reports to simplify decision making.
R/3 => BW => BEx
Data source Integration(Data warehouse) Reporting
Non-SAP => BODI => BO
Company Name | ETL Tool | DB Tool | Reporting Tool |
SAP | BW/BODS | R/3, ECC | BEx/BOBI |
Oracle | ODI(Oracle Data Integrator) ODW | SQL, PL/SQL | SIBEL Analytics |
IBM | Data Stage | DB2 | Cognos |
Microsoft | SSIS | SQL Server | SSRS/SSAS |
Available ETL Tools in the Market
1. Informatica => Informatioca Corporation
2. BW/BODS => SAP
3. Data Stage => IBM
4. JCM => Apple
5. Abentio => Abentio Corporation
6. ODW => Oracle
7. SSIS => Microsoft
Available DB tools
1. SQL/PLSQL => Oracle
2. My SQL => Apache
3. SQL Server => Microsoft
4. Sy Base => Sy Base IQ
5. Tera Data => NCR Corporation
6. NETEZZA => NETEZZA Corporation
7. DB2 => IBM
Available Reporting tools
1. JASPER => Apache
2. BOBI => SAP BO
3. Cognos => IBM
4. Micro Strategy => Micro Strategy Corporation
5. JERKING => JETKING
6. SSRS => Microsoft
7. Sieble Analytics => Oracle
Hardware & Software Requirements
1. Non-SAP BO Installation:
HDD : Minimum 5 GB Space
RAM : 512 MB
Processor : Any Processor (Celron, Pentium, ……)
OS : ALL O.S ( XP, W7,Vista, Unix,…………..)
2. SAP BI BO (Without ECC)
HDD : 20 GB
RAM : 2GB/3GB
Processor : Dualcore and Above
OS : All O.S
In the Developer machine they need the below software
a. SAP GUI
b. Business Object (BO) Client
c. Integration Kit Between SAP BI & BO
MDX SQL
d. Crystal Reports (online) (OLTP)
e. Xcelsius (For Dash Boards)
f. Voyager
g. Widgets (For mobile Reporting)
End user need not to install any S/W, in their load system, They can access all the reports through the web by using the Infoview portal.
è Comparison between SAP & Business Objects
Report Type | SAP Tool (.BEx) | BO – Tool |
Ad Hoc (Drill – Down) | BEx Analyzer | WEBi |
OLTP(Transactional Reports/online) | Report Designer | Crystal Reports |
Dash Boards | WAD (Web Application Designer) | Xcelsius |
Portal | EP (Enterprise Portal) | Info view |
ETL Tool | BW | BODS (New Version) BODI – Older Version |