SAP BO BI Solutions Architecture:
Connectivity to SAP HANA
ODBO - OLE DB for OLAP
1)
ODBO – OLE DB for OLAP
a.
Microsoft-driven specification for
Multidimensional reporting
b.
Request are sent to the DB via MDX
2)
ODBC -Open Data Base Connectivity
a.
Microsoft-driven specification for Relational
reporting
b.
DB requests are made via SQL
c.
Heavily adopted in industry
d.
No longer Microsoft centric -Unix and Linux
drivers exist for ODBC
3)
JDBC – Java Data Base Connectivity
a.
Relational reporting driver specified by the
java community. Popular on Unix platforms
4)
BICS – BI Consumer Services
a.
SAP proprietary interface that offers advantages
for OLAP access over MDX on multidimensional reporting objects
b.
Common driver technology used by SAP BO
Analysis, office edition and semantic layer based BO clients for connectivity
to SAP NetWeaver BW
1)
What is the connection and requests sent for:
Crystal Reports 2011 vs CR 2013 vs CR for
enterprise to SAP HANA DB?
1)
CR 2011: JDBC + SQL
2)
CR 2011: ODBC + SQL
3)
CR Enterprise: JDBC/ODBC + SQL
2)
What is the connection and request for Webi and
Dashboards to SAP HANA DB?
a.
JDBC/ODBC + Semantic Layer (relational Universe)
+ SQL
3)
What is the connection and request for Design
Studio to SAP HANA DB?
a.
BICS/JDBC + SQL
4)
What is the connection and request for Analysis
Office to SAP HANA DB?
a.
ODBC/BICS + SQL
5)
What is the connection and request for Analysis
OLAP to SAP HANA DB?
a.
BICS/JDBC + SQL
6)
What is the connection and request for BEX(Explorer)
to SAP HANA DB?
a.
JDBC + SQL
7)
What is the connection and request for Lumira to
SAP HANA DB?
a.
JDBC + SQL
No comments:
Post a Comment