Skip to Content

The following options are available to connect BO server to Native HANA and BW on HANA.

1. SAP BAPI

2. OLAP SAP BICS Client

3. OLAP SAP HANA Client

4. Relational DB Connection (JDBC / ODBC)

SAP BAPI:

Business Application Programming Interface (BAPI) is traditional method used to connect BO server (3.x systems) to BW BEx Queries.

This connection is used by Universe Design Tool (UDT) to access BW cubes.

BAPI connection created on BEx Query. So for each query, one BAPI connection need to be created.

temp.PNG


OLAP SAP BICS Client


OLAP SAP BICS Client (Business Intelligence Consumer Service) connectivity is widely used to connect BO (4.x) Servers to BW Systems.

This Connection can be created via Information Design Tool (IDT) or BOE/BI Server console.

This Connection can be created with or without mentioning the Bex Query name.

So We can able to create reports on multiple BW cubes with one BICS connectivity.


From WebI, using this Connectivity We can create report directly on Bex Query.

No Universes are (Middle Layer) needed.


temp.PNG



OLAP SAP HANA Client:


OLAP SAP HANA Client connectivity is widely used to connect BO (4.x) Servers to Native HANA Systems.

This Connection also can be created via Information Design Tool (IDT) or BOE/BI Server console.

This Connection can be created with or without mentioning the HANA Column view name.

So We can able to create reports on multiple HANA Models with one BICS OLAP HANA Connectivity


In this Connection all Analytic Views and Calculation Views will be treated as Cube.

temp.PNG

This connectivity used by Design Studio, Lumira to create the reports.

temp.PNG

Relational DB Connection (JDBC / ODBC) :


This is relational DB connectivity.

We could not access the Table from OLAP HANA connection.

Here We have access for HANA Table also along with Models.


temp.PNG


This connectivity used by IDT for Universe Creation and used in BO Business Explorer Reporting tool.


temp.PNG


Best Regards,

Muthuram

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Hari Putumbaca

    Hi Muthuram
    Can you please provide information on
    1) Authorization model between BO and HANA
    2) Like BW, can we import the HANA Roles to BO and link then to the BO Groups?

    Please suggest

    Thanks
    Hari

    (0) 

Leave a Reply